Courseiva

PL-900 · topic practice

Demonstrate the capabilities of Power Apps practice questions

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.

Courseiva uses original exam-style practice questions designed for learning and revision. The goal is to understand the concepts, recognise exam patterns, and improve through explanations — not memorise copied exam dumps.

Editorial oversight:Johnson Ajibi· MSc IT Security, IEEE Senior Member
20 questionsDomain: Demonstrate the capabilities of Power Apps
Practice 10 questionsBrowse domain →

What the exam tests

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.

Practice set

Demonstrate the capabilities of Power Apps questions

20 questions · select your answer, then reveal the explanation

Question 1easymultiple choice
Read the full Demonstrate the capabilities of Power Apps explanation →

A company wants to build a Power Apps app that uses a SQL Server database as its data source and requires complex business logic validation before saving data. Which type of app should they use?

Question 2mediummultiple choice
Read the full Demonstrate the capabilities of Power Apps explanation →

A company has a model-driven app with a custom table 'Issue' that has a choice column 'Status' with values: New, In Progress, Resolved, Closed. The app uses a business rule to set 'Resolved By' (lookup to User) when status changes to Resolved. Users report that the 'Resolved By' field is not being populated. What is the most likely cause?

Question 3mediummulti select
Read the full Demonstrate the capabilities of Power Apps explanation →

A company is planning to build a Power Apps app for field service technicians to view and update work orders. The app must work offline and sync data when connected. Which TWO components are required to achieve offline capability?

Question 4hardmulti select
Read the full Demonstrate the capabilities of Power Apps explanation →

A company deploys a model-driven app that uses a custom table 'Project' with a status choice column. The app includes a business rule that shows a warning message when the status is set to 'Completed' but the 'End Date' is blank. The business rule works on the main form but not when records are updated via a Power Automate flow. Which THREE actions should the administrator take to enforce the rule regardless of update method?

Question 5hardmultiple choice
Read the full Demonstrate the capabilities of Power Apps explanation →

A developer is trying to create a business process flow (BPF) for the 'Opportunity' table in a model-driven app. When activating the BPF, the developer receives the error shown in the exhibit. What is the most likely cause?

Exhibit

Refer to the exhibit.

Error log:
{
  "error": {
    "code": "0x80040220",
    "message": "Business Process Flow instance creation failed. The selected entity is not valid for the selected process.",
    "details": {
      "ActivityId": "a1b2c3d4-e5f6-7890-abcd-ef1234567890"
    }
  }
}
Question 6mediummultiple choice
Read the full Demonstrate the capabilities of Power Apps explanation →

A canvas app uses the formula shown in the exhibit to display the name of the most recently created account named 'Contoso'. The formula always shows 'No records found' even though there are accounts named 'Contoso'. What is the likely issue?

Exhibit

Refer to the exhibit.

Power Fx formula:
If(
    IsEmpty(SortByColumns(Filter(Accounts, 'Account Name' = "Contoso"), "Created On", Descending)),
    "No records found",
    First(SortByColumns(Filter(Accounts, 'Account Name' = "Contoso"), "Created On", Descending)).'Account Name'
)
Question 7hardmultiple choice
Read the full Demonstrate the capabilities of Power Apps explanation →

A manufacturing company uses Power Apps to manage inventory. The app includes a main screen that displays a gallery of inventory items, a detail screen for editing item properties, and a form screen for adding new items. The app uses a SharePoint list as the data source. Recently, users reported that when they edit an item on the detail screen and save, the changes do not appear in the gallery until they manually refresh the app. Additionally, some users occasionally encounter a 'Delegation warning' when filtering the gallery by item name. The app is shared with 200 users, and performance is becoming an issue. You need to resolve these issues. Which action should you take?

Question 8easymultiple choice
Read the full Demonstrate the capabilities of Power Apps explanation →

A company needs to create a mobile app for field service technicians to view and update work orders. The app should work offline and sync when connected. Which type of Power App should they build?

Question 9hardmultiple choice
Read the full Demonstrate the capabilities of Power Apps explanation →

A developer creates a canvas app to display orders from Microsoft Dataverse. The app uses the gallery and data configuration shown in the exhibit. When the app runs, the gallery shows orders but the 'View Details' button does nothing when tapped. What is the most likely cause?

Exhibit

Refer to the exhibit.

```
{
  "name": "Order Approval",
  "type": "canvas",
  "dataSources": [
    {
      "type": "Microsoft Dataverse",
      "entities": ["Orders", "OrderDetails"],
      "relationships": [
        {
          "fromEntity": "Orders",
          "toEntity": "OrderDetails",
          "relationshipType": "OneToMany",
          "fromKey": "OrderID",
          "toKey": "OrderID"
        }
      ]
    }
  ],
  "controls": [
    {
      "type": "Gallery",
      "name": "OrderGallery",
      "items": "Orders",
      "template": {
        "fields": ["OrderID", "OrderDate", "Total"],
        "controls": [
          {
            "type": "Button",
            "name": "DetailButton",
            "text": "View Details",
            "action": "Navigate(OrderDetailScreen)"
          }
        ]
      }
    }
  ]
}
```
Question 10mediummatching
Read the full Demonstrate the capabilities of Power Apps explanation →

Match each Power Virtual Agents feature to its purpose.

Drag a concept onto its matching description — or click a concept then click the description.

Concepts
Matches

Conversation path for a specific user goal

Extracts specific information from user input

Default response when bot doesn't understand

Transfers conversation to a human agent

Phrases that initiate a topic

Question 11mediummultiple choice
Read the full Demonstrate the capabilities of Power Apps explanation →

A company wants to build a Power Apps canvas app for field technicians to report equipment issues. The app must allow offline data entry and sync when connectivity is restored. Which feature should the developer enable?

Question 12hardmultiple choice
Read the full Demonstrate the capabilities of Power Apps explanation →

An organization uses Power Apps to submit expense reports. The app connects to Dataverse. Users report that some submissions fail with a 'table not found' error. The developer verified the table exists. What is the most likely cause?

Question 13hardmultiple choice
Read the full Demonstrate the capabilities of Power Apps explanation →

A Power Apps canvas app that uses Dataverse is being migrated from a development environment to a production environment. After migration, the app fails to load data. The developer checks the connection and finds that the Dataverse connector is pointing to the development environment. What should the developer do?

Question 14easymultiple choice
Read the full Demonstrate the capabilities of Power Apps explanation →

A user wants to create a Power Apps canvas app that displays data from an Excel spreadsheet stored in Microsoft OneDrive for Business. Which connector should be used?

Question 15hardmultiple choice
Read the full Demonstrate the capabilities of Power Apps explanation →

A Power Apps developer needs to create an app that uses AI Builder to extract information from invoices. The app should allow users to upload an image and then display extracted fields. Which control should be used to capture the image?

Question 16mediummultiple choice
Read the full Demonstrate the capabilities of Power Apps explanation →

Refer to the exhibit. The Azure RBAC custom role definition shown is assigned to a user. What can this user do?

Exhibit

Refer to the exhibit.

{
    "name": "PowerAppPermissions",
    "type": "Microsoft.Authorization/roleDefinitions",
    "apiVersion": "2022-04-01",
    "properties": {
        "roleName": "Custom Power Apps User",
        "description": "Can use Power Apps",
        "type": "customRole",
        "permissions": [
            {
                "actions": [
                    "Microsoft.PowerApps/apps/read",
                    "Microsoft.PowerApps/apps/install"
                ],
                "notActions": [],
                "dataActions": [],
                "notDataActions": []
            }
        ],
        "assignableScopes": [
            "/subscriptions/12345/resourceGroups/RG1"
        ]
    }
}
Question 17hardmultiple choice
Read the full Demonstrate the capabilities of Power Apps explanation →

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?

Question 18hardmultiple choice
Read the full Demonstrate the capabilities of Power Apps explanation →

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?

Question 19hardmultiple choice
Read the full Demonstrate the capabilities of Power Apps explanation →

A canvas app includes a gallery that shows a list of customers. The app loads slowly when the gallery displays more than 500 records. What is the best way to improve performance?

Question 20mediummulti select
Read the full Demonstrate the capabilities of Power Apps explanation →

Which TWO components are required to create a model-driven app in Power Apps? (Choose two.)

Continue with 20-question session →

Free account

Track your progress over time

Create a free account to save your results and see which topics improve across sessions.

Sign up freeLog in

Focused Demonstrate the capabilities of Power Apps sessions

Start a Demonstrate the capabilities of Power Apps only practice session

Every question in these sessions is drawn from the Demonstrate the capabilities of Power Apps domain — nothing else.

10 questions20 questions30 questions50 questions
Browse all Demonstrate the capabilities of Power Apps questions →Mixed PL-900 session

Related practice questions

Related PL-900 topic practice pages

Move into related areas when this topic feels solid.

Demonstrate the capabilities of Power Apps practice questions

Sharpen your PL-900 knowledge of Demonstrate the capabilities of Power Apps.

Demonstrate the capabilities of Power Automate practice questions

Practise PL-900 questions linked to Demonstrate the capabilities of Power Automate.

Describe the business value of Microsoft Power Platform practice questions

Describe the business value of Microsoft Power Platform practice questions for PL-900.

Manage the Microsoft Power Platform environment practice questions

Manage the Microsoft Power Platform environment practice questions for PL-900.

Demonstrate the capabilities of Microsoft Copilot Studio practice questions

Targeted PL-900 practice covering Demonstrate the capabilities of Microsoft Copilot Studio.

PL-900 fundamentals practice questions

Work through PL-900 questions on PL-900 fundamentals.

PL-900 scenario practice questions

Work through PL-900 questions on PL-900 scenario.

PL-900 troubleshooting practice questions

Targeted PL-900 practice covering PL-900 troubleshooting.

Frequently asked questions

What does the PL-900 exam test 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.
How should I use these practice questions?
Select your answer before revealing the explanation. Then read why each option is right or wrong — this active recall approach builds retention far faster than re-reading notes.
Can I practise just Demonstrate the capabilities of Power Apps questions in a focused session?
Yes — the session launcher on this page draws every question from the Demonstrate the capabilities of Power Apps domain. Use a 10-question session first to gauge your baseline, then move to 20 or 30 once the weak spots are clear.
Where can I practise other PL-900 topics?
Use the topic links above to move to related areas, or go back to the PL-900 question bank to see all topics.
Are these real exam questions or dumps?
These are original practice questions written to test the same concepts the PL-900 exam covers. They are not copied from any real exam or dump site.