Courseiva

PL-900 · domain

Demonstrate the capabilities of Power Apps

This domain covers Power Apps building blocks: canvas versus model-driven apps, connectors to SharePoint, Excel, and Microsoft Dataverse, sharing and security roles, and Power Apps portals for external users. Questions present short business scenarios and ask you to pick the right app type, data source, or fix for a permissions or access problem.

161 questions54 easy66 medium41 hard

Focused practice

Practice Demonstrate the capabilities of Power Apps questions

Scored sessions drawing only from this domain — pick a length below.

Start 20-question practice test →

What this domain covers

What to know about Demonstrate the capabilities of Power Apps

Be able to match a business scenario to canvas or model-driven apps, pick the correct connector or data source, and explain why users see no data or 'Access denied'. The key skill is separating app sharing from data-source permissions and knowing when portals are required.

Choosing canvas apps versus model-driven apps for a given scenario and data source

Connecting apps to SharePoint lists, OneDrive Excel files, and Microsoft Dataverse tables

Sharing apps and diagnosing 'Access denied' errors caused by missing permissions

Using Power Apps portals so external vendors can submit data without a Microsoft account

Watch out for

Common Demonstrate the capabilities of Power Apps exam traps

  • ▸Assuming a canvas app grants data access by itself; users still need permission on the underlying SharePoint list, Excel file, or Dataverse table.
  • ▸Confusing model-driven apps with canvas apps, then selecting the wrong designer or expecting Dataverse-only features like security roles in a canvas app.
  • ▸Forgetting that Power Apps portals are the option for anonymous external users, and instead trying to share an internal app with vendors.

Question index

All Demonstrate the capabilities of Power Apps questions (161)

Click any question to see the full explanation, or start a practice session above.

1

A business analyst wants to quickly create a simple app to track team tasks without writing complex formulas. Which Power Apps option is most suitable?

Easy
2

A company has a canvas app that uses Microsoft Dataverse. The app is shared with many users, and some users report that they cannot see any data. What is the most likely cause?

Easy
3

A supply chain analyst uses a Power Apps canvas app to scan barcodes in a warehouse where network connectivity is intermittent. The app must store scanned records locally and upload them later when connectivity returns. Which Power Apps capability should the analyst use?

Medium
4

A user wants to edit the fields displayed in a model-driven app form. Where should they go to customize the form?

Easy
5

You are reviewing a FetchXML query used in a Power Apps component. The exhibit shows the query. What data will this query return?

Hard
6

A business analyst wants to create a Power Apps canvas app that connects to a Microsoft Excel workbook stored in OneDrive for Business. The analyst needs to display data from a table in the workbook and allow users to update records directly from the app. Which statement is true about using Excel as a data source in a canvas app?

Easy
7

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?

Easy
8

A team wants to create a mobile app for inspecting equipment. The app should allow inspectors to capture photos, record audio notes, and submit the inspection report to a SharePoint list. The team has limited coding experience and wants to build the app quickly. Which type of Power Apps should they use?

Easy
9

Which TWO of the following are capabilities of Power Apps that help organizations build custom business applications without writing traditional code?

Medium
10

Which THREE are capabilities of Microsoft Dataverse in Power Apps?

Hard
11

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?

Medium
12

You are building a canvas app in Power Apps. The app needs to display a chart that shows the monthly sales trend from a SharePoint list. The chart must update automatically when new sales records are added to the list. What should you use to display the chart?

Medium
13

A manager wants to create a Power App that shows a list of customer orders with the ability to drill into each order's details. Which approach is most efficient?

Easy
14

A team is creating a model-driven app to manage customer service cases. They want to ensure that only users with a specific security role can delete cases. What should they configure?

Easy
15

A company has a canvas app that uses a SharePoint list as its data source. The list contains 8,000 items. Users report that the app's gallery only shows the first 100 items when they scroll. The app's gallery Items property is set to Filter(Expenses, Status = "Pending"). What should the maker do to ensure all pending items are displayed?

Hard
16

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?

Medium
17

A manager wants to create an app without writing any code. Which Power Apps type should they use?

Easy
18

A company wants to create a mobile app for field technicians to log service calls. The app will connect to an existing SQL database. Which type of Power App should they build?

Easy
19

Refer to the exhibit. A Power Apps canvas app uses the Filter function as shown. What does this expression do?

Medium
20

A field technician uses a canvas app on a tablet to inspect equipment in areas with no network connectivity. The technician needs to record inspection results while offline and have them synchronized when connectivity returns. The app must continue to work without an internet connection. Which capability should the maker configure to meet this requirement?

Medium
21

A canvas app uses a SQL Server database as its data source. The database is hosted on-premises and is not exposed to the internet. Users report that the app fails to load data. What must be configured to allow the canvas app to connect to the on-premises SQL Server?

Hard
22

Drag and drop the steps to deploy a solution from a development environment to a production environment in Power Platform in the correct order.

Medium
23

A company wants to allow external partners to submit support tickets via a web interface. The data should be stored in Dataverse. Which type of app should they build?

Medium
24

A company uses Microsoft Power Apps to build a leave request application. The app uses SharePoint as the data source. Users report that when they submit a leave request, the app sometimes fails to save the data and shows a generic error. Which should you investigate first?

Medium
25

A team is designing a model-driven app for customer service. They need to ensure that only agents in the 'Premium Support' role can see a custom field named 'SLA Level'. What is the best way to implement this security requirement?

Hard
26

A company uses a model-driven app to manage customer service cases. The team wants to automatically assign cases to the appropriate queue based on the case category. What feature should they use?

Medium
27

A company uses Power Apps to manage field service inspections. Inspectors need to capture GPS coordinates, photos, and digital signatures while offline in remote areas with no internet connectivity. The app must sync data automatically when connectivity is restored. Which type of Power Apps app should the company build?

Medium
28

A Power Apps maker has built a canvas app that uses a SQL Server database as its data source. The app is used by employees in the office and remote workers. Remote workers report that the app is slow when loading data. The maker suspects that the issue is related to data retrieval. Which action should the maker take to improve performance for remote users?

Hard
29

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

Hard
30

A user wants to create a canvas app that displays a list of products from a SharePoint list and allows filtering by category. The user has no coding experience. Which approach should they use to build the app quickly?

Easy
31

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

Medium
32

An organization wants to build a Power Apps solution that uses AI to extract information from invoices automatically. Which feature should they use?

Medium
33

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?

Medium
34

A power user is designing a canvas app for inventory management. The app has a gallery that displays products. The user wants to filter the gallery to show only products with stock less than 10. Which formula should the user use in the Items property of the gallery?

Hard
35

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?

Medium
36

Refer to the exhibit. An ARM template deploys a Power App with a connection to Office 365 Outlook. What is the purpose of the 'dependsOn' element?

Hard
37

A company wants to create a Power App that uses AI to extract information from uploaded invoices. The app should allow users to upload an invoice image and then automatically populate fields like invoice number, date, and total amount. Which Power Platform feature should you use? A) AI Builder's prebuilt invoice processing model. B) Custom Vision service in Azure. C) Power Automate with OCR actions. D) Use the 'Scan' function in Power Apps.

Medium
38

You are building a canvas app for a field service team. The app must allow technicians to capture a customer signature on a touch screen and attach it to a work order record. Which Power Apps control should you add to the screen to meet this requirement?

Medium
39

A model-driven app has a subgrid showing related opportunities. Users want to be able to edit opportunity fields directly in the subgrid without opening the record. Which feature should be enabled?

Hard
40

A Power Apps app uses a Dataverse table with a choice column 'Priority' (Low, Medium, High, Critical). The app must display the priority as a color-coded badge in a gallery. Which method is most efficient?

Medium
41

You are troubleshooting a canvas app that connects to a SQL Server database through an on-premises data gateway. Users in the finance department receive an error stating the app cannot reach the data source, while users in IT can use the app normally. What is the most likely cause?

Hard
42

A maker is building a canvas app that connects to a SharePoint list containing 20,000 items. Users report that a gallery showing filtered results displays only part of the expected records, and some filters seem to be ignored. The maker wants the app to return accurate results for the filtered queries. What should the maker do?

Hard
43

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?

Medium
44

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

Hard
45

A company has a Power Apps model-driven app for sales. Sales reps need to see their assigned leads only. Which security feature should be configured?

Medium
46

A sales team uses a Power Apps canvas app to view and update customer records stored in a Microsoft Dataverse table. A new requirement states that when a user selects a customer in the app, the app must automatically retrieve the 10 most recent related orders from a different Dataverse table and display them in a gallery. Which Power Apps capability should the maker use to retrieve and display the related orders?

Medium
47

A sales team needs a mobile-friendly app to view and update customer information stored in Microsoft Dataverse. The app should be generated automatically from the data model and provide a consistent interface across devices. Which type of Power Apps app should they create?

Easy
48

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?

Hard
49

Which THREE of the following are capabilities of Power Apps?

Hard
50

An organization has a canvas app that uses a SharePoint list as its data source. Users report that the app loads slowly and sometimes times out. The developer needs to improve performance. Which approach should the developer take?

Hard
51

A maker is authoring a canvas app in Power Apps Studio and wants to reuse logic and control appearance across multiple screens. Which two capabilities support this goal? (Choose two.)

Medium
52

Which TWO are valid ways to share a canvas app with other users in your organization?

Medium
53

A company uses Power Apps to build a canvas app for field technicians to report equipment issues. The app includes a GPS location control and requires offline capability. During a pilot, technicians report that the app fails to load data when they are in remote areas with no internet. Which design change should the app maker implement to address this issue?

Medium
54

Which TWO data sources can be used with a canvas app? (Choose two.)

Easy
55

Which THREE are capabilities of model-driven apps?

Hard
56

A business analyst wants to create a simple app to track employee vacation requests without writing code. Which type of Power App should they use?

Easy
57

A Power Apps canvas app uses a SharePoint list as a data source. Users report that the app is slow when loading data. The list has 10,000 items. Which optimization should you recommend?

Hard
58

You are troubleshooting a canvas app that loads slowly. The app uses over 50 data sources and many formulas. Which action is most likely to improve performance?

Hard
59

A developer builds a canvas app that uses a custom connector to call an external API. The API requires an OAuth 2.0 client credentials flow. Which authentication type should the developer configure in the custom connector?

Hard
60

A company is planning a model-driven app for managing equipment inspections. The app must support business process flows, role-based security, and a unified interface across devices. Which two components are required to build this model-driven app? (Choose two.)

Medium
61

A small business wants to create a Power Apps app to track customer interactions. They have limited budget and no dedicated IT staff. The app must be easy to maintain and should use a data source that requires minimal setup. The app will be used by 5 sales reps. Which approach should they take?

Easy
62

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?

Easy
63

A canvas app includes a gallery that displays customer records from a SharePoint list. The app designer wants to ensure that when a user selects a record, the details are shown on a separate screen. Which Power Apps feature should be used to pass the selected record's data to the detail screen?

Medium
64

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

Easy
65

Which TWO data sources can be used directly in a canvas app without a gateway? (Choose two.)

Easy
66

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

Medium
67

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

Hard
68

A Power Apps developer needs to store an image uploaded by a user in a canvas app. The app uses Microsoft Dataverse. Which column type should be used for the image?

Medium
69

A support organization is building a model-driven app for case management and wants to standardize how agents create and update case records. The organization wants to control which fields appear on the case form, enforce required fields, and define the columns shown in the case list view. Which two components should the maker configure to meet these requirements? (Choose two.)

Medium
70

A model-driven app uses a custom table 'Service Request' with a status field. The business requires that when a status changes to 'Resolved', the app automatically sends an email to the requester. Which approach should be used?

Hard
71

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?

Hard
72

A company wants to give external partners a secure, branded website where they can view and update order information stored in Dataverse. Partners should sign in with their own credentials, and the company wants to control which records each partner can see. Which Power Platform capability should the company use?

Medium
73

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?

Easy
74

Refer to the exhibit. A developer is creating a model-driven app based on a custom Dataverse table defined by this JSON. The app needs a form that shows the Approved field only when the amount is greater than 1000. Which feature should the developer use?

Medium
75

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?

Medium
76

Which THREE of the following are true about model-driven apps? (Choose THREE.)

Hard
77

You are building a canvas app for a field service team. Technicians need to open the app on a phone, capture a photo of damaged equipment, and attach that photo to a work order record stored in Microsoft Dataverse. You add a Camera control and a Form control bound to the Work Order table. What should you configure to store the captured image with the work order record?

Medium
78

A user wants to create a simple app to track personal expenses using an Excel file stored in OneDrive. Which Power Apps approach should they use?

Easy
79

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?

Medium
80

You are designing a model-driven app for a claims department. The team needs a consistent, form-based experience driven by Microsoft Dataverse tables. Which two capabilities should you expect from a model-driven app? (Choose two.)

Medium
81

A company uses a canvas app to collect customer feedback. The app stores data in Microsoft Dataverse. Users report that some submissions are not saved when the app loses internet connection. How should the app be modified to prevent data loss?

Medium
82

An organization needs to create a custom app that displays data from Dynamics 365 Sales and allows users to update records. The app should automatically generate a responsive UI based on the data model. Which type of app should they build?

Easy
83

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?

Medium
84

A Power App uses a Patch function to update a Dataverse table. The app runs into delegation warnings for large datasets. Which approach best resolves delegation warnings while maintaining functionality?

Hard
85

A model-driven app uses a custom business process flow. Users report that they cannot progress beyond a stage even after completing all required fields. What should you check?

Hard
86

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?

Easy
87

A company wants to build a Power App that uses AI to extract information from uploaded invoices. Which capability should they use?

Easy
88

A sales team uses a canvas app to manage customer leads. The app currently connects to a SharePoint list as its data source. The team wants to move to a more robust data platform that supports complex relationships between leads, accounts, and contacts. They also need to enforce business rules and security at the data level. Which data source should they use?

Medium
89

A company uses Power Apps to create a canvas app for employee expense reporting. The app needs to integrate with the corporate HR system to fetch employee details such as manager email and cost center. The HR system exposes a REST API that requires an API key in the header. Which approach should the app maker use to securely connect to the HR system?

Medium
90

A company is building a Power Apps canvas app that will be used by field technicians on mobile devices. The app must allow technicians to capture photos and store them with related work order records in Microsoft Dataverse. The maker needs to add a control that lets users take a photo using the device camera. Which control should the maker add to the app?

Medium
91

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?

Medium
92

Fabrikam, Inc. uses Power Apps to create a canvas app for expense reporting. The app is connected to a SharePoint list named Expenses. The app allows users to submit expenses, attach receipts, and view their history. The manager wants to add a feature where users can scan a receipt using the mobile app camera and automatically extract the amount and date using AI Builder. The extracted data should be populated into the form fields. The development team needs to implement this feature. Which steps should they take?

Medium
93

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?

Medium
94

A team lead wants to give a colleague permission to edit the structure of a canvas app, including adding screens and modifying formulas, but not to publish it to end users. Which sharing role should be assigned in Power Apps?

Easy
95

A company wants to use Power Apps to create a mobile app for field technicians. The app must work offline and sync data when connectivity is restored. Which feature should they use?

Hard
96

A company uses Power Apps to manage customer service cases. They want to implement a business rule that automatically sets the priority to 'High' when the customer is a VIP. Where should the business rule be defined?

Medium
97

You are reviewing a Power Automate flow that uses an Office 365 Users connector. The exhibit shows a JSON definition of an action. What does this action do?

Easy
98

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

Easy
99

A Power Apps canvas app uses a SharePoint list as its data source. Users report that the app is slow to load when the list contains over 10,000 items. What is the best approach to improve performance?

Medium
100

A company wants to build an app that allows employees to submit expense reports. The app must include approval workflow. Which Power Platform component should be used to define the approval process?

Easy
101

A business analyst wants to build an app quickly using a pre-built template. Which Power Apps capability should they use?

Easy
102

Refer to the exhibit. The JSON describes a Power Apps function. What is the correct usage of this function to return a date 7 days from today?

Hard
103

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?

Easy
104

A company has a canvas app that connects to a Microsoft Dataverse table containing sensitive customer information. The app is shared with a group of users, but the security team wants to ensure that users can only see records that they own and cannot modify records owned by others. The maker needs to implement record-level security. What should the maker do?

Medium
105

A model-driven app includes a custom entity 'Project' with a lookup to 'Account'. Users need to see the account name and phone number on the Project form. What is the best way to display these fields?

Medium
106

An organization uses a Canvas app to capture customer feedback. The app writes data to a Dataverse table. Recently, users have been submitting duplicate records due to double-clicking the submit button. What is the best way to prevent duplicates?

Medium
107

Which TWO data sources can be used directly in a canvas app without a premium connector? (Choose two.)

Easy
108

A company wants to build a custom app that allows employees to submit expense reports from their mobile devices. The app must be easy to customize and deploy without writing code. Which type of Power App should they use?

Easy
109

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

Easy
110

Your organisation has a Power Apps canvas app that uses a custom connector to call an external API. The API key is stored in a global variable. What is the security concern with this approach?

Hard
111

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?

Hard
112

In a model-driven app, a user wants to see a map of all customer addresses on a form. Which feature should be enabled?

Hard
113

A company wants to build a Power App that uses AI to analyze survey responses and extract sentiment. Which Power Platform capability should they use?

Easy
114

You have a model-driven app that includes a custom table. You need to add a field that calculates a value based on other fields (e.g., total price = quantity * unit price). Which type of field should you create?

Medium
115

A business analyst wants to create a simple expense report app without writing code. The app should allow users to submit expenses and managers to approve or reject them. Which type of Power App should the analyst use?

Easy
116

Which THREE components are part of Power Apps Studio for building Canvas apps? (Choose three.)

Hard
117

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?

Medium
118

Which TWO of the following data sources can be used directly in a canvas app without using a gateway? (Choose TWO.)

Easy
119

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?

Hard
120

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?

Easy
121

You are building a canvas app for a field service team. Technicians need to capture customer signatures on a tablet and store the image with the work order record in Dataverse. Which control should you use?

Medium
122

You are designing a Power Apps model-driven app for a sales team. The app must enforce that a discount field cannot exceed 50% of the total price. Where should you implement this validation?

Hard
123

An organization needs to create a form for employees to submit vacation requests. The form should automatically calculate the number of days requested based on the start and end dates. Which type of app should they build?

Medium
124

A business analyst creates a model-driven app using Dataverse. They need to ensure that when a new lead is created, a task is automatically assigned to the sales team. Which component should be used?

Easy
125

A business analyst needs to create a simple canvas app that lets employees submit expense reports. The app must show a form with fields for amount, category, and receipt photo, and save the data to a SharePoint list. The analyst has no programming experience. Which Power Apps feature should the analyst use to build the form quickly?

Easy
126

A company wants to build a Power App that allows sales representatives to capture customer feedback offline on their mobile devices. The feedback includes text, images, and signature. Which feature should be used to handle offline image and signature capture?

Medium
127

A sales team at a manufacturing company needs a mobile app where field representatives can look up customer records, view related orders, and update account details. The company already stores all this data in Microsoft Dataverse with defined relationships and business rules. The team wants to build the app with minimal custom coding and have it automatically respect the Dataverse security roles. Which type of Power Apps app should they create?

Easy
128

A company uses a model-driven app to manage support tickets. Users want to automate the creation of a follow-up task when a ticket is resolved. Which component should be used?

Medium
129

A company is designing a Power Apps canvas app for inventory management. They want to allow managers to approve or reject requests directly from their mobile devices. Which control should be used to collect the manager's decision?

Medium
130

A company wants to create a Power Apps app that can be embedded in Microsoft Teams. Which type of Power Apps should they use?

Easy
131

A company uses a model-driven app built on Microsoft Dataverse to manage customer cases. The support team wants to ensure that when a case is escalated, the system automatically sends an email notification to the assigned manager and updates the case priority. The team does not want to write any code. What should they use to implement this automation?

Medium
132

A maker is building a canvas app that connects to a Microsoft Dataverse table named Projects. The app includes a gallery that displays project records and a form for editing them. The maker wants to ensure that when a user selects a project in the gallery, the form automatically shows the details of that selected project. Which Power Apps control property should the maker set on the form to bind it to the gallery's selected item?

Medium
133

A field technician needs a mobile app that reads the device camera to capture equipment photos and writes each photo together with a work order number to a Microsoft Dataverse table. The technician wants to build it quickly with drag-and-drop controls and no server-side code. Which Power Apps app type fits best?

Easy
134

A company wants to create a model-driven app to manage customer cases. The app must include a custom table for cases, a form to enter case details, a view to list open cases, and a dashboard to show case metrics. The company has a Microsoft Dataverse environment. What is the minimum set of components the maker needs to create in the Power Apps maker portal?

Medium
135

Which TWO data sources can be directly connected to a Power Apps canvas app without using an on-premises data gateway? (Choose two.)

Medium
136

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

Hard
137

Which TWO of the following are capabilities of Power Apps? (Choose TWO.)

Medium
138

A company wants to build a Power Apps solution that integrates with Microsoft Teams. They want to embed the app directly into a Teams channel. Which type of app should they build?

Easy
139

A business user wants to build a Power Apps app without writing any code. Which type of app should they create?

Easy
140

Which THREE of the following are capabilities of model-driven apps? (Choose THREE.)

Hard
141

A maker builds a canvas app that reads from a SharePoint list containing 50,000 rows. Users report the gallery shows only a subset of records and search results are incomplete. The maker needs the app to return complete results for filter and search operations. What should the maker do?

Hard
142

An app maker wants to add a button in a model-driven app that, when clicked, creates a new record of a custom entity called 'Inspection'. The maker should use which feature?

Easy
143

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?

Medium
144

A sales team at a manufacturing company needs a mobile-friendly app that shows a product catalog and lets reps submit orders. The team has no developers and wants to build the app quickly by dragging controls onto a blank screen and connecting to an existing SharePoint list. Which type of Power Apps app should the team create?

Easy
145

Refer to the exhibit. The following JSON shows a Power Apps component (canvas app) manifest snippet: { "properties": { "dataSources": [ { "name": "SalesData", "type": "Microsoft Dataverse", "entity": "accounts" } ], "screens": [ { "name": "MainScreen", "controls": [ { "name": "AccountGallery", "type": "Gallery", "items": "Filter(SalesData, status = 'Active')" } ] } ] } } What is the data source for the gallery named AccountGallery?

Medium
146

A model-driven app uses a custom button that runs a Power Automate flow to send an email notification. Users report that the button sometimes does not appear on the command bar. The app maker checks the form customizations and confirms the button is configured correctly. What is the most likely cause?

Hard
147

Your organization is a multi-national corporation using Microsoft Power Platform. The compliance team requires that all Power Apps apps be auditable: every data modification (create, update, delete) must be logged with the user, timestamp, and old/new values. Additionally, the app must enforce that only users from the same business unit can view each other's records. The app uses Dataverse as the data source. You need to design the solution. Which approach should you take?

Hard
148

A retail company wants to build a mobile app that allows store employees to scan product barcodes and check inventory levels in real time. The company has no professional developers and wants to minimize coding. Which Power Apps approach should they use?

Easy
149

Which TWO data sources can be directly connected to a canvas app without using an on-premises data gateway?

Easy
150

Northwind Traders uses Power Apps to build a simple help desk ticketing system. The app uses Microsoft Dataverse as the data source. The help desk team wants to ensure that only members of the 'Help Desk Agents' security role can edit tickets, while all employees can view tickets. The app is a model-driven app. The administrator needs to configure the appropriate security. Which two actions should the administrator take? (Choose two.)

Easy
151

A team is building a canvas app that must allow users to work with data from multiple sources. The app will use Microsoft Dataverse as the primary data source and also needs to display data from an on-premises SQL Server database. Which two components are required to connect the canvas app to the on-premises SQL Server data? (Choose two.)

Medium
152

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?

Medium
153

An app maker creates a canvas app that uses Microsoft Dataverse as the data source. The app includes a gallery that displays all accounts. The app maker wants to filter the gallery to show only accounts where the 'City' field equals 'Seattle'. Which formula should be used in the Items property of the gallery?

Easy
154

Refer to the exhibit. An administrator wants to enforce a mobile app management policy that prevents screen capture in Power Apps. Which Microsoft service should the administrator use to deploy this policy?

Hard
155

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?

Easy
156

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?

Easy
157

A maker is building a canvas app that will be used by employees to submit expense reports. The app must allow users to enter multiple line items for each expense report, and the maker wants to store the data in Microsoft Dataverse. The maker needs to choose appropriate controls for the app. Which two controls should the maker use to allow users to enter and manage multiple line items? (Choose two.)

Medium
158

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?

Easy
159

Refer to the exhibit. The JSON describes a Power Apps function. Which call to this function will return a table of records where the 'Status' column equals 'Active'?

Easy
160

A company has a canvas app that uses a SharePoint list as its data source. The app works fine for most users but a few users report that they cannot submit new items. They receive a generic 'Access denied' error. What is the most likely cause?

Hard
161

A business analyst wants to create a Power App without writing code. They need to build a mobile-friendly form for inventory tracking. Which approach should they use?

Easy

Frequently asked questions

What does the Demonstrate the capabilities of Power Apps domain cover on the PL-900 exam?
Be able to match a business scenario to canvas or model-driven apps, pick the correct connector or data source, and explain why users see no data or 'Access denied'. The key skill is separating app sharing from data-source permissions and knowing when portals are required.
How many questions are in this domain?
This page lists all 161 Demonstrate the capabilities of Power Apps questions in the PL-900 question bank. The actual exam draws from this domain proportionally to its weighting in the official exam blueprint.
What is the best way to practise this domain?
Start with a short focused session (10 questions) to identify gaps, then work through explanations. Repeat with a longer session once the weak areas feel solid.
Can I practise only Demonstrate the capabilities of Power Apps questions?
Yes — the session launcher on this page filters questions to this domain only. Choose any session length for inline explanations and scoring.
pl-900 PL-900 power apps capabilities Practice Questions