PL-900 Demonstrate the capabilities of Power Apps — Timed 50 Questions

Question 1

Which THREE components are part of a model-driven app? (Choose three.)

Accepted Answer

Forms. Model-driven apps are composed of components such as forms (for data entry), views (for data display), and sitemap (for navigation). Screens are not a component of model-driven apps; they are used in canvas apps. Triggers are not relevant to model-driven apps; they are used in Power Automate. Therefore, the correct three components are Forms, Views, and Sitemap.

Answer

Screens

Answer

Triggers

Question 2

A user reports that their Canvas app freezes when loading data from a SharePoint list that has grown to over 5,000 items. What is the most appropriate solution?

Accepted Answer

Add filters to the data source to delegate the query and reduce the data loaded. Power Apps uses delegation to process queries efficiently. SharePoint has a default delegation limit of 5,000 items; when a list exceeds this, the app may freeze. By adding filters that can be delegated (e.g., using operators like '=' or '>' on indexed columns), the query is executed on the server, returning only matching items. Option A is not the most appropriate because switching to SQL Server involves unnecessary migration and does not inherently solve the delegation issue; SQL Server also has limits and requires delegatable queries. Option C (Dataverse) also has delegation limits, so migrating is not a direct fix. Option D (increasing the data row limit) does not address delegation; it still loads all items into the app, causing performance issues.

Answer

Use a SQL Server database instead of SharePoint

Answer

Move the data to a Microsoft Dataverse table

Answer

Increase the data row limit in Power Apps settings to 10,000

Question 3

You are designing a model-driven app for a sales team. The app must show related opportunities on an account form using a subgrid. The subgrid should only display open opportunities. Which configuration should you apply?

Accepted Answer

Add a subgrid and select a view that filters for status equals 'Open'. A subgrid in a model-driven app can be filtered by a view that filters for open opportunities. Option B is wrong because business rules cannot filter subgrids. Option C is wrong because calculated fields modify data, not filter subgrids. Option D is wrong because workflows run in the background and don't filter subgrids.

Answer

Use a business rule to hide closed opportunities

Answer

Set a calculated field to mark opportunities as open

Answer

Create a workflow to remove closed opportunities from the subgrid

Question 4

An organization needs a Power App that allows employees to submit expense reports by filling out a form and attaching receipts. Which type of app should you create and why?

Accepted Answer

Canvas app, because it provides flexible form design and supports file attachments. Canvas apps are best for custom form-based interfaces with file uploads. Option B is wrong because model-driven apps use standard Dataverse forms, which are less flexible for custom form design and file attachments. Option C is wrong because AI Builder is an add-on capability, not a standalone app type; it can process receipts but cannot create the form itself. Option D is wrong because Power Apps portals are designed for external users, not internal employees submitting expenses.

Answer

Model-driven app, because it uses standard Dataverse forms

Answer

AI Builder app, because it can process receipts automatically

Answer

Power Apps portal, because it allows external users to submit expenses

Question 5

Refer to the exhibit. You create a policy in Power Apps using the above JSON. The policy is applied on the account entity. What will happen when an account record with revenue of $2,000,000 is saved?

Accepted Answer

The description field will be updated to 'High-value account'. The policy is a JSON business rule that sets the 'description' field to 'High-value account' when the revenue exceeds $1,000,000. Since the saved record has revenue of $2,000,000, the condition is met, so the description is updated. Therefore, Option A is correct. Option B is incorrect because the policy only updates an attribute and does not block save. Option C is incorrect because it does not change the revenue. Option D is incorrect because it does not create a task; it only sets a field.

Answer

The save operation will be blocked

Answer

A task will be created for the account owner

Answer

The revenue field will be updated to 1,000,000

Question 6

A company uses a model-driven app to manage customer cases. The app needs to ensure that when a case is resolved, the resolution time (in hours) is automatically calculated and stored in a custom field. Which feature should be used?

Accepted Answer

A real-time workflow (cloud flow) triggered when a case is resolved.. (calculated field) is incorrect because calculated fields are computed only when the record is created or updated via the form, and they cannot recalculate based on subsequent status changes. Option B (real-time workflow/cloud flow) is correct because a Power Automate cloud flow can be triggered immediately when a case is updated and, if the status is 'Resolved', calculate the resolution time and update the custom field. Option C (business rule) is incorrect because business rules run on the client side and cannot perform calculations that persist to the database or reference other record fields dynamically. Option D (scheduled flow) is incorrect because it runs on a timer, not in response to the status change, resulting in delays and potential inaccuracies.

Answer

A calculated field that computes the difference between created and resolved dates.

Answer

A business rule that sets the resolution time field when the status changes.

Answer

A scheduled Power Automate flow that runs every hour and updates resolved cases.

Question 7

An organization plans to build a Power App that will be used by external partners. The app must allow partners to log in with their own credentials (Azure AD B2B). Which feature should be configured?

Accepted Answer

Set up Azure AD B2B guest user access. Azure AD B2B enables external users to use their own identities for Power Apps. Option A is wrong because SharePoint external sharing settings are for sharing SharePoint content, not for authenticating users in a Power App. Option B is wrong because anonymous access would not require partners to log in with their own credentials. Option D is wrong because Azure AD B2C is designed for customer-facing identity management, not B2B partner scenarios.

Answer

Use SharePoint external sharing settings

Answer

Enable anonymous access in Power Apps

Answer

Configure Azure AD B2C for the app

Question 8

Which THREE actions can be performed using Power Apps AI Builder?

Accepted Answer

Form processing. AI Builder in Power Apps includes several prebuilt models. Option A (Form Processing) correctly extracts key-value pairs from documents. Option B (Text Classification) categorizes text into predefined classes. Option C (Sentiment Analysis) detects positive, negative, or neutral sentiment in text. Option D (Object Detection) is not a prebuilt AI Builder model; it requires custom training or Azure Cognitive Services. Option E (Predictive Forecasting) is not available in AI Builder. Therefore, the three correct actions are A, B, and C.

Answer

Object detection in images

Answer

Predictive forecasting

Question 9

Which TWO of the following are valid data sources for a canvas app?

Accepted Answer

SharePoint list. Options B and D are correct. SharePoint lists and SQL Server are common data sources for canvas apps. Option A is wrong because Power Pages is a website builder, not a data source. Option C is wrong because Power Virtual Agents is a chatbot builder and not a data source. Option E is wrong because Power BI is a visualization tool, not a data source.

Answer

Power Pages form

Answer

Power Virtual Agents topic

Answer

Power BI dataset

Question 10

You need to share a canvas app with all users in a specific Microsoft Entra ID group. The app connects to a SharePoint list. Which step is required to ensure users can access the app and data?

Accepted Answer

Share the app with the group and ensure the group has access to the SharePoint list. Sharing a canvas app requires both app-level sharing (via Power Apps) and ensuring the group has permissions to the underlying data source (SharePoint list). Option A is incorrect because adding users as co-owners gives them edit access to the app, but they still need data access; co-ownership is not required for usage. Option B is incorrect because a Power Automate flow is not necessary; app permissions and data source permissions are the only requirements. Option D is incorrect because granting Can Use permission only allows users to run the app, but they cannot access the SharePoint list data unless the group also has permissions to the list.

Answer

Add users as co-owners of the app

Answer

Create a Power Automate flow to grant access

Answer

Share the app with the group and grant Can Use permission

Question 11

A user wants to build a Power Apps app that connects to Microsoft Dataverse and uses AI to suggest next best actions. Which feature should they use?

Accepted Answer

AI Builder. AI Builder allows adding AI models like prediction or suggestion to Power Apps. Option A is wrong because Power Automate is for workflows, not for AI suggestions. Option C is wrong because Power Virtual Agents is for chatbots. Option D is wrong because Copilot in Power Apps is a general AI assistant, not a specific feature for suggestions.

Answer

Power Automate

Answer

Power Virtual Agents

Answer

Copilot in Power Apps

Question 12

A Power Apps canvas app uses a Microsoft Entra ID group to control access. When a new user is added to the group, they cannot access the app. What is the most likely reason?

Accepted Answer

The app is shared with individual users, not the group. The most likely reason is that the app was shared with individual users rather than the Microsoft Entra ID group. When an app is shared with a group, new members added to the group automatically get access after a short propagation period (typically minutes). If the app is shared with individual users, group membership changes do not affect access. Option A is incorrect because propagation does not take 24 hours. Option B is incorrect because re-sharing is not required when using group sharing. Option D is incorrect because caching issues are temporary and less likely to cause persistent denial.

Answer

The group membership change takes 24 hours to propagate

Answer

The app share does not automatically include new group members; the app must be re-shared

Answer

The app has a caching issue that prevents permission updates

Question 13

A company wants to build a Power Apps app that can be used offline by field workers. Which type of app should they choose?

Accepted Answer

Canvas app. Canvas apps support offline use through the Offline feature. Option B is wrong because Copilot Studio is used for building copilots, not for offline app usage. Option C is wrong because Power Pages are external-facing websites and do not support offline. Option D is wrong because Model-driven apps have limited offline capabilities and are not designed for offline-first scenarios like Canvas apps.

Answer

Copilot Studio

Answer

Power Pages

Answer

Model-driven app

Question 14

Your company is migrating a legacy paper-based expense report process to Power Apps. Employees will submit expenses via a Canvas app. The app must integrate with the corporate travel system to fetch trip details (e.g., dates, destination). The travel system exposes a REST API with OAuth 2.0 authentication. Finance requires that all expense reports over $1,000 receive a second-level approval from a manager. Additionally, the app must be available on mobile devices. Which combination of technologies should you use?

Accepted Answer

Canvas app with custom connector to travel API, and Power Automate for conditional approval. A Canvas app can use a custom connector to authenticate with OAuth 2.0 and fetch trip details from the travel REST API. Power Automate can handle the conditional approval workflow for expenses over $1,000. Canvas apps are suitable for mobile use. Option B is wrong: the travel API uses OAuth 2.0, which requires a custom connector; standard connectors may not support the specific authentication or endpoints. Option C is wrong: AI Builder is for AI capabilities like form processing, not for fetching data from a REST API or handling approvals. Option D is wrong: while a model-driven app can be used for mobile, it relies on Dataverse as a data source, not direct integration with an external REST API; the travel system API requires a custom connector, which is easier to implement with a Canvas app.

Answer

Canvas app with standard connector to travel API and Power Automate

Answer

Canvas app with AI Builder to extract trip details and Power Automate for approval

Answer

Model-driven app with Dataverse and Power Automate for approval

Question 15

Which THREE are capabilities of Microsoft Dataverse in Power Apps?

Accepted Answer

Role-based security to control access to data. Correct: A, B, and D. Dataverse provides role-based security (A), calculated fields and rollup fields (B), and business rules (D). C is wrong because real-time co-authoring is a Power Apps feature, not Dataverse. E is wrong because server-side pagination is not exposed directly in Dataverse.

Answer

Real-time co-authoring of canvas apps

Answer

Server-side pagination for large datasets

Question 16

Which TWO are types of apps you can create with Microsoft Power Apps?

Accepted Answer

Model-driven app. Correct: A and C. Canvas apps and model-driven apps are the two primary types of apps in Microsoft Power Apps. Option B, Copilot Studio bot, is a chatbot created with Microsoft Copilot Studio, not a Power Apps app type. Option D, Flow app, refers to Power Automate flows, which are separate from Power Apps. Option E, Power BI report, is a visualization created with Power BI, not an app type in Power Apps.

Answer

Copilot Studio bot

Answer

Flow app

Answer

Power BI report

Question 17

You are building a canvas app for a retail company to track inventory. The app needs to display a list of products from a Dataverse table and allow users to update quantities. The product table has a column 'QuantityOnHand' of type Whole Number. When a user reduces the quantity below zero, the app should show an error message and not save the data. You have added a form and a submit button. What approach should you use to enforce the business rule?
A) Add a business rule to the Dataverse table that sets a validation message when QuantityOnHand < 0.
B) Use the Patch function with an If condition to check the value before updating.
C) Add a workflow in Power Automate to validate the quantity after submission.
D) Add a validation rule in the form control to check if QuantityOnHand >= 0 before submitting.

Accepted Answer

Use the Patch function with an If condition to check the value before updating.. Using the Patch function with an If condition allows real-time client-side validation before the data is sent to Dataverse. This ensures that the quantity is not reduced below zero and an error can be displayed to the user immediately. Option A (Dataverse business rule) is not triggered by canvas app submissions; business rules apply in model-driven apps. Option C (Power Automate workflow) runs after submission and cannot prevent the invalid data entry. Option D (form validation rule) is client-side but less direct for this scenario and may still allow submission if the rule is bypassed.

Answer

Add a business rule to the Dataverse table that sets a validation message when QuantityOnHand < 0.

Answer

Add a workflow in Power Automate to validate the quantity after submission.

Answer

Add a validation rule in the form control to check if QuantityOnHand >= 0 before submitting.

Question 18

A company uses Power Apps to manage expense reports. Employees submit expense reports via a canvas app that writes to a Dataverse table. Managers need to approve or reject expenses. Which Power Platform component should you use to implement the approval workflow? A) Add an approval step in the canvas app using the 'Approval' connector. B) Use Power Automate with the 'Start and wait for an approval' action. C) Create a business rule in Dataverse to send email. D) Use Power BI to notify managers.

Accepted Answer

Use Power Automate with the 'Start and wait for an approval' action.. Power Automate provides built-in approval actions. Option A is incorrect because Power BI is for analytics, not workflow. Option C is incorrect because adding an approval step directly in a canvas app using the 'Approval' connector is not standard; that connector is typically used in Power Automate. Option D is incorrect because business rules in Dataverse cannot initiate approval workflows.

Answer

Use Power BI to notify managers.

Answer

Add an approval step in the canvas app using the 'Approval' connector.

Answer

Create a business rule in Dataverse to send email.

Question 19

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 20

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