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.
Start practicing
Demonstrate the capabilities of Power Automate — choose a session length
Free · No account required
Domain overview
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.
Exam objectives
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.
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.
Click any question to see the full explanation and answer options, or start a focused practice session above.
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?
2You 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?
3You 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?
4A 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?
5Which 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.)
6A 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?
7You 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?
8Drag and drop the steps to create a Power BI report from a Dataverse table in the correct order.
9You 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?
10A 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?
11You 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?
12Your 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?
13Which TWO scenarios are best suited for using Power Automate scheduled flows?
14You 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?
15A 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?
16You 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?
17Your 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?
18Which TWO actions can you take to improve the performance and reliability of a Power Automate cloud flow? (Choose 2)
19Which TWO triggers are available for Power Automate flows that start from a Dataverse table? (Choose 2)
20Refer 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?
21Refer 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?
22You 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?
23A 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?
24You 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?
25You 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?
26Which TWO actions are valid Power Automate flow actions? (Select TWO.)
27Which TWO are best practices for designing Power Automate flows in a production environment? (Select TWO.)
28A 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?
29A 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?
30A 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?
31A 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?
32A 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?
33A 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?
34You need to create a Power Automate flow that runs every Monday at 9 AM to update a SharePoint list. Which trigger should you use?
35A 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?
36Which TWO actions can be used to add conditional logic in a Power Automate flow?
37Which THREE components are part of a Power Automate cloud flow?
38Which THREE are valid trigger types in Power Automate?
39You 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?
40A 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?
41A 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?
42You 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?
43A user wants to automate sending a welcome email to new users added to Microsoft Entra ID. Which Power Automate trigger should they use?
44You 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?
45A 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?
46You 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?
47Which TWO of the following are valid trigger types in Power Automate?
48Which THREE of the following are features of Power Automate that help manage and monitor flows?
49You are reviewing a Power Automate flow definition. The exhibit shows an action definition. What is the action doing?
50The exhibit shows a trigger definition for a Power Automate flow. What does this trigger do?
51The exhibit shows an action in a Power Automate flow. What does this action accomplish?
52A 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?
53You create a Power Automate flow that runs when a new tweet matches a keyword. What type of trigger does this use?
54A 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?
55You 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?
56A 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?
57You 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?
58Which TWO actions can be used to implement error handling in a Power Automate flow?
59Which TWO are valid trigger types in Power Automate?
60Refer 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?
61Refer 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?
62A 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?
63A 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?
64A 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?
65A company wants to automate the process of moving files from a local network drive to SharePoint Online. Which Power Automate feature should they use?
66Which TWO actions can be performed using Power Automate? (Select TWO.)
67A 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?
68You 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?
69A 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?
70Your 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?
71You 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?
72Which TWO actions can be used to implement error handling in a Power Automate flow? (Choose two.)
73Refer to the exhibit. The JSON shows a trigger definition for a Power Automate flow. What will cause the flow to trigger?
74You 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?
75Your 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?
76A 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?
77You 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?
78A 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?
79Which THREE of the following are best practices for creating maintainable Power Automate flows?
80Fabrikam 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?
81Which TWO capabilities are provided by Power Automate flows?
82You 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?
83Your 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?
84You 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?
85Your 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?
86You 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?
87Your 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?
88You 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?
89You 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?
90A 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?
91A 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?
92You 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?
93A 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?
94A 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?
95A 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?
96A company wants to use Power Automate to automate approval processes. Which two actions are available in Power Automate for approvals? (Choose two.)
97A 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?
98A 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?
99You 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?
100A 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?
101A 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?
102A 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?
103A 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?
104A 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?
105A 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?
106You 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?
107A 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?
108A 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?
109A 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.)
110A 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.)
111A 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?
112A 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?
113A 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?
114A 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?
115An 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?
116An 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?
117A 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?
118A 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.)
119A 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?
120A 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?
121A 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?
122A 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?
123A 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?
124A 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?
125A 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?
126A 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?
127A 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?
128A 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.)
129A 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.)
130A 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?
131A 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?
132A 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.)
133A 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?
134A 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?
135A 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?
136A 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.)
137A 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?
138A 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?
Deep-dive questions
The most-searched questions in this domain — detailed explanations, worked examples, full answer breakdowns.
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.
The Courseiva PL-900 question bank contains 138 questions in the Demonstrate the capabilities of Power Automate domain, covering the 23% of the exam attributed to this domain in the official Microsoft blueprint. Click any question to see the full explanation and answer breakdown.
Start with a 10-question focused session to identify your baseline accuracy in this domain. Read every explanation — even for questions you answer correctly — to understand the reasoning. Once you score consistently above 80%, move to a 20–30 question session to confirm depth before moving to the next domain.
Yes — the session launcher on this page draws questions exclusively from the Demonstrate the capabilities of Power Automate domain. Choose 10, 20, 30, or 50 questions for a focused session, or click individual questions to review them one by one.
Save your results, see per-domain analytics, and get readiness scores — free, for every certification.
Sign Up FreeFree forever · Every certification included