PL-900 Practice Test 28 — 15 Questions

Question 1

A company wants to build an app that allows external vendors to submit invoices through a web portal. The app must be accessible without signing in with a Microsoft account. Which Power Platform solution should they use?

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

Accepted Answer

Power Pages site with anonymous access enabled. Power Pages (option A) is the correct solution because it enables external-facing websites that can be accessed by anonymous users without requiring a Microsoft account or license. Canvas apps and model-driven apps require authenticated users with appropriate licenses, and Power Automate is an automation service, not a portal for external submissions.

Answer

Canvas app shared with everyone

Answer

Model-driven app with anonymous access

Answer

Power Automate portal

Question 2

A company is building a canvas app to track sales leads. The app must display a count of leads grouped by status (New, Contacted, Qualified, Closed). Which data source and visualization control should the app maker use to meet this requirement?

Accepted Answer

Add a Gallery control with Items = GroupBy(Leads, Status), then add a Label showing CountRows(ThisItem.AllItems).. Using a Gallery control with GroupBy(Leads, Status) groups the leads by status, and adding a Label with CountRows(ThisItem.AllItems) displays the count for each group, meeting the requirement to display counts per status. Option A is incorrect because a Data table control with GroupBy and CountRows in a column does not inherently group and aggregate correctly; the CountRows function would need to be applied per group, which is more complex. Option C is incorrect because a Form control is for data entry, not aggregating and displaying grouped counts. Option D is incorrect because a Pie chart control can show proportions but requires an aggregated data source; directly connecting to a SharePoint list without grouping may not display counts correctly, and the description of 'Values as Count of Status' is ambiguous and not directly supported by the chart control without pre-aggregation.

Answer

Add a Data table control and set the Items property to GroupBy(Leads, Status) and use CountRows in a column.

Answer

Add a Form control bound to the Leads list and use the Status field to filter records.

Answer

Add a Pie chart control connected to the SharePoint list, configure the Legend field as Status and Values as Count of Status.

Question 3

You are building a canvas app to track support tickets. The app will be used by team members who often work offline in remote locations. Which data source should you use to ensure offline data access without requiring custom development?

Accepted Answer

Microsoft Dataverse. Microsoft Dataverse provides built-in offline sync capability for canvas apps without requiring custom development. Option A (Excel Online via OneDrive) does not support offline access. Option B (SharePoint list) requires custom logic for offline synchronization. Option D (Azure SQL Database) requires a VPN or gateway for offline access and does not offer automatic sync.

Answer

Excel Online (via OneDrive)

Answer

SharePoint list

Answer

Azure SQL Database

Question 4

A company wants to create a Power App that allows employees to submit expense reports with receipts. The app must be accessible from both mobile devices and desktop browsers, and must include a workflow for approval. Which combination of Power Platform components should be used?

Accepted Answer

Canvas app with Power Automate flow triggered by form submission.. A canvas app is designed for responsive UI across mobile and desktop, making it suitable for both devices. Power Automate can be triggered from the canvas app (e.g., on form submission) to handle the approval workflow. Option B is incorrect because model-driven apps are not as flexible for custom mobile layouts. Option C is incorrect because AI Builder is not required for receipt processing in this scenario; while it could be used, it is not necessary. Option D is incorrect because Power Pages is for external-facing websites, not internal apps with approval workflows.

Answer

Model-driven app with embedded Power Automate flow for approval.

Answer

Canvas app with AI Builder to process receipts and Power Automate for approval.

Answer

Power Pages site with a custom workflow.

Question 5

A company wants to create a custom app to track inventory in their warehouse. The app needs to integrate with their existing SQL Server database and allow users to scan barcodes to update stock levels. Which type of Power Apps should they use?

Accepted Answer

Canvas app. (Canvas app) is correct because Canvas apps allow custom integration with SQL Server and barcode scanning via device capabilities. Model-driven apps are more for data management but not as flexible for custom scanning. Power Pages is for external websites, not scanning. Power Automate is for workflows, not app building.

Answer

Power Pages

Answer

Power Automate

Answer

Model-driven app

Question 6

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 7

A Power App is used by a global team. The app displays dates in US format (MM/DD/YYYY), but users in Europe expect DD/MM/YYYY. What is the best way to handle this?

Accepted Answer

Do nothing; Power Apps automatically formats dates based on the user's browser locale. Power Apps automatically formats dates based on the user's browser locale, respecting regional preferences without custom code. Option A is wrong because hardcoding a format ignores the user's locale and requires manual detection. Option C is wrong because the Language function returns locale information, but Power Apps already handles locale automatically; manually setting the format is unnecessary and can override the automatic behavior. Option D is wrong because using a text input for dates loses the validation and user experience benefits of a date picker and still requires locale-specific formatting.

Answer

Hardcode the date format based on the user's region in the app

Answer

Use the Language function to set the date format manually

Answer

Use a text input for dates instead of a date picker

Question 8

A company wants to build a canvas app to allow field technicians to report equipment issues from their mobile devices. The app must work offline and sync data when connectivity is restored. Which feature should the developer use?

Accepted Answer

Offline. Power Apps canvas apps support offline capability using the Offline feature, which caches data on the device and syncs when connectivity is restored. Option A (Power Automate) is a workflow automation tool, not an offline data sync feature. Option B (Power Platform admin center) is used for administration and governance, not for app-level offline capabilities. Option C (Common Data Service, now Microsoft Dataverse) is a data platform that can enable offline sync when used with the Offline feature, but the question specifically asks for the feature the developer should use, which is the Offline feature itself. Therefore, D is the correct answer.

Answer

Power Automate

Answer

Power Platform admin center

Answer

Common Data Service

Question 9

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 10

Which TWO capabilities does Power Apps provide? (Choose two.)

Accepted Answer

Implementing business process flows. Power Apps provides capabilities for building custom user interfaces with canvas apps and implementing business process flows through model-driven apps. Option C is correct because model-driven apps include business process flows to guide users through processes. Option D is correct because canvas apps allow custom UI layouts. Option A is incorrect because creating Power BI dashboards is a Power BI capability, not Power Apps. Option B is incorrect because scheduling automated workflows is handled by Power Automate. Option E is incorrect because training custom AI models is done with AI Builder, which is an add-on, not a core Power Apps capability.

Answer

Creating Power BI dashboards

Answer

Scheduling automated workflows

Answer

Training custom AI models

Question 11

A company uses a Power App to track inventory. The app displays a gallery of items filtered by a dropdown. When the user selects 'Electronics', the gallery shows all electronics items. However, after the user clears the dropdown, the gallery remains empty. What is the most likely reason?

Accepted Answer

The gallery's Items property uses a filter that references Dropdown.Selected.Value, and when the dropdown is cleared, the filter returns blank. When the dropdown is cleared, Dropdown.Selected.Value becomes blank. The gallery's Items property uses a filter that references this value, so the filter returns blank (no items), causing the gallery to be empty. Option A is incorrect because AllowEmptySelection set to false would prevent clearing, not cause emptiness after clearing. Option B is incorrect because the data source does not require a refresh; the issue is the filter logic. Option D is incorrect because OnStart is not involved in the clearing behavior.

Answer

The dropdown's AllowEmptySelection property is set to false

Answer

The data source requires a refresh after clearing selection

Answer

The app's OnStart property is clearing the data source

Question 12

A canvas app uses a SharePoint list with a choice column 'Status' (Pending, Approved, Rejected). The app needs to filter the gallery to show only 'Pending' items. The list has 50,000 items. Why does the filter not work as expected?

Accepted Answer

The choice column is non-delegable in Power Apps. SharePoint choice columns are non-delegable in Power Apps. When filtering a gallery with a choice column, the filter is applied locally, which fails to return all items when the list exceeds the delegation limit (default 500 items). This explains why filtering for 'Pending' does not work as expected with 50,000 items. Option A is incorrect because the issue is delegation, not the column type itself (choice columns are delegable for some operations but not for filters with '='). Option B is incorrect because the gallery's Items property is set using the Filter function; the problem is that Filter is non-delegable for choice columns. Option D is incorrect because the syntax is not the issue; the formula may be syntactically correct but still fails due to non-delegable filter.

Answer

The column is not a single line of text

Answer

The gallery's Items property is set to 'Filter' incorrectly

Answer

The filter formula uses the wrong syntax

Question 13

Refer to the exhibit. You are configuring a conditional access policy in Microsoft Entra ID to restrict access to Microsoft 365 services. The policy uses the 'approved client app' condition with the above JSON. What will this policy enforce?

Accepted Answer

Only allow access from Power Apps and Power Automate apps.. The JSON lists the approved client apps as Power Apps and Power Automate. The 'approved client app' condition in a conditional access policy requires that the client app used is one of the listed apps. Therefore, this policy allows access only from Power Apps and Power Automate, blocking all other apps. Option C is correct. Option A is incorrect because the policy does not block Power Apps and Power Automate; it allows them. Option B is incorrect because the policy does not require compliance; it only checks the app identity. Option D is incorrect because the policy does not require multi-factor authentication; it only checks the app.

Answer

Block access from Power Apps and Power Automate.

Answer

Allow access from any app but require compliance.

Answer

Require multi-factor authentication for Power Apps and Power Automate.

Question 14

A user reports that a Power App button does nothing when clicked. The button's OnSelect property contains: Navigate(Screen2). What is the most likely cause?

Accepted Answer

Screen2 does not exist in the app. If Screen2 does not exist, the Navigate function fails silently, causing the button to appear to do nothing. Option A is incorrect because the formula syntax is valid and parentheses are properly used. Option B is incorrect because navigation permissions are not enforced within the same app; any user can navigate between screens. Option C is incorrect because the app does not need to be published for the button to work in the editor or when running the app.

Answer

The formula is missing parentheses

Answer

The user lacks permission to navigate to Screen2

Answer

The app is not published

Question 15

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