PL-900 Demonstrate the capabilities of Power Automate — 20 Questions

Question 1

A company wants to automate sending a welcome email to new employees after they are added to a SharePoint list. Which type of trigger should be used in the Power Automate flow?

Accepted Answer

When an item is created - SharePoint. The 'When an item is created - SharePoint' trigger is the correct choice because it initiates the flow automatically whenever a new item (in this case, a new employee record) is added to the specified SharePoint list. This event-driven trigger eliminates the need for manual intervention, making it ideal for automating the welcome email process immediately upon creation.

Answer

For a selected item - SharePoint

Answer

Recurrence

Answer

Start and wait for an approval

Question 2

You have a Power Automate flow that sends an email notification when a new file is added to a SharePoint document library. Users report that emails are not being sent for some files. What is the most likely cause?

Accepted Answer

A trigger condition is filtering out some files. Option C is correct because trigger conditions in Power Automate allow you to define expressions that must evaluate to true for the flow to run. If a condition is configured to filter out certain files (e.g., based on file name, metadata, or size), those files will not trigger the flow, and no email will be sent. This is the most likely cause when emails are missing for some files but not all.

Answer

The flow uses a premium connector that requires a license

Answer

The file is being co-authored by multiple users

Answer

The file content contains sensitive information

Question 3

You are designing a Power Automate flow to approve expense reports. The flow must allow managers to approve or reject directly from the email notification without signing in. Which action should you use?

Accepted Answer

Start and wait for an approval. The 'Start and wait for an approval' action is specifically designed to send an approval request via email or the Power Automate mobile app, and it allows recipients to approve or reject directly from the email notification without needing to sign in, using adaptive cards or lightweight approval buttons. This meets the requirement for manager approval without authentication.

Answer

Create a file

Answer

Send an email (V2)

Answer

Send an HTTP request

Question 4

A flow fails with the error: 'GatewayTimeout'. The flow connects to an on-premises SQL Server via a data gateway. What is the most likely cause?

Accepted Answer

The on-premises data gateway is not running or unreachable. The 'GatewayTimeout' error indicates that the flow successfully reached the on-premises data gateway but the gateway did not respond within the expected time frame. This typically occurs when the gateway service is not running, the machine hosting the gateway is offline, or network connectivity between the gateway and the SQL Server is broken. Incorrect credentials or missing tables would produce different errors (e.g., 'Login failed' or 'Invalid object name').

Answer

The SQL login credentials are incorrect

Answer

The SQL table does not exist

Answer

The flow trigger did not fire

Question 5

You need to design a Power Automate flow that processes orders from a CSV file in SharePoint. The flow should read each row and create a record in a SQL database. If a row contains invalid data, the flow should continue with the next row. Which configuration should you use?

Accepted Answer

Use an apply to each loop and configure 'Configure run after' for the SQL insert action to include 'is successful', 'has timed out', 'is skipped', 'has failed'. Option C is correct because configuring 'Configure run after' for the SQL insert action to include 'is successful', 'has timed out', 'is skipped', and 'has failed' ensures that even if a row fails validation or the SQL insert fails, the flow continues to the next iteration of the Apply to each loop. This allows the flow to process all rows in the CSV file without stopping on an error, meeting the requirement to skip invalid data and proceed with the next row.

Answer

Use parallel branches for each row

Answer

Use an apply to each loop with default settings

Answer

Use a scope with sequential actions and set 'Configure run after' to 'is successful' only

Question 6

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 7

Which THREE are valid options for handling errors in a Power Automate flow? (Choose three.)

Accepted Answer

Configure run after. Option A is correct because 'Configure run after' allows a flow action to execute based on the outcome (success, failure, skipped, or timed out) of a preceding action. This is the primary mechanism in Power Automate for handling errors by defining conditional execution paths after an action completes.

Answer

Parallel branches

Answer

Retry policy

Question 8

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'. Option D is correct because 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 9

You review a failed flow run with the log shown. The flow is supposed to send an email when a SharePoint item is created. What is the most likely issue?

Accepted Answer

The email connector is not properly configured or the SMTP server is down. The flow log shows a failure in the 'Send an email' action, not the trigger. Since the trigger (SharePoint 'When an item is created') successfully initiated the flow, the issue lies with the email connector. The most likely cause is that the email connector (e.g., Office 365 Outlook, SMTP) is misconfigured—such as incorrect SMTP server, port, authentication, or the SMTP server being unreachable—preventing the email from being sent.

Answer

The SharePoint trigger did not fire

Answer

The scope 'SendNotification' failed due to a missing variable

Answer

The SharePoint list permissions are incorrect

Question 10

You are a Power Platform administrator for a large enterprise. You have created a Power Automate cloud flow that sends an approval email to the manager whenever a new employee is added to the HR system. The flow uses a SharePoint list as the trigger and a Common Data Service (CDS) connector to update the employee record. Recently, the flow has been failing intermittently with the error: 'The request failed due to a network error. The server returned an error: GatewayTimeout'. You check the flow run history and see that the error occurs on the CDS update action. The SharePoint trigger and approval actions complete successfully. The flow runs with a concurrency setting of 10. The CDS environment is in another region. You need to resolve the timeout issue. What should you do?

Accepted Answer

Increase the timeout setting for the CDS update action in the flow.. Option A is correct because the GatewayTimeout error indicates that the CDS update action is taking longer than the default timeout (typically 2 minutes) to complete, especially given the cross-region latency. Increasing the timeout setting for the CDS action allows the flow to wait longer for the response, resolving the intermittent failure without altering the flow's logic or concurrency.

Answer

Split the flow into two: one for the SharePoint trigger and one for the CDS update, and trigger the second via HTTP request.

Answer

Restart the CDS environment to clear any temporary issues.

Answer

Reduce the concurrency setting to 1 to prevent multiple simultaneous requests.

Question 11

Which TWO scenarios are suitable for using a scheduled cloud flow in Power Automate?

Accepted Answer

Backing up a database to a cloud storage every night at midnight. Scheduled cloud flows run on a recurring schedule, making them ideal for time-based automation like nightly backups or daily report generation. Option B triggers at a specific time (midnight) without requiring an external event, which matches the scheduled flow pattern exactly.

Answer

Creating a file in SharePoint whenever a new file is uploaded to a OneDrive folder

Answer

Sending an approval request to a manager when a new expense report is submitted

Answer

Sending a welcome email to a new user immediately after they sign up

Question 12

Refer to the exhibit. The flow fails to send the email. What is the most likely cause?

Accepted Answer

The email action does not include the list of opportunities in the body. Option D is correct because the flow's email action is configured to send a static email body without including the dynamic content from the 'List rows' action. Even if the trigger and filter are correct, the email will not contain the list of opportunities, so the flow appears to fail in its purpose. Power Automate requires explicit insertion of dynamic content (e.g., the 'value' array from Dataverse) into the email body to transmit the data.

Answer

The filter condition 'statecode eq 0' is invalid

Answer

The recurrence trigger is incorrectly configured

Answer

The connections to Dataverse and Office 365 are not established

Question 13

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. Option B is correct because 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 14

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

Question 15

Match each Power Apps license type to its description.

Question 16

Your organization uses Power Automate to automate approval workflows in SharePoint. When a user creates a new item in a SharePoint list, an approval request should be sent to their manager. However, some approvals are not being triggered. What is the most likely cause?

Accepted Answer

The trigger is set to 'When an item is created or modified' and the item is being created and then modified immediately.. The SharePoint trigger 'When an item is created' must be set to trigger only on new items, not on changes. A common misconfiguration is setting the trigger to 'When an item is created or modified', which can cause missed triggers if the item is created and then quickly modified. Option A is incorrect because SharePoint triggers do not require a premium license for basic actions. Option C is incorrect because permissions to the list do not affect the trigger's ability to fire. Option D is incorrect because the delay is unrelated to the trigger configuration.

Answer

The flow requires a premium Power Automate license.

Answer

The user does not have permission to view the SharePoint list.

Answer

The flow has a 'Delay' action before the approval step.

Question 17

A company wants to automate sending a welcome email to new users added to Microsoft Entra ID. Which Power Automate trigger should they use?

Accepted Answer

When a user is added to a group. The 'When a user is added to a group' trigger is designed for this scenario. Option B is a trigger for Office 365 users, not Entra ID. Option C is a trigger for Microsoft Entra ID but requires a premium license and is for user modifications. Option D is a trigger for Microsoft Entra ID but is for user deletions.

Answer

When a user is deleted (Microsoft Entra ID)

Answer

When a user is modified (Microsoft Entra ID)

Answer

When a new user is created (Office 365 Users)

Question 18

Refer to the exhibit. You have a Power Automate flow that sends an approval email and then checks if the email was sent successfully. If successful, it updates a SharePoint item status to 'Approved'. Otherwise, it sends a rejection email. However, the flow always updates the SharePoint item to 'Approved' even when the approval email fails. What is the likely issue?

Accepted Answer

The flow uses 'Send an email' instead of a proper approval action.. The condition checks the status of the 'Send_approval_email' action, but the action only sends the email; it does not wait for the recipient to respond. The status 'Succeeded' simply means the email was sent, not that it was approved. To implement an approval, you should use the 'Start and wait for an approval' action. Option B is incorrect because the condition syntax is correct. Option C is incorrect because the status is correctly referenced. Option D is incorrect because the email address is provided.

Answer

The 'email/To' parameter is missing the recipient's email.

Answer

The condition expression is incorrectly formatted.

Answer

The 'body' function should be 'outputs' instead.

Question 19

A manufacturing company uses Power Automate to monitor equipment sensors. When a temperature sensor exceeds a threshold, a flow sends an alert to the maintenance team. However, duplicate alerts are being sent for the same event. What should the flow developer implement to prevent duplicates?

Accepted Answer

Use a 'When an HTTP request is received' trigger and check for a unique identifier.. Using a 'Cooldown' or 'Debounce' pattern with a variable or a data operation can prevent duplicate triggers. The trigger for HTTP request can receive the same event multiple times if the sensor resends. Option A would delay all alerts, not prevent duplicates. Option B would not prevent duplicates because the trigger fires for each HTTP request. Option D is not a built-in feature and would require custom logic.

Answer

Use the 'Get changes' action for the sensor data.

Answer

Increase the threshold value so alerts are less frequent.

Answer

Add a 'Delay' action of 5 minutes before sending the alert.

Question 20

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