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

Question 1

A company wants to create a mobile app for field technicians to view and update work orders. The work orders are stored in a SharePoint list. Technicians need to filter work orders by status and take photos of completed work, attaching them to the work order. Which type of Power App should you recommend? A) Model-driven app B) Canvas app C) Power Pages website D) Power Automate flow

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

Accepted Answer

Canvas app. Canvas apps provide a flexible, customizable user interface that supports camera controls for taking photos and can easily connect to SharePoint lists for data storage and filtering. Option B (Power Automate flow) is incorrect because it is an automation tool, not an app builder. Option C (Model-driven app) is less suitable due to limited UI customization for camera integration. Option D (Power Pages) is designed for external websites, not mobile field technician apps.

Answer

Power Automate flow

Answer

Model-driven app

Answer

Power Pages website

Question 2

You are developing a canvas app for a global sales team that needs to access customer data from Dataverse. The app must support offline capability so that sales reps can view and update customer records even without internet connectivity. The app will sync changes when the connection is restored. Which feature should you configure? A) Enable the 'Offline' setting in the app settings and add the Dataverse table to the offline profile. B) Use the 'SaveData' and 'LoadData' functions to manually manage offline data. C) Use Power Automate to cache data on the device. D) Use SharePoint as the data source because it supports offline natively.

Accepted Answer

Enable the 'Offline' setting in the app settings and add the Dataverse table to the offline profile.. The offline feature in Power Apps canvas apps allows you to define offline profiles for Dataverse tables, enabling offline use. Option B: SaveData/LoadData can be used but require manual handling and are not integrated with Dataverse sync. Option C: Power Automate does not provide offline caching for apps. Option D: SharePoint offline is limited and may not meet requirements.

Answer

Use Power Automate to cache data on the device.

Answer

Use the 'SaveData' and 'LoadData' functions to manually manage offline data.

Answer

Use SharePoint as the data source because it supports offline natively.

Question 3

A non-profit organization uses Power Apps to manage volunteer information. They have a Dataverse table called 'Volunteers' with columns: Name, Email, Phone, Status (Active/Inactive). They want to create a dashboard that shows the count of active volunteers by city. The city information is stored in a separate 'Address' table related to Volunteers. Which approach should you use to display this data in a canvas app? A) Add a chart control and configure it to aggregate data from the Volunteers table. B) Use a group by in a gallery and apply a filter to count active volunteers by city. C) Create a Power BI tile embedded in the app. D) Use the 'CountRows' function in a label with a filter.

Accepted Answer

Use a group by in a gallery and apply a filter to count active volunteers by city.. Using a gallery with group by and filters can aggregate data. Option A: Chart control in canvas apps does not support related table data directly. Option C: Power BI tile requires additional licensing and setup. Option D: CountRows in a label gives a single number, not breakdown by city.

Answer

Add a chart control and configure it to aggregate data from the Volunteers table.

Answer

Create a Power BI tile embedded in the app.

Answer

Use the 'CountRows' function in a label with a filter.

Question 4

A company uses Power Apps to manage expense reports. Employees submit expense reports via a canvas app that writes to a Dataverse table. Managers need to approve or reject expenses. Which Power Platform component should you use to implement the approval workflow? A) Add an approval step in the canvas app using the 'Approval' connector. B) Use Power Automate with the 'Start and wait for an approval' action. C) Create a business rule in Dataverse to send email. D) Use Power BI to notify managers.

Accepted Answer

Use Power Automate with the 'Start and wait for an approval' action.. Power Automate provides built-in approval actions. Option A is incorrect because Power BI is for analytics, not workflow. Option C is incorrect because adding an approval step directly in a canvas app using the 'Approval' connector is not standard; that connector is typically used in Power Automate. Option D is incorrect because business rules in Dataverse cannot initiate approval workflows.

Answer

Use Power BI to notify managers.

Answer

Add an approval step in the canvas app using the 'Approval' connector.

Answer

Create a business rule in Dataverse to send email.

Question 5

You are building a model-driven app for a healthcare organization to manage patient appointments. The app uses a Dataverse table 'Appointments' with columns: Patient (lookup to Contact), Doctor (lookup to User), AppointmentDate, Status (Scheduled, Completed, Cancelled). You need to ensure that doctors cannot view appointments of other doctors. Doctors belong to a security role 'Doctor'. Which approach should you use? A) Create a team with all doctors and share the app with the team. B) Configure field-level security to hide the Doctor field. C) Use hierarchy security to limit access based on the Doctor field. D) Create a custom role with record-level security and configure sharing to only allow doctors to see their own appointments.

Accepted Answer

Create a custom role with record-level security and configure sharing to only allow doctors to see their own appointments.. The correct approach is to create a custom security role with record-level security and configure sharing so doctors only see their own appointments. In Dataverse, record-level access is controlled through security roles that define privileges (Create, Read, Write, Delete, Append, Append To, Assign, Share) on tables. By default, a security role grants access at the organization, business unit, or user level. To restrict doctors to only their own appointments, you must set the Read privilege on the Appointments table to 'User' level, meaning they can only read records they own or that are shared with them. Since the Doctor column is a lookup to User, you can configure the app or a business rule to set the owner or use sharing to grant access only when the Doctor equals the current user. This ensures that each doctor sees only their appointments, not those of other doctors.

Answer

Configure field-level security to hide the Doctor field.

Answer

Create a team with all doctors and share the app with the team.

Answer

Use hierarchy security to limit access based on the Doctor field.

Question 6

You are creating a canvas app for a small business to manage customer orders. The orders are stored in an Excel file on OneDrive for Business. The app needs to display a list of orders and allow users to add new orders. Which data source should you use? A) Import Excel data into Dataverse. B) Connect to the Excel file stored on OneDrive using the OneDrive for Business connector. C) Create a SharePoint list and import the Excel data. D) Use the Excel connector with a SharePoint document library.

Accepted Answer

Connect to the Excel file stored on OneDrive using the OneDrive for Business connector.. The OneDrive for Business connector allows direct connection to Excel files. Option A: Importing to Dataverse is unnecessary for a small business. Option C: Creating a SharePoint list is extra work. Option D: Excel connector requires SharePoint, not OneDrive.

Answer

Import Excel data into Dataverse.

Answer

Use the Excel connector with a SharePoint document library.

Answer

Create a SharePoint list and import the Excel data.

Question 7

You are developing a canvas app that uses a SQL Server database as a data source. The app needs to display a list of orders and allow users to filter by date range. The SQL table has millions of rows. To ensure optimal performance, which approach should you use? A) Use the 'Filter' function in Power Apps to filter the data on the client side. B) Use a SQL view that filters data server-side and call it via the SQL connector. C) Use Power Automate to retrieve data and pass it to the app. D) Use the 'Search' function on the gallery.

Accepted Answer

Use a SQL view that filters data server-side and call it via the SQL connector.. Using a SQL view that filters data server-side minimizes data transfer over the network, improving performance with large datasets. Option A: Using Power Automate adds unnecessary latency and complexity. Option B: The Filter function in Power Apps retrieves all rows from the SQL table and then filters client-side, which is inefficient for millions of rows. Option D: The Search function also operates on client-side data, leading to performance degradation.

Answer

Use Power Automate to retrieve data and pass it to the app.

Answer

Use the 'Filter' function in Power Apps to filter the data on the client side.

Answer

Use the 'Search' function on the gallery.

Question 8

A company has a model-driven app for project management. Project managers need to add a custom button to the ribbon that runs a Power Automate flow to send a status report. Which tool should you use to customize the ribbon? A) Power Apps Solution Explorer B) Command bar designer in the app designer C) PCF (Power Apps Component Framework) D) Ribbon Workbench tool

Accepted Answer

Command bar designer in the app designer. The command bar designer in the app designer allows adding custom buttons that invoke flows, offering a modern and supported method for customizing the ribbon in model-driven apps. Option B: PCF is used for building custom components, not simple button actions. Option C: Solution Explorer is for classic customizations but is not recommended for modern apps. Option D: Ribbon Workbench is a third-party tool, not an official Microsoft tool.

Answer

PCF (Power Apps Component Framework)

Answer

Power Apps Solution Explorer

Answer

Ribbon Workbench tool

Question 9

A user wants to create a Power App that can be used by external customers to submit support tickets. The app should not require customers to sign in. Which type of Power Apps portal should you use? A) Canvas app with anonymous access B) Model-driven app with anonymous access C) Power Pages D) Power Automate portal

Accepted Answer

Power Pages. Power Pages is the correct choice because it is designed for external-facing portals that can be accessed anonymously, allowing customers to submit support tickets without signing in. Option A (Power Automate portal) is used for managing flows, not for building portals. Option C (Canvas app with anonymous access) requires authentication; Canvas apps do not support true anonymous access. Option D (Model-driven app with anonymous access) also requires authentication; model-driven apps are for internal users with proper licensing.

Answer

Power Automate portal

Answer

Canvas app with anonymous access

Answer

Model-driven app with anonymous access

Question 10

Which TWO of the following are valid ways to share a canvas app with other users? (Choose TWO.)

Accepted Answer

Share the app with a security group.. Option C is correct because Power Apps allows you to share a canvas app with a security group, which is an Microsoft Entra ID security group used to grant access to multiple users at once. Option E is correct because you can share a canvas app directly with individual users by entering their email addresses in the share pane. Option A is incorrect because distribution groups are mail-enabled groups that cannot be used for app sharing permissions in Power Apps. Option B is incorrect because there is no 'Everyone' option in the share settings; you cannot share an app with the entire organization in one action. Option D is incorrect because Microsoft 365 groups are not supported for sharing canvas apps; only security groups and individual users are valid.

Answer

Share the app with a distribution group.

Answer

Share the app with everyone in the organization by selecting 'Everyone' in the share settings.

Answer

Share the app with a Microsoft 365 group.

Question 11

A manufacturing company uses Power Apps to manage inventory tracking. The current app is a canvas app connected to a SharePoint list. The operations team needs to add a new feature that allows warehouse staff to scan barcodes using a mobile device camera to look up product details. Additionally, the app must work offline in areas with no internet connectivity and sync data when connectivity is restored. The app should also incorporate a Copilot assistant to help staff quickly find product information using natural language queries. The IT department requires that the app be deployed to all warehouse staff without requiring manual installation. Which approach should you take to meet all requirements?

Accepted Answer

Add the Barcode scanner control, configure the app for offline use with sync, integrate Copilot using the AI Builder 'Ask a question' component, and deploy the app via Power Apps mobile app with a managed solution and installation policy.. It combines all four required capabilities: the Barcode scanner control for camera-based scanning, offline configuration with sync for no-connectivity areas, Copilot integration via the AI Builder 'Ask a question' component for natural-language product queries, and deployment through the Power Apps mobile app using a managed solution with an installation policy so staff receive it without manual installation. This is the only option that satisfies every requirement end-to-end.

Answer

Add a Text input control for manual barcode entry, use Power Automate flows to fetch product details, enable offline by storing data locally in collections, and deploy by sending a deep link.

Answer

Use a Power Fx formula with the Camera control to decode barcodes, enable offline data in SharePoint lists, add a Copilot chat box, and deploy via Microsoft Intune as a required app.

Answer

Add the Barcode scanner control to the canvas app, enable offline mode in app settings, integrate Copilot using the Copilot control, and deploy the app by sharing it via email link.

Question 12

A healthcare organization is developing a Power Apps model-driven app for patient case management. The app uses Microsoft Dataverse as the data source and includes a custom table named 'Patient Cases' with columns: Patient Name, Case Type (choice: Consultation, Procedure, Follow-up), Assigned Doctor, Status (choice: New, In Progress, Completed), and Priority (choice: Low, Medium, High, Critical). The organization requires that when a case is created with Priority = 'Critical', an immediate notification must be sent to the Assigned Doctor via Microsoft Teams and the case must be automatically escalated to the manager if not resolved within 4 hours. Additionally, the app must use a Copilot to summarize patient history when a case is opened. The security team mandates that only doctors and managers can view cases assigned to them, and that all data access must be audited. Which combination of features should you implement to meet all requirements with minimal custom development?

Accepted Answer

Implement JavaScript in the form to call Power Automate for notifications, use owner teams to restrict access, add a custom Copilot page, and enable auditing via Power Apps settings.. JavaScript on the form can call Power Automate via the Xrm.WebApi or a custom action to send Teams notifications, owner teams restrict record access to assigned doctors/managers, a custom Copilot page summarizes patient history, and enabling auditing in Power Apps settings satisfies the audit requirement — all with minimal custom development. This combination directly maps each requirement to a native Power Platform feature.

Answer

Use a Dataverse business process flow to trigger Power Automate flows for notifications and escalation, configure field-level security profiles to restrict data access, enable Copilot in the model-driven app to summarize patient history, and enable audit logging on the Patient Cases table.

Answer

Design a Power Automate flow triggered on case creation that sends Teams notifications and waits for 4 hours before escalation, use sharing permissions to control access, and embed a Copilot AI Builder component.

Answer

Create business rules to send email notifications and set escalation timers, use role-based security for data access, add a Copilot chat control, and rely on Dataverse default auditing.

Question 13

A retail company is building a Power Apps canvas app for store managers to review sales performance. The app connects to a SQL database and displays real-time sales data. The managers need to be able to filter data by store and date range, and view the data in a chart. The company wants to minimize licensing costs while ensuring scalability and performance. Which TWO features should you recommend?

Accepted Answer

Create a SQL stored procedure to filter and aggregate data before sending to the app.. Option B is correct because delegating filtering and aggregation to a SQL stored procedure lets the database engine do the heavy lifting, reducing the volume of rows transferred to the canvas app and improving performance and scalability for real-time sales data. Option D is correct because embedding a Power BI tile provides rich, interactive charts and graphs that respect the store and date-range filters, and it leverages Power BI's optimized rendering and aggregation rather than building charts manually in the app. Option A is not needed because the built-in SQL Server connector already provides secure connectivity, and a custom connector adds complexity without cost or performance benefit. Option C is wrong because Collect() loading all data on app start is not delegable, hurts performance and scalability, and offline access was not requested. Option E is wrong because Office365Users retrieves user profile data, not sales data from Excel Online, and Excel Online is not the stated SQL data source.

Answer

Build a custom connector to the SQL database for enhanced security.

Answer

Use Collect() to load all data into a collection on app start for offline access.

Answer

Use the Office365Users connector to retrieve sales data from Excel Online.

Question 14

A canvas app uses a SharePoint list as its data source. The list contains 8,000 items, and the app's gallery shows only the first 500. A developer wants the gallery to display all items matching a filter condition entered by the user. What should the developer do?

Accepted Answer

Increase the app's data row limit in Settings to 2000 and use a delegable filter. To display more than the default 500 rows from a SharePoint list, the data row limit must be increased in App Settings, and the query must be delegable so SharePoint handles filtering server-side. Using a delegable equality filter on an indexed column with the limit raised to 2000 allows the gallery to return all 8,000 matching items in batches. Non-delegable functions and collections cap results at the default limit.

Answer

Use Collect to load all 8,000 items into a collection when the app starts

Answer

Set the gallery's Items property to Filter(SharePointList, Title = TextInput1.Text)

Answer

Set the gallery's Items property to Search(SharePointList, TextInput1.Text, "Title")

Question 15

You are building a canvas app that will be used by field technicians on mobile devices. The app must collect inspection data, including photos and GPS coordinates, even when technicians are in areas with no network connectivity. The data should sync automatically when connectivity is restored. What is the most appropriate approach?

Accepted Answer

Use the Power Apps mobile app's built-in offline mode, which automatically caches data and syncs changes when the device reconnects.. The Power Apps mobile app offers an offline mode specifically designed for canvas apps, enabling them to store data locally and sync automatically when connectivity is restored. This avoids complex custom code and leverages built-in features. Other options either require manual synchronization logic or use platforms that do not integrate seamlessly with canvas apps for offline scenarios.

Answer

Store the inspection data in a SharePoint list and rely on SharePoint's mobile app offline sync to handle connectivity issues.

Answer

Create a model-driven app instead, because model-driven apps natively support offline data synchronization for mobile users.

Answer

Enable the app's offline capability by using the SaveData and LoadData functions to store data locally, and configure the app to sync when online.