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

Question 1

Refer to the exhibit. A canvas app has a gallery (Gallery1) with the Items property shown. The app also has a text input (TextSearchBox1) for searching accounts. Users report that when they type a search term, the gallery does not update until they click a button. What is the most likely cause?

Choose an answer to begin — your selection is scored in the full session.

Accepted Answer

The gallery's Items property is set to a static value instead of using TextSearchBox1.Text. The gallery's Items property must reference the search input (e.g., Filter(Accounts, StartsWith(Name, TextSearchBox1.Text))) for the gallery to update dynamically as the user types. If the Items property is set to a static value, the gallery will never reflect the search term, which explains why it only updates after a button click (likely a manual refresh).

Answer

The data source is not delegable, causing the filter to fail

Answer

The text input's OnChange event is not set to refresh the gallery

Answer

The gallery's DelayOutput property on the text input is set to true

Question 2

Refer to the exhibit. A Power App uses the Patch function to create a new record in the Orders table. The code runs without error, but no record appears in the Orders table. What is the most likely issue?

Accepted Answer

The user does not have write permissions to the Orders table. If the user does not have write permissions to the Orders table, the Patch function may execute without throwing an error but the record will not be created. Options A and B would typically cause an error, not silent failure. Option D (non-delegable data source) does not prevent record creation. Therefore, the most likely cause is insufficient permissions.

Answer

The Patch function is missing the 'As' parameter

Answer

The table name 'Orders' is misspelled

Answer

The Patch function is being called from a non-delegable data source

Question 3

A company wants to create a mobile app for field service technicians to log work orders. The app must use a SharePoint list as the data source and include offline capability. Which type of Power App should they build?

Accepted Answer

Canvas app. A canvas app is the correct choice because it allows full control over the user interface and can connect directly to a SharePoint list as a data source. Canvas apps also support offline capability through the 'Save data locally' and 'Load data locally' functions, enabling field technicians to work without connectivity. Model-driven apps, by contrast, are built on Dataverse and do not natively support SharePoint lists as a primary data source. Power Pages and Power Automate are not app types for building mobile apps with offline data access.

Answer

Power Pages site

Answer

Power Automate flow

Answer

Model-driven app

Question 4

A Power Apps developer created a canvas app that uses a SQL Server data source. Users report that the app is slow when navigating between screens. Which design change should the developer make to improve performance?

Accepted Answer

Apply delegation-compatible filters on galleries to reduce data loaded from the server.. Canvas apps query data sources lazily, so galleries and forms pull records from SQL Server each time a screen becomes visible. Applying delegation-compatible filters (e.g., Filter with supported operators on indexed columns, or using the '=' operator on primary keys) pushes the filtering to SQL Server, drastically reducing the rows transferred and improving screen navigation performance.

Answer

Replace the SQL data source with a SharePoint list to increase delegation limits.

Answer

Move all data loading logic from OnVisible to the App.OnStart property.

Answer

Add a Timer control to preload data for the next screen.

Question 5

A model-driven app has a business rule that sets the 'Priority' field to 'High' when the 'Request Type' is 'Urgent'. However, the rule does not fire when the request type is changed from the form. What is the most likely cause?

Accepted Answer

The business rule only triggers when the form loads, not on field changes.. The most likely cause is that the business rule is scoped to run only on form load (or on save) rather than on field change. Business rules in Power Platform have a 'Scope' setting that determines when they execute: 'All Forms' or specific forms, and they can be triggered on entity events like create, update, or field change. If the rule is set to run only on form load, it will not fire when a field is changed.

Answer

The business rule is set to scope 'All Forms' but the form is custom.

Answer

The condition uses 'contains' instead of 'equals'.

Answer

The business rule is deactivated in the solution.

Question 6

Which TWO actions can be performed using Power Apps? (Choose two.)

Accepted Answer

Create a mobile app to capture customer feedback.. Option D is correct because Power Apps is a low-code application development platform specifically designed to build custom apps, including canvas and model-driven mobile apps, so creating a mobile app to capture customer feedback is a core Power Apps capability. Option E is correct because Power Apps Portals (now Power Pages) allow makers to build external-facing, custom websites/portals where external users can authenticate and submit support tickets. Option A is not correct because interactive dashboards with visualizations are primarily built with Power BI, not Power Apps. Option B is not correct because chatbots are created with Microsoft Copilot Studio (formerly Power Virtual Agents), not Power Apps. Option C is not correct because automating business processes such as sending email notifications is handled by Power Automate, not Power Apps.

Answer

Build interactive dashboards with visualizations.

Answer

Create a chatbot to answer common questions.

Answer

Automate a business process to send email notifications.

Question 7

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 8

A user wants to add a chart to a model-driven app to visualize sales data. Which component should they use?

Accepted Answer

Chart component from the Dataverse table. In model-driven apps, charts are created as part of the Dataverse table (entity) and then added to views or dashboards. The Chart component from the Dataverse table is the native way to visualize data within a model-driven app. It allows users to see aggregated data without leaving the app.

Answer

Chart control from the Power Apps canvas

Answer

Excel chart imported into the app

Answer

Power BI tile embedded in the app

Question 9

An administrator needs to ensure that a Canvas app can only be used by licensed users within the organization. What should they configure?

Accepted Answer

Share the app with specific security groups that contain licensed users. To restrict a Canvas app to licensed users only, the administrator should share the app with specific security groups that contain licensed users. Power Apps licensing is per user; sharing the app with a security group ensures that only members of that group (who must have appropriate licenses) can access it. Option A is incorrect because removing the app from the Teams catalog does not enforce licensing. Option B is incorrect because publishing the app to everyone in the tenant would allow all users to access it regardless of license status. Option C is incorrect because there is no 'Require user license' setting in Power Apps; licensing is enforced at the user level when sharing.

Answer

Remove the app from the Microsoft Teams app catalog

Answer

Publish the app to everyone in the tenant

Answer

Set the app to 'Require user license' in the app settings

Question 10

A developer is building a Canvas app that uses a custom connector to an external API. The API requires OAuth 2.0 authentication. What must the developer do to set up the connector?

Accepted Answer

Register an application in Microsoft Entra ID and configure the custom connector with the client ID and secret. Custom connectors with OAuth 2.0 require registering the app in Microsoft Entra ID. Option A is not possible. Option B is for custom API, not authentication. Option C is for API key authentication, not OAuth.

Answer

Select 'OAuth 2.0' as the authentication type and enter the API key

Answer

Create the connector with a Swagger file and set authentication to 'Anonymous'

Answer

Use the built-in HTTP connector with Basic authentication

Question 11

Which TWO of the following are valid data sources for a Canvas app? (Choose TWO.)

Accepted Answer

SharePoint Online list. SharePoint Online lists (A) are a first-class, built-in connector in Power Apps, so a Canvas app can bind galleries, forms, and controls directly to list items via the SharePoint connector. Microsoft Dataverse (E) is the native data platform for Power Platform, and Canvas apps can connect to its tables with the Dataverse connector, including full CRUD and relationship support. Power Automate flows (B) are invoked from a Canvas app as actions or triggered by it, but they are not a data source you can bind to. Microsoft Intune (C) is a device/app management service and Microsoft Entra ID (D) is an identity directory; neither exposes a Canvas-app data source connector for reading and writing app data.

Answer

Power Automate flow

Answer

Microsoft Intune

Answer

Microsoft Entra ID

Question 12

A company wants to create a canvas app for field technicians to report equipment issues. The app must work offline and sync data when connectivity is restored. Which Power Apps feature should you enable?

Accepted Answer

Enable the 'Enable offline' feature in the Power Apps mobile app settings. The 'Enable offline' feature in the Power Apps mobile app settings allows canvas apps to cache data locally and sync with the server when connectivity is restored, enabling offline operation. Option A is incorrect because Power Automate flows can queue operations but do not provide native offline data caching for canvas apps. Option B is incorrect because Dataverse offline profiles are used for model-driven apps, not canvas apps. Option C is incorrect because the on-premises data gateway is for accessing on-premises data sources, not for enabling offline capabilities.

Answer

Create a Power Automate flow to queue operations

Answer

Use a Dataverse offline profile

Answer

Configure an on-premises data gateway

Question 13

Your model-driven app uses a custom entity 'Project' with a 1:N relationship to 'Task'. You need to add a subgrid on the Project form that shows related tasks, but only tasks assigned to the current user. How should you achieve this?

Accepted Answer

Create a system view on the Task entity that filters by 'Owner equals Current User' and select it in the subgrid properties. You can create a system view on the Task entity that filters by 'Owner equals Current User' and then select that view in the subgrid properties. Option A is wrong because workflows cannot filter subgrids; they can only automate processes. Option B is wrong because business rules control form behavior (like visibility or field values) but cannot filter subgrid data. Option D is wrong because using the default view would show all tasks (or those allowed by security roles), not filtered by current user; security roles control access rights, not subgrid filtering criteria.

Answer

Create a workflow that updates a field on the Project form to filter the subgrid

Answer

Add a business rule on the Project form to filter the subgrid

Answer

Configure the subgrid to use the default view and assign security roles to filter tasks

Question 14

You are building a canvas app that collects customer feedback. The app must send an email notification to the manager whenever a new feedback entry is submitted. What is the recommended approach?

Accepted Answer

Create a Power Automate flow that triggers when a new row is added to the data source and sends an email. The recommended approach is to create a Power Automate flow that triggers when a new row is added to the data source and sends an email. This decouples the email notification from the app itself, so it works reliably even if the app is closed, and it follows the Power Platform best practice of separating concerns. Power Automate provides built-in connectors and error handling, making it more maintainable and scalable than embedding email logic directly in the app.

Answer

Use the Office365 Outlook connector within Power Apps to send an email directly

Answer

Configure the app to call a custom API that sends an email

Answer

Store feedback in a SharePoint list and use 'Send email' action in SharePoint

Question 15

You need to design a Power App that allows users to view and update customer records from a SQL Server database. The app must enforce row-level security based on the user's region. What should you use?

Accepted Answer

SQL Server row-level security with the USER_NAME() function. SQL Server row-level security (RLS) with the USER_NAME() function enforces row-level access based on the user's identity, which can be mapped to their region. This is the correct approach because the data resides in SQL Server, and RLS is a native SQL Server feature that filters rows based on the executing user. Power Apps security groups, Dataverse security roles, and environment security do not apply to SQL Server data.

Answer

Power Apps security groups

Answer

Dataverse security roles

Answer

Environment security