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

Question 1

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?

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

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'. 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 2

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

Accepted Answer

Configure run after. Configure run after (A) is correct because it allows an action to run based on the success, failure, or timeout of a previous action. Scope (B) is correct because it groups actions and can be used with 'Configure run after' to implement error handling patterns. Retry policy (D) is correct because it automatically retries an action upon failure, defining the number of retries and interval. Parallel branches (C) is not an error-handling feature; it runs actions concurrently. Try-catch-finally pattern using scopes (E) is a user-designed pattern, not a built-in error-handling option in Power Automate.

Answer

Parallel branches

Answer

Try-catch-finally pattern using scopes

Question 3

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 4

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

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. Option B is correct because backing up a database every night at midnight is a recurring, time-based task that fits a scheduled cloud flow, which uses a Recurrence trigger with a daily schedule at 12:00 AM. Option E is correct because generating a daily report every morning at 8 AM is also a time-driven, recurring operation, matching a scheduled flow with a Recurrence trigger set to daily at 8:00 AM. Options A, C, and D are not suitable because they are event-driven scenarios: A requires a OneDrive 'When a file is created' trigger, C requires a SharePoint/Dataverse 'When an item is created' trigger for the expense report, and D requires an immediate event trigger such as a new user sign-up, none of which are scheduled.

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 6

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

Match each Power Apps license type to its description.

Accepted Answer

Power Apps per user plan: A user can run unlimited custom apps and access premium connectors.. Correct matches: Per user plan gives unlimited app access and premium connectors; per app plan is for a single app; Office 365 plan offers limited standard connector usage. Common confusions involve swapping the per user and per app definitions or overstating the Office 365 capabilities.

Answer

Power Apps per user plan: A user can run only one specific app.

Answer

Power Apps for Office 365: A user can run unlimited custom apps with premium connectors.

Question 8

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 9

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 new user is created (Office 365 Users). The 'When a new user is created (Office 365 Users)' trigger in Power Automate fires when a new user account is created in Microsoft Entra ID (formerly Azure AD). This is the correct trigger to automate sending a welcome email to new users. The Office 365 Users connector provides this trigger specifically for user creation events.

Answer

When a user is deleted (Microsoft Entra ID)

Answer

When a user is added to a group

Answer

When a user is modified (Microsoft Entra ID)

Question 10

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 flow uses the 'Send an email' action, which only sends an email message; it does not implement an approval process. The 'Succeeded' status indicates the email was sent, not that the recipient approved. To create an approval, you must use the 'Start and wait for an approval' action, which pauses the flow until the recipient responds. Options A, B, and D are incorrect because they do not address the core issue: the lack of a proper approval action.

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 11

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.. The correct approach is Option B: using a 'When an HTTP request is received' trigger and checking for a unique identifier. This allows the flow to track which events have already been processed by storing the unique ID (e.g., in a variable or a data source) and skipping alerts for duplicate IDs. Option A ('Get changes') is not relevant for deduplication and is not a built-in action for this scenario. Option C (increasing the threshold) reduces alerts but doesn't prevent duplicates from the same event. Option D (adding a delay) merely postpones alerts, still allowing duplicates after the delay. Therefore, only Option B provides a reliable deduplication mechanism.

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 12

Refer to the exhibit. A flow is triggered when an email with 'Invoice' in the subject arrives, and it saves the first attachment to a SharePoint document library. However, the flow fails with an error 'InvalidTemplate'. What is the most likely cause?

Accepted Answer

An email with 'Invoice' in the subject arrives without an attachment.. The flow fails with 'InvalidTemplate' because the trigger is set to include attachments, but if an email with 'Invoice' in the subject arrives without an attachment, the expression that accesses the first attachment (e.g., triggerOutputs()?['attachments']?[0]) fails since the attachments array is empty. This is the most likely cause. Option A is incorrect because an invalid SharePoint folder path would produce a different error. Option B is incorrect because the trigger already includes attachments. Option D is incorrect because using the email subject for the file name would not cause an 'InvalidTemplate' error.

Answer

The SharePoint folder path is incorrect.

Answer

The trigger is not set to include attachments.

Answer

The file name is taken from the email subject instead of the attachment.

Question 13

Which THREE actions are available in Power Automate to handle errors and exceptions?

Accepted Answer

Use a 'Scope' action to group actions and configure error handling. Option A is correct because the 'Scope' action groups multiple actions into a single block, and its 'Configure run after' settings can be used to catch and handle failures for the whole group, which is the standard Power Automate error-handling pattern. Option B is correct because 'Configure run after' lets you define what happens when a preceding action fails, is skipped, or times out, enabling alternative or compensating actions on failure. Option E is correct because 'Run after' settings on an action are the mechanism that determines whether that action executes after success, failure, skip, or timeout of the previous step, which is how exception branches are built. Option C is not one of the three because retry policy is a resilience setting that automatically retries transient failures, not a distinct error-handling action for branching or catching exceptions. Option D is not correct because the 'if' function in expressions only performs conditional logic on values and cannot itself detect or handle runtime action failures.

Answer

Enable 'Retry policy' on an action to automatically retry on failure

Answer

Use the 'if' function in expressions to check for errors

Question 14

Which TWO connectors are available in Power Automate without a premium license?

Accepted Answer

SharePoint. SharePoint (B) is a standard connector included with every Power Automate license, so flows can read/write lists, libraries, and items without premium. Microsoft Teams (E) is likewise a standard connector, allowing flows to post messages, create channels, and trigger on Teams events at no extra cost. SQL Server (A), Azure Blob Storage (C), and Salesforce (D) are all premium connectors that require a Power Automate Premium, per-flow, or per-user plan, so they are not available without a premium license.

Answer

SQL Server

Answer

Azure Blob Storage

Answer

Salesforce

Question 15

A company uses Power Automate to process incoming emails. Some emails need to be forwarded to a manager, while others need to be saved to SharePoint. The decision is based on the email subject. Which action should be used to implement the branching logic?

Accepted Answer

Condition. The 'Condition' action allows branching based on a true/false condition, making it suitable for deciding between forwarding to manager or saving to SharePoint based on the email subject. 'Switch' (Option A) is used for branching based on multiple values, 'Apply to each' (Option E) is for iteration, 'Compose' (Option C) is for creating static data, and 'Select' (Option D) is for transforming arrays.

Answer

Switch

Answer

Compose

Answer

Select

Answer

Apply to each

Question 16

You are a Power Automate administrator for Contoso Corporation. The company uses Microsoft 365 E5 licenses. The sales team uses a SharePoint Online list named 'Leads' to track potential customers. The list has columns: Title (single line of text), Email (single line of text), Status (choice: New, Contacted, Qualified, Lost), and Score (number). The sales manager wants to automate the following process: When a new lead is added with Status = 'New' and Score > 50, an approval request should be sent to the manager. If approved, the lead Status should be updated to 'Contacted' and an email should be sent to the lead's email address. If rejected, the lead Status should be updated to 'Lost'. Additionally, if the lead is not approved within 7 days, the flow should automatically set Status to 'Lost'. The manager is often on leave, so the flow should also send a reminder to the manager every 2 days if the approval is pending. You need to design the flow using Power Automate. Which of the following designs best meets the requirements?

Accepted Answer

Use a 'When an item is created' trigger with a condition on Score > 50 and Status = 'New'. Inside the condition, use 'Start and wait for an approval' with a 7-day timeout. After approval, update item and send email. For reminders, create a separate scheduled flow that runs every 2 days, queries SharePoint for items with Status = 'New' and approval pending, and sends an email.. It uses the 'When an item is created' trigger with a condition on Score > 50 and Status = 'New'. Inside the condition, it uses 'Start and wait for an approval' with a 7-day timeout, which automatically handles the timeout and subsequent actions. For reminders, it uses a separate scheduled flow that runs every 2 days, queries items with pending approvals, and sends a reminder email. Option A uses a Power Apps approval screen with an HTTP trigger, which does not handle the 7-day timeout or automated reminders. Option C uses a 'Parallel branch' with a single 'Delay' action, which does not send reminders every 2 days (it would only delay once) and would block the flow. Option D uses a 'Recurrence' trigger every hour instead of reacting to item creation, integrates the timeout with a 'Delay until' action rather than the approval action's built-in timeout, and uses a 'Compose' action to track reminders, which is insufficient to send recurring reminders.

Answer

Use a 'When an item is created' trigger with a condition on Score > 50 and Status = 'New'. Use 'Send an email' to notify the manager and include a link to a Power Apps approval screen. Use a separate flow triggered by an HTTP request from Power Apps to update the item.

Answer

Use a 'When an item is created' trigger with a condition on Score > 50 and Status = 'New'. Inside the condition, use 'Start and wait for an approval' with a 7-day timeout. After approval, update the item and send email. Use 'Parallel branch' to send a reminder every 2 days by adding a 'Delay' action followed by an email.

Answer

Use a 'Recurrence' trigger that runs every hour, queries the SharePoint list for items with Status = 'New' and Score > 50, then sends an approval request. Use a 'Delay until' action to set a 7-day timeout. Use a 'Compose' action to track reminders.

Question 17

Your organization uses Power Automate to automatically create a task in Microsoft Planner when a new sales opportunity is closed in Dynamics 365. The flow triggers on a new opportunity but fails to create the task. You check the run history and see an error: 'Invalid template specification' in the 'Create a task' action. How should you resolve this?

Accepted Answer

Ensure the Planner bucket and plan are specified correctly in the action.. The error 'Invalid template specification' in the 'Create a task' action typically occurs when the Planner action is not properly configured, specifically the bucket and plan fields are missing or incorrect. Therefore, ensuring that the Planner bucket and plan are specified correctly (Option B) resolves the issue. Option A is incorrect because the error is not related to the Dynamics 365 connection. Option C is incorrect because changing the trigger does not address the template specification error. Option D is incorrect because the error is about task configuration, not permissions.

Answer

Recreate the connection to Dynamics 365.

Answer

Change the trigger to 'When a record is updated' instead of created.

Answer

Grant the flow service principal Planner permissions.

Question 18

A Power Automate flow sends an approval request to a user's manager. The flow uses the 'Get manager' action from the Office 365 Users connector. The flow runs successfully but the approval is never received by the manager. What is the most likely reason?

Accepted Answer

The manager does not have a valid email mailbox.. The most likely reason the approval is never received is that the manager's email mailbox is not enabled or is invalid. The 'Get manager' action retrieves the manager's email address from Microsoft Entra ID. However, if the manager does not have an active Exchange Online mailbox (e.g., they are a distribution group member or the mailbox is disabled), the approval email will not be delivered. Option A is incorrect because the flow runs successfully, indicating the connector is configured correctly. Option B is incorrect because the approval channel (Teams vs email) does not affect delivery if the manager lacks a mailbox. Option D is incorrect because the manager's user profile exists in Microsoft Entra ID (the flow finds their email), but the mailbox itself may be missing or disabled.

Answer

The Office 365 Users connector is not properly configured.

Answer

The approval action is configured to use the Teams channel instead of email.

Answer

The manager's user profile is missing in Microsoft Entra ID.

Question 19

You have a Power Automate flow that monitors a SharePoint list for new items and then sends a custom email notification using the 'Send an email (V2)' action. The email includes an attachment from the SharePoint item. Some users report that the attachment is missing from the email. What should you check first?

Accepted Answer

Check if the flow includes a 'Get file content' action before the email action.. The most common reason for missing attachments in a Power Automate email is that the file content has not been retrieved separately from the SharePoint list item. The 'Send an email (V2)' action does not automatically include attachments from the triggering item. You must use the 'Get file content' action to retrieve the attachment's binary data and then pass it to the email action. Option B is not the first check because the trigger being correct does not guarantee the attachment is retrieved. Option C, while permissions can be a factor, is not the most direct cause—the flow usually has permissions, but the content needs to be explicitly fetched. Option D is incorrect because 'Send an email with options' is for approvals, not a fix for missing attachments.

Answer

Verify that the flow trigger is set to 'When a new item is created'.

Answer

Ensure the SharePoint list has the correct permissions for the flow.

Answer

Change the email action to 'Send an email with options'.

Question 20

A Power Automate flow uses a 'When a HTTP request is received' trigger. The flow is called by an external application. The flow runs successfully but the external application receives a '500 Internal Server Error' response. What is the most likely cause?

Accepted Answer

The flow does not have a 'Respond to a PowerApp or flow' action to send a response.. When a Power Automate flow is triggered by an HTTP request, it must include a 'Respond to a PowerApp or flow' action to send a response back to the caller. If this action is missing, the flow will still run but the HTTP trigger will timeout or return a 500 error because no response is sent. Option A is incorrect because if the flow were disabled, the trigger would not fire and the external application would likely get a 404 or 503, not a 500. Option B is incorrect because the flow runs, meaning the request was received; a payload mismatch would cause a different error (like a 400) or failure within the flow. Option D is incorrect because authentication issues typically return 401 Unauthorized, not 500.

Answer

The flow is disabled or paused.

Answer

The external application is not sending the correct JSON payload.

Answer

The flow requires authentication and the API key is missing.