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

Question 1

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?

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

Accepted Answer

Create a custom connector with API key authentication and use it in the app.. Creating a custom connector with API key authentication is the recommended approach because it securely stores the API key in the connector's authentication configuration, and the connector can be reused across apps and flows. This avoids exposing the key in the app's formulas or client-side code.

Answer

Store the HR data in a SharePoint list and connect the app to SharePoint.

Answer

Build a Power Automate flow that calls the API and returns data to the app.

Answer

Use the HTTP action in Power Apps to call the API and include the API key in the headers as a static value.

Question 2

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?

Accepted Answer

The custom button is configured with visibility rules that hide it for certain security roles.. Command bar buttons in model-driven apps support visibility rules that can be scoped by security role, so a button configured correctly on the form can still be hidden from specific users if their role is excluded. Since the maker confirmed the form customization is correct, the most likely cause is role-based visibility logic that hides the button for the affected users.

Answer

The user's browser does not support the Power Apps client.

Answer

The app is opened in the phone form factor, and the button is only shown on web.

Answer

The Power Automate flow is disabled or not shared with the user.

Question 3

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?

Accepted Answer

Filter(Accounts, City = "Seattle"). The Filter function in Power Apps returns a table of records that satisfy a Boolean condition, which is exactly what the gallery's Items property requires. Filter(Accounts, City = "Seattle") evaluates each record in the Accounts table and returns only those where the City column equals 'Seattle'. This is the canonical delegation-friendly pattern for Dataverse-backed galleries.

Answer

Accounts(City = "Seattle")

Answer

LookUp(Accounts, City = "Seattle")

Answer

Search(Accounts, "Seattle", "City")

Question 4

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?

Accepted Answer

Custom command on the command bar. A custom command can be added to the command bar in a model-driven app to create a new record for a custom entity. Option B (Power Automate flow) is wrong because while a flow can be triggered from a command, the question is about the feature used to add the button itself. Option C (Business rule) is wrong because business rules are used for validation and show/hide logic, not for adding buttons. Option D (Form editor) is wrong because the form editor is used for form layout, not for adding command bar buttons.

Answer

Power Automate flow

Answer

Business rule

Answer

Form editor

Question 5

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?

Accepted Answer

Verify the connection to the SharePoint data source.. When a Power Apps app fails to save data to SharePoint and shows a generic error, the first thing to investigate is the connection to the SharePoint data source, because a broken or expired connection is the most common cause of save failures. Verifying the connection ensures the app can authenticate and communicate with SharePoint before investigating more complex issues like delegation or formulas.

Answer

Clear the browser cache and cookies.

Answer

Check if the app uses delegation for large lists.

Answer

Review the app formulas for syntax errors.

Question 6

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?

Accepted Answer

Filter(Products, Stock < 10). The Filter function in Power Apps applies a condition to show only records where Stock < 10. Option A is wrong because LookUp returns a single record, not a filtered collection. Option C is wrong because Sort changes the order but does not filter. Option D is wrong because Search is for text search, not numeric comparison.

Answer

LookUp(Products, Stock < 10)

Answer

Sort(Products, Stock)

Answer

Search(Products, "10", "Stock")

Question 7

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?

Accepted Answer

Power Automate flow. Power Automate can trigger on record changes (e.g., status change to resolved) to automatically create a follow-up task. Option B is wrong because Microsoft Copilot Studio is for building chatbots, not for task automation. Option C is wrong because a custom Power Apps page would require manual interaction, not automation. Option D is wrong because Business Rules are limited to simple form logic and cannot create records.

Answer

Microsoft Copilot Studio

Answer

Custom Power Apps page

Answer

Business Rule

Question 8

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?

Accepted Answer

Use the app from data wizard (e.g., from SharePoint). The app from data wizard (e.g., from SharePoint) is the most suitable because it allows a business analyst to quickly generate a functional app based on an existing data source, such as a SharePoint list, without writing complex formulas. This wizard automatically creates a three-screen app (browse, detail, edit) with built-in controls and formulas, enabling rapid app development. It is ideal for simple task tracking.

Answer

Start from a blank canvas app

Answer

Create a model-driven app

Answer

Use Power Automate to create the app

Question 9

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

Accepted Answer

Map control. The Map control in Power Apps model-driven apps renders address fields on a form as an interactive map, plotting customer locations based on latitude/longitude or address data. Enabling it on the form gives users a visual geographic view of all customer addresses without custom development.

Answer

Notes section

Answer

Associated View

Answer

Timeline control

Question 10

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

Accepted Answer

Share directly from the Power Apps maker portal. Option B is correct because the Power Apps maker portal provides a built-in Share feature that lets you grant specific users or groups in your organization access to a canvas app, assigning them either User or Co-owner permissions. Option C is correct because embedding a canvas app in Microsoft Teams is a supported sharing method that distributes the app to team members through a Teams tab or as a personal app, respecting the organization's security and licensing. Option A is not valid because a SharePoint list is a data source, not a distribution channel for a canvas app. Option D is not valid because a .msapp file is a source package for editing or importing in the maker portal, not a runnable link for end users. Option E is not valid because emailing the .msapp file does not publish or share the app and recipients cannot run it directly.

Answer

Publish the app to a SharePoint list

Answer

Provide a direct link to the .msapp file

Answer

Send the app file as an email attachment

Question 11

Which THREE are capabilities of Microsoft Dataverse in Power Apps?

Accepted Answer

Role-based security to control access to data. Option A is correct because Microsoft Dataverse implements role-based security through security roles, business units, teams, and record-level sharing, allowing administrators to control which users can create, read, update, and delete specific rows and tables. Option B is correct because Dataverse supports calculated columns (computed at read time from other columns) and rollup columns (aggregating related records, e.g., summing child rows), which are native column types in the platform. Option D is correct because Dataverse includes business rules that run on the server and client to enforce validation, set field values, show/hide fields, and lock fields on model-driven app forms without writing code. Option C is not a Dataverse capability; real-time co-authoring is a feature of canvas app editing in Power Apps Studio, not of the Dataverse data platform. Option E is not a Dataverse capability; server-side pagination is a pattern implemented in connectors or APIs (such as FetchXML paging with paging cookies or OData $skiptoken), not an out-of-the-box Dataverse feature.

Answer

Real-time co-authoring of canvas apps

Answer

Server-side pagination for large datasets

Question 12

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

Accepted Answer

Model-driven app. A model-driven app (A) is correct because Power Apps supports building model-driven apps that are component-focused and data-driven, based on the Common Data Service (now Microsoft Dataverse), where the UI is largely generated from the data model, relationships, and business logic. A canvas app (C) is also correct because Power Apps lets makers design canvas apps with a drag-and-drop designer, starting from a blank canvas or template, and bind controls to data sources using Power Fx formulas. Copilot Studio bot (B) is not a Power Apps app type; it is a separate conversational AI authoring tool for building copilots/bots. Flow app (D) is not a Power Apps app type; automation flows are built in Power Automate, not Power Apps. Power BI report (E) is not a Power Apps app type; reports and dashboards are created in Power BI.

Answer

Copilot Studio bot

Answer

Flow app

Answer

Power BI report

Question 13

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?

Accepted Answer

The filtered Dataverse Accounts data source. The gallery named AccountGallery has its Items property set to 'Filter(SalesData, status = 'Active')'. SalesData is defined as a data source of type Microsoft Dataverse, entity 'accounts'. Therefore, the data source is the filtered Dataverse Accounts data source. The filter is applied to the Accounts entity, so it is not the raw entity but a filtered view.

Answer

A SQL Server table named Accounts

Answer

A SharePoint list named SalesData

Answer

The raw Dataverse Accounts entity

Question 14

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?

Accepted Answer

Use AI Builder's receipt processing model in Power Apps. AI Builder provides a prebuilt receipt processing model that can be directly integrated into a Power Apps canvas app. This model allows users to scan a receipt using the camera, automatically extract the amount and date, and populate those values into form fields. Option B is incorrect because while a Power Automate flow could also process the image, it is an unnecessary extra step when AI Builder can be used directly within Power Apps. Option C is incorrect because the Camera control alone cannot extract text from an image; it requires additional processing like AI Builder. Option D is incorrect because Microsoft Copilot Studio is designed for building chatbots, not for receipt scanning and data extraction.

Answer

Create a Power Automate flow that processes the image and returns the data

Answer

Use the Camera control to capture the image and use a custom formula to extract text

Answer

Integrate Microsoft Copilot Studio to handle the receipt scanning

Question 15

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.)

Accepted Answer

Assign the 'Help Desk Agents' security role to the help desk team. Option C is correct because in a model-driven app backed by Microsoft Dataverse, access to create, read, write, and delete records is governed by Dataverse security roles, so assigning the 'Help Desk Agents' security role to the help desk team grants those users the edit (write) privileges on the ticket table. Option E is correct because all employees must be able to view tickets, and Dataverse enforces read access through security roles; granting the 'Employees' security role read privilege on the ticket table allows them to view records without granting edit rights. Option A is incorrect because creating a separate table for ticket views does not control record-level edit versus read permissions. Option B is incorrect because business rules enforce field-level logic and validation, not security role-based edit restrictions. Option D is incorrect because Power Apps sharing controls app access, not Dataverse table record privileges, so it does not restrict editing to the Help Desk Agents role.

Answer

Create a new Dataverse table for ticket views

Answer

Create a business rule to restrict editing to certain users

Answer

Share the app with all employees using the Power Apps sharing feature