PL-900 Demonstrate the capabilities of Power Automate Practice Test 8 — 15 Questions

Question 1

Which TWO components are required to create a Power Automate flow that sends an email when a new item is added to a SharePoint list? (Choose two.)

Accepted Answer

A trigger. A trigger is required because a Power Automate flow must have a starting event to initiate execution. For a SharePoint list, the 'When an item is created' trigger fires automatically when a new item is added, which is the necessary first step before any actions can run.

Answer

An approval action

Answer

A variable

Answer

A condition

Question 2

A Power Automate flow uses the trigger configuration shown. Users report that the flow does not start when a new order is added with Status = 'Pending'. What is the most likely cause?

Accepted Answer

The trigger condition only allows items with Status = 'New'. The trigger condition explicitly filters for items where Status equals 'New'. When a new order is added with Status = 'Pending', the condition evaluates to false, so the flow does not trigger. Trigger conditions in Power Automate act as a pre-filter on the trigger event, preventing the flow from running if the condition is not met.

Answer

The SharePoint dataset URL is incorrect

Answer

The flow is paused or turned off

Answer

The trigger only fires on modification, not creation

Question 3

You are a Power Automate developer for a large retail company. The company uses a SharePoint Online list named 'SalesOrders' to track orders. Each order has a Status column (choice: New, Processing, Shipped, Delivered). When an order is updated to 'Shipped', a flow should send an email with tracking info to the customer. Additionally, if the order amount exceeds $10,000, a manager must approve the shipment before the email is sent. You create a flow with a trigger 'When an item is modified' and add a condition to check if Status equals 'Shipped'. Inside the condition, you add an approval action. The flow currently sends the approval to the manager for all orders, even those under $10,000. You need to modify the flow so that orders under $10,000 skip the approval and directly send the email. What should you do?

Accepted Answer

Add a second condition inside the 'Status equals Shipped' condition that checks if amount exceeds $10,000; place the approval action inside this new condition, and the email action after it. It adds a nested condition inside the existing 'Status equals Shipped' condition to check if the order amount exceeds $10,000. The approval action is placed inside this nested condition (for orders over $10,000), while the email action is placed after the nested condition but still within the 'Status equals Shipped' condition. This ensures that only orders over $10,000 require manager approval, and all shipped orders (regardless of amount) eventually send the email—either directly (if under $10,000) or after approval (if over $10,000).

Answer

Modify the existing condition to check if amount exceeds $10,000, and if false, terminate the flow

Answer

Use a 'Switch' action based on the amount, with cases for >10000 and <=10000

Answer

Add a 'Parallel branch' after the trigger: one branch for approval, one for email

Question 4

Drag and drop the steps to create a Power BI report from a Dataverse table in the correct order.

Accepted Answer

Connect to Dataverse, then load data, then build visuals, then publish. The correct sequence for creating a Power BI report from a Dataverse table is to first connect to the Dataverse source, then load the data into Power BI, then build visuals (like charts and tables), and finally publish the report to the Power BI service for sharing. This order ensures a logical workflow where each step depends on the previous one.

Answer

Connect to Dataverse, then build visuals, then load data, then publish

Answer

Load data, then connect to Dataverse, then build visuals, then publish

Answer

Connect to Dataverse, then load data, then publish, then build visuals

Question 5

You need to create a flow that runs every hour and checks if any new files have been added to a SharePoint document library. Which trigger type should you use?

Accepted Answer

Recurrence. The Recurrence trigger is the correct choice because it initiates a flow on a fixed schedule (e.g., every hour) regardless of any events occurring in SharePoint. This trigger is ideal for polling scenarios where you need to periodically check for new files, as it runs autonomously without requiring an external event.

Answer

Compose

Answer

When an item is created

Answer

Power Apps button

Question 6

A company wants to automate the process of archiving completed sales orders from a SQL Server database to a SharePoint list every night. Which approach should they use?

Accepted Answer

Use a SQL Server connector with a 'Recurrence' trigger to query and move data.. It uses a Recurrence trigger to run the flow on a schedule (every night) to query SQL Server for completed sales orders and archive them to SharePoint. Option A uses an event-driven trigger (when an item is created) which is not suitable for a nightly batch process. Option B is an instant flow triggered manually by a button, not automated. Option C requires an external scheduler to send an HTTP request, but Power Automate's built-in Recurrence trigger is simpler and more appropriate.

Answer

Use a 'When an item is created' trigger on the SQL table.

Answer

Create an instant flow triggered by a Power Apps button for manual archiving.

Answer

Use a 'When a HTTP request is received' trigger from an external scheduler.

Question 7

You need to create a flow that sends an email notification when a new file is added to a OneDrive for Business folder. Which trigger should you use?

Accepted Answer

When a file is created (OneDrive for Business). The requirement specifies a OneDrive for Business folder, and the 'When a file is created (OneDrive for Business)' trigger is the only one that directly monitors a OneDrive for Business location for new file additions. This trigger uses the OneDrive for Business connector, which is designed to work with the Microsoft Graph API for OneDrive for Business, and it fires specifically when a new file is created, not modified.

Answer

When a file is created (SharePoint)

Answer

When a file is modified (OneDrive for Business)

Answer

When a file is created (OneDrive)

Question 8

Your Power Automate flow uses an HTTP action to call a REST API. The API returns a JSON array of objects. You need to process each object and create a record in a SQL Server database. Which actions should you use?

Accepted Answer

Use 'Parse JSON' to define the schema, then 'Apply to each' with 'Insert row' inside.. To process a JSON array of objects from an HTTP response, you first use 'Parse JSON' to define the schema so Power Automate understands the structure, then use 'Apply to each' to iterate over the array, placing the 'Insert row' action inside the loop to create a SQL record per object. This is the standard pattern for iterating and inserting.

Answer

Use 'Filter array' to select objects, then 'Insert row'.

Answer

Use 'Compose' to store the JSON, then 'Insert row' directly.

Answer

Use 'Select' to transform the array, then 'Insert row' with a batch.

Question 9

Which TWO scenarios are best suited for using Power Automate scheduled flows?

Accepted Answer

Generating a daily sales report at 8 AM. Option B is correct because a scheduled flow is designed to run on a time-based recurrence, so generating a daily sales report at 8 AM is a classic use case where the Recurrence trigger fires once per day at the specified time. Option C is correct because archiving records older than 30 days every Sunday is also time-driven, and the Recurrence trigger can be configured to run weekly on Sundays to perform the cleanup automatically. The unmarked options A, D, and E are all event-driven scenarios: they should use automated triggers such as when a new expense report is submitted, when a new email arrives with a specific subject, or when a new file is added to SharePoint, rather than a scheduled recurrence.

Answer

Sending an approval request when a new expense report is submitted

Answer

Creating a task in Planner when a new email arrives with specific subject

Answer

Posting a message to Teams when a new file is added to SharePoint

Question 10

You need to design a flow that runs when a new response is submitted in Microsoft Forms. The flow should send an email to the respondent with a summary of their answers. Which trigger should you use?

Accepted Answer

When a new response is submitted. The correct trigger is 'When a new response is submitted' because the flow needs to run immediately after a new response is submitted. Option B, 'When a response is viewed', triggers when someone views the response. Option C, 'When a response is edited', triggers when the response is edited. Option D, 'When a response is modified', triggers when the response is modified (which includes edits or other changes). Only the 'When a new response is submitted' trigger fires on initial submission, which is required to send the summary email to the respondent.

Answer

When a response is viewed

Answer

When a response is edited

Answer

When a response is modified

Question 11

A company uses Power Automate to automate approval workflows for purchase orders. The flow should send an approval request to the manager of the requestor. When the manager approves, the flow should update a SharePoint list and send a confirmation email. However, the flow fails with an error 'Unable to find the manager for the specified user'. What is the most likely cause?

Accepted Answer

The user profile in Microsoft Entra ID does not have a manager assigned.. The error 'Unable to find the manager for the specified user' indicates that the user's profile in Microsoft Entra ID (Azure AD) does not have a manager attribute populated. Power Automate's approval action relies on the manager relationship defined in Entra ID to route the request.

Answer

The SharePoint list column for manager is missing.

Answer

The flow trigger is set to 'When a new item is created' but the item already exists.

Answer

The SharePoint list does not have the correct permissions.

Question 12

You are designing a Power Automate cloud flow that processes customer feedback from Microsoft Forms. The flow should send an email to the customer if their feedback rating is less than 3, and also post a message to a Microsoft Teams channel for all feedback. The flow works correctly for rating 2, but for rating 1 it sends two emails instead of one. What is the most likely cause?

Accepted Answer

The condition branch has two separate 'Send an email' actions that both run for rating 1.. The most likely cause is that the condition branch for 'Yes' (rating less than 3) contains two separate 'Send an email' actions, both of which are triggered when the condition is met. For rating 1, the condition is true, so both email actions execute, sending two emails. This is a common design error where a duplicate action is accidentally added. Option A is incorrect because the Teams action does not send emails. Option C is incorrect because the trigger fires once per submission. Option D is incorrect because the rating is numeric and the condition works correctly for rating 2, so comparison is not the issue.

Answer

The Teams action is configured to also send an email.

Answer

The flow is triggered multiple times due to multiple submissions.

Answer

The rating value is stored as text and the condition incorrectly compares numbers.

Question 13

Your organization uses Power Automate to automate the creation of support tickets in ServiceNow when a critical alert is triggered in Microsoft Sentinel. The flow uses the 'When a new alert is created' trigger from Sentinel. The flow runs but no tickets are created. You check the Sentinel log and see that alerts are being generated. What should you investigate first?

Accepted Answer

Review the trigger condition or filter query.. The flow runs successfully but produces no tickets, which means the trigger is firing but the condition inside the flow is filtering out the alerts. Since Sentinel confirms alerts are being generated, the most likely cause is that the trigger's condition or filter query (e.g., severity = High, or a specific analytics rule name) does not match the alerts being produced. Reviewing the trigger condition is the correct first step because it isolates whether the flow logic is excluding the alerts before the ServiceNow action ever executes.

Answer

Verify that the flow is enabled.

Answer

Ensure that the Sentinel data connector is properly installed.

Answer

Check if the ServiceNow connector is configured with the correct instance.

Question 14

Which TWO actions can you take to improve the performance and reliability of a Power Automate cloud flow? (Choose 2)

Accepted Answer

Use parallel branches for independent actions.. Option A is correct because parallel branches let independent actions execute concurrently instead of waiting on each other, reducing overall flow run duration and improving throughput in Power Automate cloud flows. Option D is correct because 'Configure Run After' settings allow an action to run even when a previous action fails, times out, or is skipped, enabling error handling, retry logic, and graceful failure recovery that directly improves reliability. Option B is incorrect because forcing all actions to run sequentially increases run time and does not inherently prevent conflicts, so it degrades rather than improves performance. Option C is incorrect because using 'Apply to each' loops for all list operations adds unnecessary iteration overhead and can hit concurrency and throttling limits, hurting performance. Option E is incorrect because adding approval steps to all flows introduces manual delays and does not improve performance or reliability.

Answer

Set all actions to run sequentially to avoid conflicts.

Answer

Use 'Apply to each' loops for all list operations.

Answer

Add approval steps to all flows for accountability.

Question 15

Which TWO triggers are available for Power Automate flows that start from a Dataverse table? (Choose 2)

Accepted Answer

When a row is added, modified, or deleted. Option B, "When a row is added, modified, or deleted," is correct because it is the Dataverse connector's combined change trigger that fires on create, update, or delete events against a specified table, letting a flow react to any of those data operations. Option E, "When a row is added," is correct because it is the Dataverse connector's dedicated trigger that fires only when a new row is created in a chosen table, which is exactly a Dataverse-based start condition. Option A is wrong because "When a new email arrives (Outlook)" is an Outlook connector trigger, not a Dataverse trigger. Option C is wrong because "When a new file is created (SharePoint)" is a SharePoint connector trigger. Option D is wrong because "PowerApps button" is a manual trigger invoked from a Power Apps control, not a Dataverse table change trigger.

Answer

When a new email arrives (Outlook)

Answer

When a new file is created (SharePoint)

Answer

PowerApps button