Courseiva

PL-900 · domain

Demonstrate the capabilities of Power Automate

This domain covers Power Automate's role in the PL-900 exam: identifying trigger types (automated, instant, scheduled), using dynamic content and expressions, and connecting to services like SharePoint, Outlook, SQL Server, and Teams. Questions present flow definitions, JSON triggers, or scenario requirements and ask you to choose the correct trigger, action, or dynamic value.

138 questions47 easy62 medium29 hard

Focused practice

Practice Demonstrate the capabilities of Power Automate questions

Scored sessions drawing only from this domain — pick a length below.

Start 20-question practice test →

What this domain covers

What to know about Demonstrate the capabilities of Power Automate

A candidate must be able to read a flow definition or JSON trigger and identify the exact event that starts the flow, then select the right dynamic content or action for the scenario. The single most important thing is matching the trigger's parameters to the stated condition.

Selecting the correct trigger type (automated, instant, scheduled) for a given business scenario.

Reading flow definitions and JSON trigger schemas to determine what causes a flow to run.

Using dynamic content tokens to reference outputs from previous steps, such as item properties or user fields.

Choosing appropriate connectors and actions for data movement, like SQL Server to SharePoint archiving.

Watch out for

Common Demonstrate the capabilities of Power Automate exam traps

  • ▸Confusing trigger conditions with action filters; candidates pick a condition that belongs in a later step instead of the trigger's own settings.
  • ▸Assuming any email with an attachment triggers the flow, ignoring importance or other trigger parameters shown in the exhibit.
  • ▸Mixing up dynamic content tokens from different steps, such as using 'Created By' when the question asks for the item's title or modifier.

Question index

All Demonstrate the capabilities of Power Automate questions (138)

Click any question to see the full explanation, or start a practice session above.

1

Which TWO actions can be used to implement error handling in a Power Automate flow? (Choose two.)

Medium
2

Which THREE are valid trigger types in Power Automate?

Medium
3

A financial analyst builds a Power Automate cloud flow that runs when a new invoice file is added to a SharePoint document library. The flow must extract the invoice total and vendor name, then write those values into a Dataverse table. The analyst wants to minimize manual configuration and avoid writing parsing expressions. Which action should the analyst use?

Medium
4

A sales team uses a Power Automate cloud flow to process orders. The flow must run every weekday at 9:00 AM to check for new orders in a Microsoft Dataverse table and assign them to a sales representative. Which trigger should you use?

Easy
5

Which TWO actions can be used to add conditional logic in a Power Automate flow?

Medium
6

A financial analyst builds a Power Automate cloud flow that retrieves invoice data from a SharePoint list and must write the total amount into a Dataverse table. During testing, the flow fails at the Dataverse action with an error indicating the required table column was not provided. The analyst sees the column in the Dataverse table. What is the most likely cause?

Medium
7

A company is building a Power Automate cloud flow that must run on a recurring schedule to summarize data and notify a team. The flow owner needs to understand which elements are required for a cloud flow to execute successfully. Which two elements are required for a scheduled cloud flow to run? (Choose two.)

Medium
8

A user wants to create a cloud flow that runs every weekday at 8:00 AM to send a summary email. Which trigger should they use?

Easy
9

You are a business analyst at a manufacturing company. You need to create a flow that automatically saves email attachments from a specific sender to a SharePoint document library. The flow should trigger when a new email arrives in your mailbox. What should you use?

Easy
10

The exhibit shows a trigger definition for a Power Automate flow. What does this trigger do?

Hard
11

A sales team uses a SharePoint Online list named 'Orders' to track customer orders. The team wants an email notification sent automatically whenever a new order is added to the list. They create a cloud flow in Power Automate. Which trigger should they configure to start the flow?

Medium
12

A Power Automate flow uses an 'Apply to each' loop to iterate over a large dataset. The flow is running slowly and sometimes times out. Which approach should the administrator recommend to improve performance?

Hard
13

A user wants to create a flow that automatically copies attachments from incoming Outlook emails to a OneDrive folder. Which trigger and action should be used?

Easy
14

You are designing a Power Automate cloud flow that must run at 8:00 AM every weekday to post a summary message in Microsoft Teams. Which trigger should you configure?

Medium
15

A user is building a Power Automate cloud flow that must run on a schedule every weekday at 8:00 AM and send a summary email. The user needs to ensure the flow only runs on business days and includes the current date in the email. Which two actions or configurations should the user implement? (Choose two.)

Medium
16

A team wants a Power Automate cloud flow to run whenever a new response is submitted in a Microsoft Forms survey. The flow should then add the respondent's email address to a Microsoft 365 group. Which trigger should the flow use?

Medium
17

A small business owner wants to receive a push notification on their phone whenever a new high-priority email arrives in their Microsoft 365 Outlook inbox. They have no coding experience and want the simplest possible solution. What should they do?

Easy
18

A marketing coordinator creates a Power Automate cloud flow that sends a personalized email to each attendee of an event. The coordinator stores attendee names and email addresses in a Microsoft Excel table in OneDrive for Business. After the flow runs, the coordinator discovers the emails were sent to the wrong recipients. The flow uses an 'Apply to each' loop over the Excel rows. What is the most likely cause?

Medium
19

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?

Medium
20

A business analyst at a logistics company wants to create a Power Automate cloud flow that runs every weekday at 7:00 AM to post a summary of yesterday's deliveries to a Microsoft Teams channel. The analyst has no coding experience. Which trigger should they use to start the flow?

Easy
21

A marketing team uses Power Automate to post updates to a Microsoft Teams channel whenever a new item is added to a SharePoint list. The team wants to ensure that the flow can be triggered manually by any team member from the Power Automate mobile app. What should they add to the flow?

Easy
22

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?

Hard
23

Which TWO of the following are valid trigger types in Power Automate?

Easy
24

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

Easy
25

You need to create a Power Automate flow that sends a personalized welcome email to new users when they are added to Microsoft Entra ID. Which trigger should you select?

Easy
26

A Power Automate flow uses a 'When an item is created' trigger on a SharePoint list. After moving the list to a different site, the flow no longer triggers. What is the most likely reason?

Medium
27

A company has a Power Automate flow that uses a premium connector (e.g., SQL Server). Several users report that the flow fails with a '401 Unauthorized' error. The flow uses a service principal for authentication. What is the most likely cause?

Hard
28

A sales team wants to receive a Microsoft Teams message whenever a new high-priority lead is created in Dynamics 365 Sales. They need to build this automation with the least effort. What should they use?

Easy
29

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

Medium
30

A company has a Power Automate cloud flow that processes invoices. The flow uses a condition to check if the invoice amount is greater than $10,000. If true, it sends an approval request to the finance manager. The flow is not sending approval requests for some invoices that exceed $10,000. What is the most likely cause?

Hard
31

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?

Easy
32

A Power Automate flow uses an approval action. The approver can choose 'Approve', 'Reject', or 'Reassign'. The flow needs to send a different email based on the approver's choice. Which action should be used after the approval?

Medium
33

A support team uses a Power Automate cloud flow that runs when a new email arrives in a shared mailbox. The flow occasionally processes the same message twice, creating duplicate Dataverse cases. The maker needs to make the flow idempotent so a given message is handled only once. Which approach should the maker take?

Medium
34

A manufacturing company uses Power Automate to manage equipment maintenance requests. They want to create a flow that, when a new request is added to a SharePoint list, sends an approval to the maintenance manager and, upon approval, updates the request status and notifies the requester via Microsoft Teams. The company needs to ensure the flow handles approvals correctly. Which two actions are required to implement the approval process in this flow? (Choose two.)

Medium
35

Fabrikam Inc. uses Power Automate to automate expense report approvals. The flow is triggered when an expense report is submitted in a SharePoint list. The flow then sends an approval request to the expense approver via the Approvals connector. If approved, the flow updates the SharePoint list status to 'Approved' and sends a confirmation email to the submitter. If rejected, it updates the status to 'Rejected' and sends a rejection email. Currently, the flow works for single approvers, but the business now requires that if the expense amount exceeds $5,000, the approval must be sent to a senior manager instead of the regular manager. You need to modify the flow to meet this requirement with minimal maintenance. What should you do?

Medium
36

A business analyst wants to create a Power Automate flow that runs every Monday at 9 AM to generate a report. Which trigger should they use?

Easy
37

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?

Easy
38

An operations team has a Power Automate cloud flow that reads rows from a Microsoft Dataverse table and, for each row, calls an external REST API that enforces a limit of 10 requests per second. During peak hours the flow hits '429 Too Many Requests' errors and many runs fail. The maker must reduce throttling failures while still processing every row. What should the maker do?

Hard
39

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?

Hard
40

You create a Power Automate flow that runs when a new tweet matches a keyword. What type of trigger does this use?

Easy
41

You have a Power Automate flow that sends a notification to a Teams channel when a high-priority ticket is created in Dynamics 365. The flow works correctly for most tickets, but occasionally a ticket is missed. Upon checking the flow runs, you see that some runs show 'Skipped' status. What is the most likely cause?

Medium
42

A Power Automate flow processes hundreds of items daily. The flow sometimes fails due to service unavailability. Which feature should be used to automatically retry the failed action?

Medium
43

A company uses Power Automate to process incoming invoices. A cloud flow is triggered when a new file is added to a SharePoint document library. The flow must extract the invoice total from the file and store it in a SharePoint list. The file is a PDF. What should you use to extract the total?

Medium
44

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

Medium
45

A company uses Power Automate to process expense reports. The flow must run only on weekdays and must not run more than once per hour. The flow is currently triggered manually. Which trigger should be used to meet these requirements?

Medium
46

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?

Medium
47

A company wants to automate the process of moving files from a local network drive to SharePoint Online. Which Power Automate feature should they use?

Easy
48

A user needs to build a Power Automate cloud flow that reads a SharePoint list item and then uses its values to update a row in an on-premises SQL Server table. The SQL Server is not exposed to the internet. Which component must the user install and configure to enable this connection?

Easy
49

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

Medium
50

A company has a Power Automate flow that processes incoming emails and creates tasks in Microsoft Planner. The flow includes a 'Parse JSON' action to extract information from the email body. The flow has been working correctly, but after a recent update to the email template, the flow fails with a 'BadRequest' error at the 'Parse JSON' action. What is the most likely cause?

Hard
51

A sales team uses a Power Automate cloud flow that creates a new lead in Dynamics 365 whenever a form response is submitted. The flow works, but the team wants to ensure that if the lead creation fails due to a temporary service outage, the flow automatically retries a few times before notifying an administrator. Which configuration should they use?

Medium
52

Which TWO are best practices for designing Power Automate flows in a production environment? (Select TWO.)

Hard
53

A Power Automate cloud flow uses an 'Apply to each' loop to process 5,000 items from a SharePoint list. The flow is taking a long time to complete, and the maker wants to reduce the run duration. The loop contains only a 'Send an email' action that is independent for each item. What should the maker do?

Hard
54

A company uses Power Automate to monitor a SharePoint document library for new files and then copy them to an Azure Blob Storage container. The flow runs successfully for PDF files but fails for large video files. What is the most likely cause?

Medium
55

A company wants to use Power Automate to automate approval processes. Which two actions are available in Power Automate for approvals? (Choose two.)

Medium
56

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?

Hard
57

A finance team uses a Power Automate cloud flow that runs when a new row is added to a Microsoft Dataverse table named 'InvoiceRequests'. The flow must wait for a manager decision before continuing. The manager approves or rejects directly from Microsoft Teams. Which action should the flow use to pause execution until the decision is made?

Medium
58

A company wants to automatically send an email notification when a new file is added to a SharePoint document library. Which type of trigger should be used in Power Automate?

Easy
59

Refer to the exhibit. The flow is scheduled to run daily at 8:00 AM. However, it has not been running for the past week. What is the most likely cause?

Medium
60

A support team wants a Power Automate cloud flow to create a Planner task automatically whenever a new item is added to a SharePoint list named 'SupportRequests'. The flow must use the item's Title as the task title. Which trigger should the maker use to start the flow?

Easy
61

Your organization uses Power Automate to send a welcome email to new employees. The flow is triggered when a new row is added to a Dataverse table named 'NewEmployees'. The flow retrieves the manager's email from a related table and sends an email via Outlook. Managers are reporting that they receive the welcome email but it contains placeholder text instead of the employee's name. The flow runs successfully. What is the most likely cause?

Medium
62

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

Easy
63

Your company uses Power Automate to handle approvals for purchase orders. You need to create a flow that triggers when an item is added to a SharePoint list, checks if the amount exceeds $10,000, and if so, sends an approval request to the finance manager. If approved, the item status should be updated to 'Approved'. Which type of flow should you use?

Hard
64

The exhibit shows an action in a Power Automate flow. What does this action accomplish?

Easy
65

A Power Automate flow runs daily to copy data from a SQL Server database to a SharePoint list. The flow fails with a 'GatewayTimeout' error. What is the most likely cause?

Medium
66

You are designing a Power Automate flow that processes approvals for expense reports. If an expense exceeds $5,000, the flow must require approval from both the manager and the finance director. If the expense is between $1,000 and $5,000, only manager approval is needed. For expenses under $1,000, no approval is required. Which control structures should you use?

Hard
67

Refer to the exhibit. This Power Automate flow is triggered manually via HTTP request. The action 'Send_approval_email' sends an email. What is a potential issue with this flow design?

Hard
68

A user wants to create a flow that runs when a specific button is clicked in a mobile app. Which type of flow should be used?

Easy
69

Which TWO capabilities are provided by Power Automate flows?

Easy
70

You need to design a Power Automate flow that sends a welcome email to a new user immediately after their account is created in Microsoft Entra ID. Which trigger should you use?

Easy
71

You are creating a flow that should run only when a button is pressed in a mobile app. The flow will send an email to a manager with the current location of the user. Which type of flow should you create?

Easy
72

You need to automatically send an email notification when a new file is added to a SharePoint document library. Which trigger should you use in a Power Automate cloud flow?

Easy
73

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?

Easy
74

A financial analyst needs to create a Power Automate cloud flow that runs when a new response is submitted in a Microsoft Forms survey. The flow must then post the respondent's email address and the survey score to a Microsoft Teams channel. Which trigger should the analyst use?

Medium
75

You need to create a flow that runs on the first day of every month and sends a summary email of all new SharePoint list items added in the previous month. The email should be sent to the sales team. Which type of flow should you create?

Medium
76

You need to create a Power Automate flow that runs every Monday at 9 AM to update a SharePoint list. Which trigger should you use?

Easy
77

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

Easy
78

Which THREE components are part of a Power Automate cloud flow?

Hard
79

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?

Easy
80

A Power Automate cloud flow uses the 'Apply to each' action to process a large array of items from a Microsoft Dataverse table. The flow is taking longer than expected, and you need to optimize performance. What should you do?

Hard
81

You need to create a Power Automate flow that sends a daily digest email to the sales team summarizing new leads from the previous day. The flow should run automatically every morning at 8 AM. Which type of trigger should you use?

Easy
82

Which THREE of the following are best practices for creating maintainable Power Automate flows?

Hard
83

A sales team at a manufacturing company wants a Power Automate cloud flow that automatically posts a message to a Microsoft Teams channel whenever a new record is added to a Microsoft Dataverse table named 'CustomerOrders'. The team does not want to write code. Which trigger should they use in the flow?

Easy
84

A Power Automate cloud flow must run every weekday at 7:00 AM local time to post a summary to a Microsoft Teams channel. The flow currently uses a Recurrence trigger. The administrator needs to ensure the flow runs only on Monday through Friday and uses the correct time zone. What should the administrator configure?

Medium
85

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?

Medium
86

A sales team uses a Power Automate flow that creates a contact in Dynamics 365 Sales whenever a new lead is added to a Salesforce system. The flow has been running successfully for months, but recently it started failing with an authentication error. What is the most likely cause?

Easy
87

You need to create a flow that runs every hour to check a SharePoint list for items with a 'Due Date' that has passed and sends a reminder email to the assigned person. Which type of flow should you create?

Easy
88

You are building a flow to automate the process of copying files from one SharePoint document library to another when a file is added. The flow should also send an email notification to a team. You have created the flow, but it is not triggering when a new file is added. What should you check first?

Medium
89

A Power Automate flow uses the 'HTTP' action to call an external API. The flow fails intermittently with a 429 (Too Many Requests) error. What is the best practice to handle this?

Medium
90

A Power Automate cloud flow is configured to use the 'When a file is created (properties only)' trigger for a SharePoint document library. The flow needs to retrieve the file content and send it as an email attachment. Which action should be used to get the file content?

Medium
91

Which TWO actions can be used to implement error handling in a Power Automate flow?

Medium
92

You need to create a flow that sends a push notification to a user's mobile device when a high-priority email arrives in their inbox. Which trigger and action combination should you use?

Easy
93

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?

Medium
94

A company uses Power Automate to send approval emails when a new employee is added to Microsoft Entra ID. The approval flow fails intermittently with a '403 Forbidden' error. What is the most likely cause?

Medium
95

A company uses Power Automate to automate approval processes. They need to create a cloud flow that sends an approval request to a manager when a new item is added to a SharePoint list, and then updates the list item with the approval outcome. Which two actions are required to achieve this? (Choose two.)

Medium
96

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

Easy
97

A Power Automate flow uses the 'Apply to each' action to process items from a SharePoint list. The flow is running slowly. What is the most effective way to improve performance?

Medium
98

A company wants to automatically post a message to a Microsoft Teams channel whenever a new item is added to a SharePoint list named 'ProjectTasks'. The Power Automate flow should include the necessary trigger and action. Which trigger and action combination should you use?

Medium
99

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?

Easy
100

You are reviewing a Power Automate flow definition. The exhibit shows an action definition. What is the action doing?

Medium
101

You are troubleshooting a Power Automate flow that uses an HTTP action to call a REST API. The flow fails with a '429 Too Many Requests' error. The API has a rate limit of 100 requests per minute. Which strategy should you implement to handle this error gracefully?

Hard
102

Your organization uses Power Automate to automate onboarding processes. The flow creates a user in Microsoft Entra ID, assigns licenses, and sends a welcome email. Recently, the flow failed because the 'Create user' action returned 'PrivilegedOperationNotAllowed'. What is the most likely cause?

Hard
103

A healthcare organization uses Power Automate to process patient intake forms. The flow retrieves data from a Microsoft Forms response, creates a record in a Microsoft Dataverse table, and sends a confirmation email. The organization needs to ensure that if the Dataverse record creation fails, the flow retries the operation up to three times before sending an error notification. What should they configure?

Hard
104

A Power Automate maker is building a cloud flow that must read data from an on-premises SQL Server and write results to a SharePoint Online list. The maker needs to understand which components are required to connect to the on-premises data source. Which two components are required? (Choose two.)

Medium
105

You are a business analyst at a logistics company. The operations team uses a Microsoft Excel workbook stored in OneDrive for Business to track daily shipment statuses. They want an email notification sent automatically whenever a shipment's status is updated to 'Delayed' in that workbook. You need to build a Power Automate cloud flow that triggers only on that specific change. Which trigger should you use?

Medium
106

A user wants to create a Power Automate cloud flow that automatically posts a message to a Microsoft Teams channel whenever a new task is added to a Planner plan. Which trigger should the user select to start the flow?

Easy
107

A Power Automate maker builds a flow that processes expense reports. The flow uses a 'When an item is created' trigger on a SharePoint list and then an 'Apply to each' loop over the returned items to call an external HTTP endpoint for currency conversion. The maker notices the flow sometimes processes the same expense twice and occasionally misses items. Which action should the maker take to make the flow reliably process each expense exactly once?

Hard
108

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?

Hard
109

A Power Automate cloud flow is used to process invoices. It uses an 'Apply to each' action to iterate over line items from a SharePoint list. The flow is taking a long time to complete. Which action should you use to run multiple iterations in parallel and reduce the total run time?

Hard
110

A company uses Power Automate to process invoices. A cloud flow is triggered when a new row is added to a Microsoft Dataverse table. The flow must retrieve related customer information from another Dataverse table and then update the invoice row with a calculated risk score. The flow runs but fails at the step that updates the invoice. The error message indicates that the record is currently locked by another process. What is the most likely cause of this failure?

Hard
111

Which TWO actions can be performed using Power Automate? (Select TWO.)

Medium
112

A Power Automate cloud flow is being built to process expense reports. It will use a manual trigger that accepts a file and a text value, call an approval action, and then post the result to Microsoft Teams. Which two features are available for controlling this flow's behavior? (Choose two.)

Hard
113

A user reports that a scheduled flow runs but does not send notifications as expected. The flow is set to run every hour. Which action should the user take first to diagnose the issue?

Easy
114

Refer to the exhibit. You are designing a Power Automate flow that receives an HTTP request with a JSON body. You use the 'Parse JSON' action with the schema shown. The flow fails when the incoming JSON contains an 'items' array with a product object missing the 'quantity' field. What is the best way to fix this?

Easy
115

Which TWO are valid trigger types in Power Automate?

Easy
116

A support team wants a Power Automate cloud flow that, when a new high-priority support ticket is created in a SharePoint list, notifies the on-call engineer in Microsoft Teams and logs the ticket ID to an Excel workbook stored in OneDrive for Business. The team needs the flow to run without user interaction. Which two actions or features does the flow require to meet these requirements? (Choose two.)

Medium
117

Which THREE of the following are features of Power Automate that help manage and monitor flows?

Medium
118

You are a business analyst at a logistics company. The company uses a SharePoint Online list named 'Shipments' to track packages. You need to create a Power Automate cloud flow that automatically sends an email to the customer whenever a new shipment is added to the list. The email must include the shipment's tracking number and the customer's email address. Which trigger and action should you use?

Medium
119

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?

Hard
120

A company uses Power Automate to manage customer support tickets. They want to ensure that when a ticket is escalated, a notification is sent to the support manager. The escalation is indicated by a change in the 'Priority' column of a SharePoint list from 'Normal' to 'High'. Which trigger should they use to detect this change?

Medium
121

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?

Medium
122

A Power Automate flow fails with the error 'GatewayTimeout'. The flow uses an on-premises data gateway to connect to a SQL Server database. What is the most likely cause?

Medium
123

You want to design a Power Automate flow that triggers when a customer submits a support ticket in a Microsoft Dataverse table. Which trigger should you use?

Easy
124

You are building a Power Automate flow that automatically creates a calendar event in Outlook when a customer booking is confirmed in a third-party system. The flow uses a trigger that polls the third-party system every 5 minutes. Which type of trigger is this?

Easy
125

A financial analyst needs to run a Power Automate flow that retrieves data from an on-premises SQL Server and writes it to a SharePoint list. The flow must use a data gateway. Which gateway type should be used?

Medium
126

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?

Medium
127

A company wants to integrate Power Automate with Microsoft Teams so that when a new task is assigned in Planner, a message is posted in a Teams channel. Which connector should be used?

Easy
128

A human resources manager wants to create a Power Automate cloud flow that runs every Monday at 9:00 AM to remind the team about timesheet submission. The flow should not depend on any external event. Which trigger should the manager use?

Easy
129

You are a Power Platform administrator at Contoso Ltd. The company uses a Power Automate flow that monitors a SharePoint list for new items. When a new item is added, the flow retrieves data from an external CRM system via an HTTP request, then updates a second SharePoint list. Recently, the flow has been failing with a '400 Bad Request' error from the HTTP action. The CRM API endpoint and authentication are correct. The flow works for some items but fails for others. You need to identify the root cause and fix the flow. What should you do?

Hard
130

An administrator manages a Power Automate cloud flow that uses the SharePoint 'When an item is created' trigger. The flow occasionally processes the same item twice, creating duplicate records in a downstream system. The administrator wants to prevent duplicate processing without changing the trigger. What should the administrator configure?

Hard
131

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?

Hard
132

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?

Medium
133

Your organization uses Microsoft Teams for collaboration. You want to create a flow that sends a welcome message to a new member when they are added to a specific team. The flow should be triggered automatically without manual intervention. Which type of flow should you create?

Medium
134

A flow uses a 'When an item is created' trigger for a SharePoint list. The flow needs to access the item's title and the user who created it. Which dynamic values should be used?

Medium
135

A user needs to create a Power Automate cloud flow that runs every weekday at 8:00 AM to send a reminder email. Which trigger should the user select?

Easy
136

Refer to the exhibit. The JSON shows a trigger definition for a Power Automate flow. What will cause the flow to trigger?

Medium
137

A help desk analyst receives a high volume of support emails in a shared Outlook 365 mailbox. The analyst needs to automatically create a task in Microsoft Planner whenever an email is flagged with a specific category called 'Escalation'. The analyst has no coding experience and wants to build the automation with minimal effort. What should the analyst use?

Easy
138

Your organization uses Power Automate to integrate with Microsoft 365 services. You need to create a flow that automatically creates a contact in Outlook when a new lead is added to Dynamics 365. The flow should run immediately when the lead is created. Which connector should you use as the trigger?

Medium

Frequently asked questions

What does the Demonstrate the capabilities of Power Automate domain cover on the PL-900 exam?
A candidate must be able to read a flow definition or JSON trigger and identify the exact event that starts the flow, then select the right dynamic content or action for the scenario. The single most important thing is matching the trigger's parameters to the stated condition.
How many questions are in this domain?
This page lists all 138 Demonstrate the capabilities of Power Automate questions in the PL-900 question bank. The actual exam draws from this domain proportionally to its weighting in the official exam blueprint.
What is the best way to practise this domain?
Start with a short focused session (10 questions) to identify gaps, then work through explanations. Repeat with a longer session once the weak areas feel solid.
Can I practise only Demonstrate the capabilities of Power Automate questions?
Yes — the session launcher on this page filters questions to this domain only. Choose any session length for inline explanations and scoring.
pl-900 PL-900 power automate capabilities Practice Questions