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

Question 1

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 2

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 3

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 4

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 5

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 6

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 7

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 8

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 Azure AD. 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 9

Refer to the exhibit. A Power Automate flow definition is shown. The flow is supposed to trigger when a high-importance email with attachments arrives in the inbox, and then send a notification email to support. However, the flow does not trigger for emails that have attachments but are not marked as high importance. What is the most likely reason?

Accepted Answer

The importance filter is set to 'High', so lower importance emails are ignored.. The trigger parameters include 'importance': 'High', so only emails with high importance trigger the flow. If the email has attachments but is not marked as high importance, the flow will not trigger. Option A is incorrect because the folder path being set to 'Inbox' does not affect the trigger; the trigger fires on new emails arriving in the inbox regardless of folder. Option B is incorrect because attachments are set to 'Yes', meaning attachments are required, but the flow still triggers only on high-importance emails; the issue is the importance filter, not attachments. Option D is incorrect because the trigger is set to 'When a new email arrives', which fires on new emails; the email being read does not prevent the trigger from firing on arrival.

Answer

The folder path is set to 'Inbox' but the email was moved to a different folder.

Answer

The trigger requires attachments, so emails without attachments are ignored.

Answer

The trigger is set to 'When a new email arrives' but the email is already read.

Question 10

Refer to the exhibit. The Power Automate flow definition includes a manual trigger expecting employeeId and amount. If an expense amount is $6,000, what will happen?

Accepted Answer

The flow will start an approval assigned to manager@contoso.com.. The condition checks if amount > 5000; since $6,000 is greater, the 'Yes' branch runs, which starts an approval assigned to manager@contoso.com. Option A is wrong because the approval is sent to the manager, not the employee. Option C is wrong because employeeId is provided in the trigger and the condition does not depend on it. Option D is wrong because the flow sends an approval request (via Start an Approval), not just an email.

Answer

The flow will send an approval email to the employee.

Answer

The flow will fail because employeeId is missing.

Answer

The flow will send an email to manager@contoso.com.

Question 11

Which TWO actions are valid Power Automate flow actions? (Select TWO.)

Accepted Answer

Create a record (Dataverse). Options B and C are correct. Creating a record is a common action, for example using the Dataverse connector or Microsoft Dataverse (legacy) connector. Sending an email is a standard action via the Office 365 Outlook connector. Option A is incorrect because rebooting a virtual machine is not a native Power Automate action; it would require a custom connector or an Azure resource action. Option D is incorrect because compiling a C# program is not a flow action. Option E is incorrect because designing a database schema is not a flow action.

Answer

Reboot a virtual machine

Answer

Compile a C# program

Answer

Design a database schema

Question 12

A flow uses an approval step to notify managers when a purchase request exceeds $10,000. The approval action times out after 7 days. The business requires that if no response is received within 3 days, the request should be automatically approved. What should be added to the flow?

Accepted Answer

Add a parallel branch that waits for 3 days and then approves if no response. A parallel branch can wait for 3 days, then check if the approval is still pending (not completed), and if so, approve the request. This achieves the requirement of auto-approving if no response within 3 days without altering the original approval timeout.

Option A is incorrect because sending a reminder does not auto-approve; it only sends a notification.

Option B is incorrect because the 'Terminate' action ends the flow entirely and does not approve the request.

Option D is incorrect because the approval action's timeout configuration does not allow an 'Approve' outcome; it only allows rejection or notification on timeout. Additionally, setting the timeout to 3 days would override the original 7-day timeout, which may not be desired.

Answer

Configure the approval to send a reminder after 3 days

Answer

Use a 'Terminate' action after 3 days

Answer

Set the approval timeout to 3 days and configure the outcome to 'Approve'

Question 13

Which TWO of the following are valid trigger types in Power Automate? (Select TWO.)

Accepted Answer

Scheduled. A and C are correct. Scheduled triggers run flows on a schedule (e.g., daily, hourly). Automated triggers run when an event occurs, such as when an email arrives or a file is created. Option B (Recurrence) is an action, not a trigger type. Options D (Manual) and E (Instant) are not trigger types in Power Automate; the correct trigger types are Automated, Scheduled, and Instant (button). However, according to this question, the two correct answers are Scheduled and Automated.

Answer

Recurrence

Answer

Manual

Answer

Instant

Question 14

Refer to the exhibit. A developer created an approval flow using Power Automate. The flow is triggered manually but the approval email never sends. What is the most likely cause?

Accepted Answer

The Office 365 Outlook connection is not configured.. If the Office 365 Outlook connection is not properly configured, the Send_approval_email action cannot authenticate and the email will never be sent. Option B is incorrect because even without an approval action, the flow would still send an email if the connection is valid. Option C is incorrect as a manual trigger does not require a schema. Option D is incorrect because missing approval response options would affect the email content but not prevent it from being sent.

Answer

The flow does not include an approval action; it only sends an email.

Answer

The trigger schema is empty, causing the flow to fail.

Answer

The email body is missing the approval response options.

Question 15

You need to design a Power Automate flow that sends an approval request to a manager when an employee submits a leave request in SharePoint. The flow should check if the manager is on leave and, if so, escalate to the next-level manager. What is the best approach to implement this escalation logic?

Accepted Answer

Use a 'Condition' action to check if the manager is on leave, then if true, send the request to the next-level manager.. A 'Condition' action allows checking manager status and escalating. Option B is wrong because parallel branches do not handle sequential escalation. Option C is wrong because 'Apply to each' is for iterating over a list, not checking a single manager. Option D is wrong because 'Scope' is for grouping actions, not conditional logic.

Answer

Use an 'Apply to each' action to iterate over an array of managers.

Answer

Use a 'Scope' action to group the escalation steps.

Answer

Use parallel branches to send the request to both the manager and next-level manager simultaneously.

Question 16

Which THREE of the following are valid connectors in Power Automate?

Accepted Answer

Microsoft Teams. Options A (Microsoft Teams), D (Dataverse), and E (SharePoint) are valid connectors in Power Automate. Option B (Google Drive) is not a standard built-in connector; it may be available through third-party or premium connectors, but it is not one of the default connectors. Option C (Microsoft Excel) is not a connector; it is a file format that can be used with connectors like Excel Online (Business) or Excel Online (OneDrive), but "Microsoft Excel" itself is not a connector name.

Answer

Google Drive

Answer

Microsoft Excel

Question 17

You need to design a Power Automate flow that triggers when a specific file is added to a SharePoint document library. Which trigger should you use?

Accepted Answer

When a file is created (properties only). 'When a file is created (properties only)' triggers when a new file is added to the library. Option A ('When a file is shared') triggers on sharing actions. Option B ('When a file is modified') triggers on modifications. Option D ('For a selected file') is a manual trigger that requires user input.

Answer

When a file is shared

Answer

When a file is modified

Answer

For a selected file (manual trigger)

Question 18

You create a Power Automate flow that uses AI Builder to process invoices. The flow needs to extract text from PDFs and store it in Dataverse. What is the recommended approach?

Accepted Answer

Use AI Builder's Form Processing model to extract fields and then add a 'Create a new row' action for Dataverse.. AI Builder's Form Processing model is specifically designed to extract fields from structured documents like invoices and then store them in Dataverse. Option B is wrong: Entity Extraction model extracts entities (e.g., names, dates) from unstructured text, but it is not optimized for extracting structured fields from invoice PDFs. Option C is wrong: Object Detection model identifies objects within images, not text regions. Option D is wrong: Text Classification model categorizes text into predefined classes, but does not extract field values from invoices.

Answer

Use AI Builder's Entity Extraction model on the raw PDF text.

Answer

Use AI Builder's Object Detection model to identify text regions.

Answer

Use AI Builder's Text Classification model to categorize invoices.

Question 19

Refer to the exhibit. A Power Automate flow is defined with a manual trigger expecting an email property. When the flow is run, it fails with an error that the email address cannot be empty. What is the most likely cause?

Accepted Answer

The trigger body does not include the 'email' property when invoked.. The error 'email address cannot be empty' occurs when the flow trigger is invoked without the required 'email' property in the trigger body. Option A is incorrect: the email subject not being provided would cause a different error related to missing subject, not an empty email address. Option B is incorrect: the trigger schema is valid because it correctly defines 'email' as a required property; the error is due to the property not being supplied, not an invalid schema. Option D is incorrect: a missing 'To' parameter in the Send_an_email action would cause an error during the action execution, but the flow fails at the trigger stage before the action runs.

Answer

The email subject is not provided.

Answer

The trigger schema is invalid because it requires a property.

Answer

The Send_an_email action is missing the 'To' parameter.

Question 20

A company uses Power Automate to automate approval workflows for expense reports. When an expense report exceeds $5,000, the flow should send an email to the manager and then wait for approval before processing payment. Which type of trigger should be used to start the flow when a new expense report is submitted?

Accepted Answer

When a new item is created trigger. The 'When a new item is created' trigger starts the flow when a new expense report is submitted. Option A is wrong because 'When an item is modified' triggers on updates, not new items. Option B is wrong because a scheduled trigger runs at specified times, not on item creation. Option D is wrong because a manual trigger requires a user to run the flow.

Answer

When an item is modified trigger

Answer

Recurrence trigger

Answer

Manual trigger