PL-900 Demonstrate the capabilities of Power Apps Practice Test 1 — 15 Questions

Question 1

A retail company uses Power Apps to build a mobile app for store managers to approve discount requests. The app must work offline and sync when connected. Which type of app should the developer choose?

Accepted Answer

Canvas app. Canvas apps are the correct choice because they support offline capability by leveraging the Power Apps offline sync feature, which allows data to be cached locally on the device and synchronized with the data source (e.g., Dataverse or SharePoint) when connectivity is restored. This makes them ideal for mobile scenarios like store managers approving discount requests in areas with intermittent connectivity.

Answer

Portal

Answer

Model-driven app

Answer

Power Automate

Question 2

A healthcare organization needs a Power Apps app to track patient visit data. The data must be stored in Microsoft Dataverse, and the app should automatically generate a timeline of visits for each patient. Which app type is most suitable?

Accepted Answer

Model-driven app. A model-driven app is the most suitable choice because it is designed for complex, data-centric business applications that require rich relational data modeling, automated business logic, and built-in timeline controls. Dataverse provides the underlying relational storage, and model-driven apps natively support timeline components that automatically aggregate and display patient visit records in chronological order without custom development.

Answer

Portal

Answer

Power Automate

Answer

Canvas app

Question 3

A company has a canvas app that uses a SharePoint list as its data source. The app works fine for most users but a few users report that they cannot submit new items. They receive a generic 'Access denied' error. What is the most likely cause?

Accepted Answer

The users lack write permissions on the SharePoint list.. The 'Access denied' error when submitting new items in a canvas app connected to a SharePoint list indicates that the user lacks write permissions on the underlying data source. Even though the app is shared with the user, the SharePoint list itself enforces its own permission model. Without Contribute or Edit permissions on the list, the user cannot create new items, resulting in the generic access denied error.

Answer

The connection reference is not shared with the users.

Answer

The SharePoint list has exceeded its item limit.

Answer

The app is shared with 'Can edit' permission but not 'Can view'.

Question 4

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 5

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 6

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. An offline profile in Microsoft Dataverse defines which tables, columns, and relationships are available when the app is disconnected. It enables the Power Apps mobile player to cache data locally and synchronize changes automatically when connectivity is restored. Without an offline profile, the app cannot determine what data to store or how to resolve conflicts during sync.

Answer

Power Automate flow triggered on data change

Answer

SharePoint list as data source

Answer

Common Data Service (Dataverse) database

Question 7

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.. Option A is correct because 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 8

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 9

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.. Option D is correct because 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 10

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.. Option B is correct because 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 11

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 12

Which TWO of the following are capabilities of Power Apps that help organizations build custom business applications without writing traditional code?

Accepted Answer

Integration with Common Data Service (Microsoft Dataverse). Option A is correct because Power Apps integrates directly with Microsoft Dataverse (formerly Common Data Service), which provides a secure, scalable data platform for storing and managing business data. This integration allows users to build apps that leverage Dataverse’s built-in business logic, security roles, and relationships without writing custom code. Option B is correct because Power Apps offers a library of pre-built templates (e.g., for expense reports, asset management) that can be customized to fit specific business needs, enabling rapid application development with minimal technical effort.

Answer

Natural language processing to create conversational bots

Answer

Automated workflows triggered by business events

Answer

Real-time data dashboards with drill-down analytics

Question 13

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. Option B is correct because 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 14

Drag and drop the steps to deploy a solution from a development environment to a production environment in Power Platform in the correct order.

Question 15

Match each Power Virtual Agents feature to its purpose.