PL-900 Demonstrate the capabilities of Power Apps — 25 Questions

Question 1

A company wants to build a Power Apps app that uses a SQL Server database as its data source and requires complex business logic validation before saving data. Which type of app should they use?

Accepted Answer

Canvas app. Canvas apps are the correct choice because they allow full control over the user interface and can incorporate complex business logic validation using Power Fx formulas before data is written to the SQL Server database. Unlike model-driven apps, which rely on predefined forms and server-side business rules, canvas apps enable custom validation logic directly in the app's formulas, such as checking multiple field conditions or calling custom connectors.

Answer

Model-driven app

Answer

Power Automate

Answer

Portal

Question 2

A company has a model-driven app with a custom table 'Issue' that has a choice column 'Status' with values: New, In Progress, Resolved, Closed. The app uses a business rule to set 'Resolved By' (lookup to User) when status changes to Resolved. Users report that the 'Resolved By' field is not being populated. What is the most likely cause?

Accepted Answer

The business rule is scoped to the form but the status change happens via a quick create form.. Business rules in model-driven apps can be scoped to either the entity (all forms) or a specific form. If the rule is scoped to a particular form (e.g., the main form) but the status change occurs via a quick create form, the rule will not trigger. This is the most likely cause because users report the field is not populated, indicating the rule is not firing in the context where the status is being changed.

Answer

The 'Resolved By' lookup column is not added to the form.

Answer

The 'Resolved By' column is required and users don't fill it.

Answer

The business rule is deactivated.

Question 3

A company is planning to build a Power Apps app for field service technicians to view and update work orders. The app must work offline and sync data when connected. Which TWO components are required to achieve offline capability?

Accepted Answer

Offline profile in Microsoft Dataverse. Option B is correct because an offline profile in Microsoft Dataverse defines which tables, columns, and records are available offline and controls how conflicts are resolved during synchronization, which is the core mechanism enabling canvas apps to work with Dataverse data while disconnected. Option D is correct because the Power Apps mobile player is the client that supports offline use, caching the offline profile's data locally and syncing changes back to Dataverse when connectivity is restored. Option A is incorrect because a Power Automate flow triggered on data change runs in the cloud and cannot provide local offline data storage or synchronization for the app. Option C is incorrect because SharePoint lists are not supported as an offline-capable data source for Power Apps and cannot be cached through an offline profile. Option E is incorrect because the Common Data Service (now Dataverse) database is the underlying data platform, but merely having the database does not by itself enable offline capability without an offline profile and a mobile client.

Answer

Power Automate flow triggered on data change

Answer

SharePoint list as data source

Answer

Common Data Service (Dataverse) database

Question 4

A company deploys a model-driven app that uses a custom table 'Project' with a status choice column. The app includes a business rule that shows a warning message when the status is set to 'Completed' but the 'End Date' is blank. The business rule works on the main form but not when records are updated via a Power Automate flow. Which THREE actions should the administrator take to enforce the rule regardless of update method?

Accepted Answer

Use a synchronous plug-in that runs on the Update message of the Project table.. A synchronous plug-in runs on the Update message of the Project table, executing immediately within the database transaction. This ensures the validation logic (checking that End Date is not blank when Status is 'Completed') is enforced regardless of the update method, including Power Automate flows, which bypass client-side business rules.

Answer

Configure an asynchronous workflow that runs after the update.

Answer

Modify the business rule to run on all forms.

Question 5

A developer is trying to create a business process flow (BPF) for the 'Opportunity' table in a model-driven app. When activating the BPF, the developer receives the error shown in the exhibit. What is the most likely cause?

Accepted Answer

The BPF is trying to use a table that is not enabled for business process flows.. The error shown in the exhibit indicates that the business process flow (BPF) references a table that is not enabled for business process flows. In Power Apps, only tables that have the 'Business process flows' option enabled in their table settings can be used as the primary entity for a BPF. The 'Opportunity' table is a standard table that is enabled by default, but if it has been disabled or the BPF is referencing a custom table that lacks this setting, activation will fail with this error. Option C correctly identifies this root cause.

Answer

The developer does not have sufficient security role permissions to activate BPFs.

Answer

The BPF has no stages defined.

Answer

The Opportunity table does not exist.

Question 6

A canvas app uses the formula shown in the exhibit to display the name of the most recently created account named 'Contoso'. The formula always shows 'No records found' even though there are accounts named 'Contoso'. What is the likely issue?

Accepted Answer

The column name in the formula uses a space and may be incorrect.. The formula references a column name with a space ('Account Name') without using single-quote delimiters. In Power Apps, when a column name contains a space, it must be enclosed in single quotes (e.g., 'Account Name') to be parsed correctly. Without the quotes, Power Apps interprets the space as a separator, causing the lookup to fail and the condition to evaluate as false, always falling back to 'No records found'.

Answer

The SortByColumns function is used incorrectly.

Answer

The First function cannot be used on a filtered result.

Answer

The formula is not delegable and returns incomplete data.

Question 7

A manufacturing company uses Power Apps to manage inventory. The app includes a main screen that displays a gallery of inventory items, a detail screen for editing item properties, and a form screen for adding new items. The app uses a SharePoint list as the data source. Recently, users reported that when they edit an item on the detail screen and save, the changes do not appear in the gallery until they manually refresh the app. Additionally, some users occasionally encounter a 'Delegation warning' when filtering the gallery by item name. The app is shared with 200 users, and performance is becoming an issue. You need to resolve these issues. Which action should you take?

Accepted Answer

Modify the detail screen's Save button to use the Refresh() function on the gallery's data source after the form submission, and change the gallery's Items property to use a Filter query on an indexed SharePoint column to avoid delegation.. The Refresh() function after form submission ensures the gallery's data source is updated immediately, eliminating the need for manual refresh. Changing the gallery's Items property to use a Filter query on an indexed SharePoint column avoids delegation warnings by ensuring the query can be processed server-side, as SharePoint supports delegation only for indexed columns and certain operators.

Answer

Convert the model-driven app to a canvas app to gain more control over data refresh and delegation.

Answer

Increase the data row limit in Power Apps settings to 2000 to prevent delegation warnings.

Answer

Migrate the data source from SharePoint to Microsoft Dataverse to eliminate delegation warnings and improve performance.

Question 8

A company needs to create a mobile app for field service technicians to view and update work orders. The app should work offline and sync when connected. Which type of Power App should they build?

Accepted Answer

Canvas app. A Canvas app is the correct choice because it supports offline capability via the Power Apps mobile player, which can cache data locally and sync changes when connectivity is restored. This is ideal for field service technicians who need to view and update work orders without constant internet access, as Canvas apps allow custom UI tailored to mobile scenarios and can leverage the Offline-first pattern with explicit sync logic.

Answer

SharePoint list app

Answer

Power Automate flow

Answer

Model-driven app

Question 9

A developer creates a canvas app to display orders from Microsoft Dataverse. The app uses the gallery and data configuration shown in the exhibit. When the app runs, the gallery shows orders but the 'View Details' button does nothing when tapped. What is the most likely cause?

Accepted Answer

The target screen 'OrderDetailScreen' does not exist in the app. The Navigate function in the button's OnSelect property references 'OrderDetailScreen', but if that screen does not exist in the app, the function cannot execute, causing the button to appear unresponsive. The gallery displays orders correctly, confirming the data source and Items property are functional, isolating the issue to the navigation target.

Answer

The button's OnSelect property has a syntax error

Answer

The Dataverse connection requires user authentication

Answer

The gallery's items property is misconfigured

Question 10

Match each Power Virtual Agents feature to its purpose.

Accepted Answer

Topics: Define conversation paths and responses.. Power Virtual Agents uses Topics to define conversation flows, Entities to extract data, Actions to interact with external systems, and Triggers to initiate topics based on user keywords. Common confusions include swapping the roles of Topics and Entities, or Entities and Actions.

Answer

Topics: Extract specific information from user input.

Answer

Entities: Call external systems or perform tasks.

Question 11

A company wants to build a Power Apps canvas app for field technicians to report equipment issues. The app must allow offline data entry and sync when connectivity is restored. Which feature should the developer enable?

Accepted Answer

Enable the 'Offline' feature in the app settings. Power Apps mobile app supports offline capabilities by enabling the 'Offline' feature, which allows data to be cached and synced later. Option D is correct. Option A is wrong because Power Automate flows can be triggered online but do not provide offline data caching. Option B is wrong because SharePoint lists require network connectivity unless using a third-party sync tool. Option C is wrong because the Common Data Service (Microsoft Dataverse) supports offline sync only when the app is explicitly configured for offline use, but the question asks about the feature to enable in the app.

Answer

Use a Power Automate flow to queue data submissions

Answer

Configure the app to store data in a SharePoint list

Answer

Use the Common Data Service (Dataverse) offline sync

Question 12

An organization uses Power Apps to submit expense reports. The app connects to Dataverse. Users report that some submissions fail with a 'table not found' error. The developer verified the table exists. What is the most likely cause?

Accepted Answer

The app's service principal lacks read permissions on the table. A 'table not found' error in a Power Apps Dataverse connection most commonly occurs when the app's service principal (or the connection's identity) lacks read permission on the table, causing Dataverse to return a not-found-style error instead of an access-denied. Granting the service principal read access on the table resolves the failure.

Answer

The table has a missing required column

Answer

The table was renamed after the app was published

Answer

The app uses a deprecated connector

Question 13

A Power Apps canvas app that uses Dataverse is being migrated from a development environment to a production environment. After migration, the app fails to load data. The developer checks the connection and finds that the Dataverse connector is pointing to the development environment. What should the developer do?

Accepted Answer

Update the connection reference in the app to use production Dataverse. When a canvas app is moved between Power Platform environments via a solution, the Dataverse connector inside the app still references the connection from the source environment. The correct fix is to update the connection reference so the app binds to the production Dataverse connection, which re-points the connector at the target environment's data. This is the standard post-deployment remediation for cross-environment connection mismatches.

Answer

Re-import the solution into the production environment

Answer

Delete the app and recreate it in production

Answer

Modify the environment variable values for the connection

Question 14

A user wants to create a Power Apps canvas app that displays data from an Excel spreadsheet stored in Microsoft OneDrive for Business. Which connector should be used?

Accepted Answer

Excel Online (Business) connector. The Excel Online (Business) connector is specifically designed to connect to Excel workbooks stored in OneDrive for Business or SharePoint document libraries, and it supports reading/writing tables within those workbooks. Since the data source is an Excel file in OneDrive for Business, this is the correct connector. It provides actions like 'List rows present in a table' and 'Add a row into a table' that work directly against the hosted workbook.

Answer

Dataverse connector

Answer

OneDrive for Business connector

Answer

SharePoint connector

Question 15

A Power Apps developer needs to create an app that uses AI Builder to extract information from invoices. The app should allow users to upload an image and then display extracted fields. Which control should be used to capture the image?

Accepted Answer

Add picture control. The Add picture control in Power Apps allows users to upload an image from their device or take a photo, and it exposes the image as a media object that can be passed to AI Builder's invoice processing model. This matches the requirement to upload an image and then display extracted fields.

Answer

Camera control

Answer

Image control

Answer

Button control

Question 16

Refer to the exhibit. The Azure RBAC custom role definition shown is assigned to a user. What can this user do?

Accepted Answer

Read and install Power Apps in resource group RG1. The custom role definition likely includes actions like 'Microsoft.PowerApps/*/read' and 'Microsoft.PowerApps/*/install' but not write or delete permissions, scoped to resource group RG1. Therefore, the user can read and install Power Apps in RG1. The correct answer is D.

Answer

Manage all Power Apps in the subscription

Answer

Create new Power Apps in resource group RG1

Answer

Edit and delete Power Apps in resource group RG1

Question 17

A user reports that a canvas app displays an error: 'The data source is not found.' The app connects to a SQL Server database via an on-premises data gateway. The gateway status shows 'Running' and the connection is configured. What is the most likely cause?

Accepted Answer

The SQL table name in the app formula is incorrect. The error 'The data source is not found' typically indicates that the app formula references a table name that does not exist or is misspelled in the SQL database. Option A is incorrect because missing environment variables cause different errors. Option B is incorrect because a deleted SharePoint list would affect SharePoint-based data sources, not SQL Server. Option D is incorrect because the gateway status shows 'Running' and the connection is configured, so the gateway is not offline.

Answer

A required environment variable is missing

Answer

A SharePoint list used in the app was deleted

Answer

The on-premises data gateway is offline

Question 18

A developer is troubleshooting a canvas app that uses a SharePoint list as a data source. The app works for some users but fails for others with the error 'Access denied.' All users have read access to the SharePoint list. What could be the issue?

Accepted Answer

The users do not have permissions to the SharePoint list. Even though all users have read access to the SharePoint list, the issue may be that some users lack specific permissions at the item or column level, or the app may be trying to access data beyond read permissions (e.g., creating or modifying items). Option B is incorrect because if the list were set to private, no users would have read access. Option C is incorrect because Power Apps licenses are not required for accessing SharePoint data through an app shared with them. Option D is incorrect because the environment does not affect data source permissions.

Answer

The SharePoint list is set to private

Answer

The users do not have Power Apps licenses

Answer

The app is in a different environment than the users

Question 19

A canvas app includes a gallery that shows a list of customers. The app loads slowly when the gallery displays more than 500 records. What is the best way to improve performance?

Accepted Answer

Apply a filter to the gallery data source. Canvas apps use delegation to push filtering and sorting to the data source; when a query is non-delegable, Power Apps retrieves only the first 500 (or 2000, depending on the connector) records and processes the rest locally, which is why performance degrades past 500 records. Applying a filter that is delegable to the gallery's data source reduces the result set at the source, so the app only pulls the records it actually needs. This is the standard, low-effort fix for gallery performance issues.

Answer

Use a non-delegable query

Answer

Convert the app to a model-driven app

Answer

Increase the gallery height

Question 20

Which TWO components are required to create a model-driven app in Power Apps? (Choose two.)

Accepted Answer

Dataverse table. Option B (Dataverse table) is correct because a model-driven app is data-first: it is generated from a Common Data Service/Dataverse data model, and at least one table (entity) must exist to define the app's data and metadata before the app can be created. Option E (Form) is correct because model-driven apps render their UI from forms (main, quick view, card, etc.) defined on those tables; a table's main form is what the app uses to display and edit records, so a form is required for the app to present data. Options A, C, and D are not required: an AI Builder model, a Power Automate flow, and a Power BI dashboard are optional add-ons that can be embedded or triggered from an app but are not prerequisites for creating one.

Answer

AI Builder model

Answer

Power Automate flow

Answer

Power BI dashboard