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

Question 1

A canvas app uses a SharePoint list as its data source. The list contains over 5000 items. Users can only see the first 500 items in the app. What is the most likely solution?

Accepted Answer

Modify the query to use a delegable filter. Power Apps has a default delegation limit of 500 items for non-delegable queries. Using a delegable query (e.g., Filter with column that supports delegation) solves this. Changing to gallery doesn't help; increasing list size limit is not possible; switching to Dataverse avoids the issue but is a bigger change.

Answer

Change the gallery to display items in a data table

Answer

Migrate the data to Microsoft Dataverse

Answer

Increase the SharePoint list view threshold

Question 2

Which TWO features are available in model-driven apps but not in canvas apps?

Accepted Answer

Business process flows. Model-driven apps include business process flows and dashboards natively, while canvas apps require custom implementation. Custom connectors and offline capability are available in both.

Answer

Custom connectors

Answer

Responsive design

Answer

Offline capability

Question 3

Which THREE components are part of a canvas app's formula language?

Accepted Answer

Functions. Canvas app formulas use functions, operators, and controls. Dataverse tables are data sources, not formula components. Power Automate flows are separate.

Answer

Dataverse tables

Answer

Power Automate flows

Question 4

Which TWO data sources can be directly connected to a canvas app without using a premium connector?

Accepted Answer

Excel (OneDrive/SharePoint). SharePoint and Excel are standard connectors included with Power Apps. Dataverse and SQL Server require premium licenses, and Salesforce is premium.

Answer

Microsoft Dataverse

Answer

SQL Server

Answer

Salesforce

Question 5

A developer is creating a custom control using Power Apps Component Framework (PCF). After importing the solution, the control appears but does not show any data. What is the most likely issue based on the exhibit?

Accepted Answer

The control requires a dataset property but only a text property is defined. The 'abilities' section indicates the control expects a dataset, but the only property defined is a single line of text. The control likely needs a dataset property to receive data. The version, namespace, and display key are not causing data issues.

Answer

The display-name-key is missing a translation

Answer

The version number is incorrect

Answer

The namespace is misspelled

Question 6

A Power Apps app calls a Power Automate flow with the trigger schema shown. The app passes an email string and a score number. However, the flow fails with a validation error. What is the most likely cause?

Accepted Answer

The app is passing the parameters as individual strings instead of a JSON object. The trigger expects an object with properties 'email' and 'score'. If the app passes the parameters in a different order or as separate values instead of a JSON object, the flow fails. The schema is valid, and the types match.

Answer

The email property is misspelled

Answer

The score property should be a string

Answer

The flow trigger is set to 'When a HTTP request is received' instead of manual

Question 7

A canvas app displays a label with the formula shown. Users report that the label shows 'Welcome, !' without a name. What is the most likely cause?

Accepted Answer

The user is not authenticated with Power Apps. The User() function returns the current user's details. If the user is not signed in or the app doesn't have permission, FullName may be blank. The formula syntax is correct, and concatenation works.

Answer

The FullName property is spelled incorrectly

Answer

The ampersand (&) operator is incorrect

Answer

The User() function is not available in canvas apps

Question 8

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).. The CountRows function with a GroupBy is correct because it dynamically counts rows per group in a gallery or chart. Option A is wrong because a pie chart shows proportions, not counts directly. Option B is wrong because a data table displays raw data, not aggregated counts. Option D is wrong because a form is for data entry, not display.

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 9

A user creates a model-driven app for incident management. They want a custom button on the Incident form that, when clicked, creates a new activity record of type 'Phone Call' with the incident number in the subject. What is the recommended approach?

Accepted Answer

Add a custom ribbon button with a JavaScript command that uses Xrm.WebApi.createRecord.. Using a custom ribbon command with a JavaScript action allows creating a record with specific values. Option A is wrong because custom connectors are for external APIs, not Dataverse. Option B is wrong because Power Automate flows triggered from a button require premium license and are more complex. Option D is wrong because business rules cannot create new records.

Answer

Define a business rule on the form that creates a new activity when the button is clicked.

Answer

Create a custom connector to the Dataverse API and use it in the app.

Answer

Use a Power Automate flow triggered from the button with a Dataverse 'Create a new record' action.

Question 10

A canvas app displays incorrect data because the source SharePoint list has a lookup column to another list. The app maker used 'Choices' function to populate a dropdown, but the dropdown shows IDs instead of display names. What is the cause?

Accepted Answer

The Choices function was used on a lookup column, which returns a table of IDs; use Choices( [List].[Column].DisplayName ) instead.. The Choices function returns a table with IDs by default when used with a lookup column; to get display names, the maker should use the 'DisplayName' property. Option A is wrong because delegation is not the issue. Option B is wrong because the formula is correct for single-choice columns. Option D is wrong because the data type is not number.

Answer

The Choices function was used correctly but the dropdown's DisplayFields property is not set to the display name column.

Answer

The lookup column is a number type, not text, so it cannot show names.

Answer

The formula is not delegable, causing only partial data.

Question 11

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.. A real-time workflow (now called cloud flow) can run immediately when a record status changes and perform calculations. Option A is wrong because business rules cannot write to fields outside the form. Option C is wrong because calculated fields cannot reference other record updates. Option D is wrong because Power Automate scheduled flow is not triggered by status change.

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 12

A user wants to build an app that allows field technicians to view work orders and capture photos offline. Which type of Power App should be chosen?

Accepted Answer

Canvas app with offline capability enabled.. Canvas apps can be enabled for offline use with the mobile app. Option B is wrong because model-driven apps have limited offline capability. Option C is wrong because Power Pages are public websites. Option D is wrong because AI Builder is not an app type.

Answer

Power Pages site with offline access.

Answer

AI Builder model embedded in a canvas app.

Answer

Model-driven app because it natively supports offline.

Question 13

A model-driven app for inventory management uses a custom entity 'Warehouse'. The app maker added a subgrid showing 'Warehouse Items' related to the selected warehouse. However, the subgrid does not show any data even though there are items linked. What is the most likely cause?

Accepted Answer

The relationship between Warehouse and Warehouse Items is not configured correctly or is missing.. The subgrid must have a relationship defined between Warehouse and Warehouse Items; if the relationship is missing or incorrectly configured, the subgrid will not display related records. Option A is wrong because security roles affect visibility, not relationship. Option C is wrong because the subgrid does not require lookup field on the main form. Option D is wrong because subgrids can be added to forms.

Answer

The Warehouse form does not include the lookup field to Warehouse Items.

Answer

The user does not have read permissions on the Warehouse Items entity.

Answer

The subgrid component is not supported on the main form.

Question 14

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 provides responsive design for mobile/desktop, and Power Automate handles the approval workflow. Option A is wrong because model-driven apps are less flexible for mobile. Option C is wrong because Power Pages are external. Option D is wrong because AI Builder is not needed for approval.

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 15

A user reports that a canvas app is loading slowly. The app connects to a large SharePoint list with over 10,000 items. Which change would most improve performance?

Accepted Answer

Apply a delegable filter on the data source to limit records returned.. Using a filter on the data source reduces the number of records retrieved, improving performance. Option A is wrong because adding more screens doesn't help. Option B is wrong because disabling offline doesn't affect loading speed. Option D is wrong because increasing delegation limit doesn't improve performance when the query is not delegable.

Answer

Increase the delegation limit to 10,000.

Answer

Add more screens to distribute the data.

Answer

Disable offline mode.