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

Question 1

A business analyst wants to create an app that uses a SharePoint list as its data source. They need to include conditional formatting to highlight overdue tasks. Which type of app should they use?

Accepted Answer

Canvas app. A canvas app is the correct choice because it allows full control over the user interface and supports conditional formatting using Power Apps formulas. The business analyst can connect to a SharePoint list and use functions like If and Color to highlight overdue tasks based on due dates. Canvas apps are ideal for custom designs and data-driven formatting.

Answer

Power Virtual Agents chatbot

Answer

Model-driven app

Answer

Power BI report

Question 2

An organization has a model-driven app built on Dataverse. Users report that when they try to save a record, they receive an error about missing required fields, but they believe they filled them in. What is the most likely cause?

Accepted Answer

A business rule is setting a field as required based on conditions. Business rules can dynamically set field requirements based on conditions, which may cause users to see missing required fields even if they filled in all originally required fields. Option B is incorrect because write permissions would prevent saving entirely, not just show missing required fields. Option C is incorrect because Power Automate flows run after a record is saved, not before, so they cannot block the save. Option D is incorrect because custom connectors are used for integrating external systems, not for Dataverse field validation.

Answer

The user does not have write permissions to the Dataverse table

Answer

A Power Automate flow is blocking the save

Answer

A custom connector is failing to validate data

Question 3

A user built a canvas app that uses a SharePoint list. When they add the app to a Teams channel, some users cannot see the data. The app works fine when opened directly from Power Apps. What is the most likely cause?

Accepted Answer

The users do not have permissions to the underlying SharePoint list. The most likely cause is that users do not have permissions to the underlying SharePoint list. When the app is accessed via Teams, the app runs in the context of the user, and SharePoint permissions are enforced. Even though the app works when opened directly from Power Apps (if the user has permissions), adding it to a Teams channel may expose users who lack access to the list. Option A is incorrect because licenses are per user and not specific to Teams; if users have Power Apps licenses, they can use the app. Option B is incorrect because the app works outside Teams, so the connector is not deprecated. Option D is incorrect because the SharePoint connector does not require a Premium license in Teams.

Answer

The users do not have Power Apps licenses assigned

Answer

The app uses a deprecated connector

Answer

The SharePoint connector requires a Premium license in Teams

Question 4

A sales team needs an app to track customer interactions. The app should display a list of accounts, and when an account is selected, show related opportunities and contacts. Which type of app is best suited?

Accepted Answer

Model-driven app. Model-driven apps are ideal for complex, data-centric scenarios where the app is built on top of Microsoft Dataverse. They automatically generate a UI based on the data model, including relationships between entities like Account, Opportunity, and Contact. When an account is selected, the app can display related records through built-in navigation and subgrids, exactly as required. This makes model-driven apps the best fit for tracking customer interactions with linked entities.

Answer

Canvas app

Answer

Power BI dashboard

Answer

Chatbot in Power Virtual Agents

Question 5

A user created a canvas app to collect feedback. The app writes data to an Excel file stored in OneDrive. When multiple users submit feedback simultaneously, some entries are lost. What is the most likely cause?

Accepted Answer

Excel is not designed for concurrent multi-user writes. Excel files stored in OneDrive are not designed for concurrent multi-user writes; when multiple users submit simultaneously, the file locking and sync behavior can cause writes to overwrite each other or fail silently, leading to lost entries. This is a fundamental limitation of using Excel as a database for multi-user apps.

Answer

The app has a performance issue

Answer

The Excel file is locked by OneDrive sync

Answer

A Power Automate flow is delaying the write

Question 6

An organization is building a model-driven app on Dataverse. They need to ensure that only managers can delete records, and all other users can only edit them. What should be configured?

Accepted Answer

Create custom security roles with different privileges for managers and others. Custom security roles in Dataverse define privileges at the entity level, including Create, Read, Write, Delete, Append, and Append To, with access levels (User, Business Unit, Parent: Child Business Unit, Organization). By creating separate roles for managers and other users, you can grant Delete only to managers while giving others Write access. This is the native, supported way to enforce record-level permissions.

Answer

Add a business rule that checks user role before delete

Answer

Implement a Power Automate flow that cancels delete

Answer

Use a business process flow to restrict delete

Question 7

Which THREE are capabilities of model-driven apps?

Accepted Answer

Business process flows to guide users through steps. Model-driven apps in Power Platform are built on the Common Data Service/Dataverse and provide several declarative capabilities. Option A is correct because business process flows are a core model-driven feature that guides users through defined stages and steps of a process. Option D is correct because model-driven apps support server-side logic through classic workflows and Power Automate cloud flows, which run on the server and automate business processes. Option E is correct because business rules in model-driven apps enforce field requirements, set field values, and control visibility without writing code. Option B is not correct because custom CSS is not a supported styling mechanism for model-driven apps; they use a standardized, metadata-driven UI with themes rather than custom CSS. Option C is not correct because pixel-perfect drag-and-drop layout design is a characteristic of canvas apps, not model-driven apps, which generate UI from the data model and forms.

Answer

Custom CSS to style the app

Answer

Pixel-perfect layout design using drag and drop

Question 8

Which TWO are benefits of using Dataverse as the data source for Power Apps?

Accepted Answer

Rich relationships between tables. Option D is correct because Dataverse natively models one-to-many, many-to-one, and many-to-many relationships between tables, which Power Apps can traverse through lookups and related-record navigation without custom code. Option E is correct because Dataverse provides a built-in security model with business units, security roles, teams, and column-level (field-level) security, so Power Apps inherits row- and field-level access control automatically. Options A, B, and C are not Dataverse benefits: Dataverse is a relational (not graph) store, it does not automatically export data to Excel (users can export manually or via integrations), and it does not expose a SQL query engine for app makers — SQL-style access is only available through T-SQL endpoints for analytics, not as a general Power Apps query capability.

Answer

Built-in support for graph data

Answer

Automatic Excel export

Answer

Ability to run complex SQL queries

Question 9

Which TWO are benefits of using model-driven apps over canvas apps? (Choose two.)

Accepted Answer

Built-in business process flows. Option C is correct because model-driven apps are built on Microsoft Dataverse and include business process flows natively, allowing organizations to define and enforce multi-stage processes (such as lead-to-opportunity stages) directly within the app's data model without custom development. Option D is correct because model-driven apps use a component-based, metadata-driven UI that automatically renders a responsive, adaptive layout across devices (desktop, tablet, mobile) based on the underlying form and view definitions, so designers do not have to build separate layouts. Options A and E are incorrect because they describe canvas apps, which offer a free-form drag-and-drop designer with full pixel-level layout control and Excel-like Power Fx formulas for complex logic. Option B is incorrect because both canvas and model-driven apps require appropriate Microsoft Power Platform and Microsoft Entra ID-based licensing; model-driven apps do not eliminate Entra ID licensing requirements.

Answer

Easier to create complex formulas

Answer

No Microsoft Entra ID licensing required

Answer

Unlimited custom layout control

Question 10

You are designing a canvas app for field service technicians. The app must capture photos of equipment and store them with the service record. Which control and data source combination is most suitable?

Accepted Answer

Camera control with Microsoft Dataverse. The Camera control in Power Apps captures photos directly from the device camera, and Microsoft Dataverse provides a secure, scalable data store with native support for image columns and relationships to service records. This combination is ideal for field service technicians who need to attach photos to structured service data with offline and security capabilities.

Answer

Add media control with Excel Online

Answer

Attachments control with SharePoint list

Answer

Image control with SharePoint list

Question 11

You have a canvas app that uses a SharePoint list as its data source. The app needs to filter records based on the current user's email. Which function should you use in the Items property of the gallery?

Accepted Answer

Filter(SharePointList, Email = User().Email). The User() function returns a record with the current user's details, including Email. Option A is incorrect because the Search function is used for searching text across multiple columns, not for filtering by exact match. Option B is incorrect because CurrentUser is not a valid function; the correct syntax is User().Email. Option D is incorrect because Lookup returns a single record, not a filtered set of records.

Answer

Search(SharePointList, User().Email, "Email")

Answer

Filter(SharePointList, Email = CurrentUser.Email)

Answer

Lookup(SharePointList, Email = User().Email)

Question 12

You are designing a Power Apps solution for a global sales team. The app must display data in the user's local time zone. The data is stored in Dataverse in UTC. What is the best practice for time zone handling?

Accepted Answer

Store times in UTC and let Power Apps handle conversion automatically. Best practice for time zone handling in Power Apps with Dataverse is to store all datetime values in UTC and let the platform handle conversion to the user's local time zone automatically. Dataverse stores datetime fields in UTC and the Power Apps client automatically converts them to the user's local time zone based on their device settings or user profile. This ensures consistency and avoids errors from manual conversions.

Answer

Convert UTC to each time zone using Power Fx formulas

Answer

Store local time in the database based on user's location

Answer

Use a Power Automate flow to convert time zones

Question 13

A company is building a canvas app to track inventory. The app needs to display the current stock level from a SharePoint list and allow users to update quantities via a form. Which connector should be used to read and write data?

Accepted Answer

SharePoint connector. The SharePoint connector is the correct choice because it provides native, bidirectional access to SharePoint lists, which are the data source described in the scenario. It supports both reading current stock levels (via Get items) and writing updates (via Create item or Update item) directly from a canvas app. Since the inventory data already resides in a SharePoint list, this connector is the most direct and appropriate integration point. Other connectors either serve different services or are not designed for direct data manipulation in this context.

Answer

Power Automate connector

Answer

Microsoft Dataverse connector

Answer

Microsoft Teams connector

Question 14

A model-driven app uses a business process flow to guide users through a sales process. The flow has multiple stages, and users complain that they can move to the next stage without completing required fields. What should the app maker do to enforce data entry?

Accepted Answer

Set the fields as required in the business process flow stage. Setting fields as required in the business process flow stage ensures they must be filled before progressing to the next stage. Option A is incorrect because setting fields as business required in the entity applies globally, not just within the flow, and would affect all forms and views. Option C is incorrect because validation rules apply to the field's data integrity, not to flow stage transitions. Option D is incorrect because making fields read-only would prevent data entry entirely, not enforce required completion.

Answer

Set the fields as business required in the entity

Answer

Add a validation rule on the entity fields

Answer

Make the fields read-only in the business process flow stage

Question 15

A user wants to create an app that allows employees to submit expense reports from their mobile devices. The app should capture photos of receipts and store them. Which type of app is most suitable?

Accepted Answer

Canvas app. A canvas app in Power Apps provides a blank canvas where the maker designs the UI and logic from scratch, making it ideal for a mobile-friendly expense reporting app with custom photo capture and storage. Canvas apps offer full control over layout and can integrate with the camera control and connectors to store images. This matches the requirement for a tailored mobile experience.

Answer

Model-driven app

Answer

Power Apps portal

Answer

Power Automate flow