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.
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.
Which TWO actions can be used to implement error handling in a Power Automate flow? (Choose two.)
Medium2Which THREE are valid trigger types in Power Automate?
Medium3A 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?
Medium4A 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?
Easy5Which TWO actions can be used to add conditional logic in a Power Automate flow?
Medium6A 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?
Medium7A 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.)
Medium8A 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?
Easy9You 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?
Easy10The exhibit shows a trigger definition for a Power Automate flow. What does this trigger do?
Hard11A 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?
Medium12A 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?
Hard13A 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?
Easy14You 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?
Medium15A 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.)
Medium16A 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?
Medium17A 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?
Easy18A 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?
Medium19A 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?
Medium20A 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?
Easy21A 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?
Easy22You 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?
Hard23Which TWO of the following are valid trigger types in Power Automate?
Easy24Which TWO triggers are available for Power Automate flows that start from a Dataverse table? (Choose 2)
Easy25You 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?
Easy26A 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?
Medium27A 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?
Hard28A 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?
Easy29Drag and drop the steps to create a Power BI report from a Dataverse table in the correct order.
Medium30A 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?
Hard31You 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?
Easy32A 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?
Medium33A 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?
Medium34A 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.)
Medium35Fabrikam 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?
Medium36A 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?
Easy37A 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?
Easy38An 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?
Hard39You 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?
Hard40You create a Power Automate flow that runs when a new tweet matches a keyword. What type of trigger does this use?
Easy41You 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?
Medium42A 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?
Medium43A 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?
Medium44Which TWO scenarios are best suited for using Power Automate scheduled flows?
Medium45A 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?
Medium46A 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?
Medium47A company wants to automate the process of moving files from a local network drive to SharePoint Online. Which Power Automate feature should they use?
Easy48A 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?
Easy49Which TWO actions can you take to improve the performance and reliability of a Power Automate cloud flow? (Choose 2)
Medium50A 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?
Hard51A 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?
Medium52Which TWO are best practices for designing Power Automate flows in a production environment? (Select TWO.)
Hard53A 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?
Hard54A 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?
Medium55A company wants to use Power Automate to automate approval processes. Which two actions are available in Power Automate for approvals? (Choose two.)
Medium56You 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?
Hard57A 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?
Medium58A 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?
Easy59Refer 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?
Medium60A 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?
Easy61Your 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?
Medium62Which TWO actions are valid Power Automate flow actions? (Select TWO.)
Easy63Your 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?
Hard64The exhibit shows an action in a Power Automate flow. What does this action accomplish?
Easy65A 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?
Medium66You 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?
Hard67Refer 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?
Hard68A 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?
Easy69Which TWO capabilities are provided by Power Automate flows?
Easy70You 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?
Easy71You 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?
Easy72You 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?
Easy73You 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?
Easy74A 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?
Medium75You 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?
Medium76You need to create a Power Automate flow that runs every Monday at 9 AM to update a SharePoint list. Which trigger should you use?
Easy77A user wants to automate sending a welcome email to new users added to Microsoft Entra ID. Which Power Automate trigger should they use?
Easy78Which THREE components are part of a Power Automate cloud flow?
Hard79A 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?
Easy80A 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?
Hard81You 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?
Easy82Which THREE of the following are best practices for creating maintainable Power Automate flows?
Hard83A 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?
Easy84A 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?
Medium85A 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?
Medium86A 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?
Easy87You 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?
Easy88You 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?
Medium89A 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?
Medium90A 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?
Medium91Which TWO actions can be used to implement error handling in a Power Automate flow?
Medium92You 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?
Easy93Your 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?
Medium94A 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?
Medium95A 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.)
Medium96Which 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.)
Easy97A 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?
Medium98A 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?
Medium99You 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?
Easy100You are reviewing a Power Automate flow definition. The exhibit shows an action definition. What is the action doing?
Medium101You 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?
Hard102Your 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?
Hard103A 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?
Hard104A 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.)
Medium105You 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?
Medium106A 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?
Easy107A 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?
Hard108You 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?
Hard109A 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?
Hard110A 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?
Hard111Which TWO actions can be performed using Power Automate? (Select TWO.)
Medium112A 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.)
Hard113A 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?
Easy114Refer 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?
Easy115Which TWO are valid trigger types in Power Automate?
Easy116A 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.)
Medium117Which THREE of the following are features of Power Automate that help manage and monitor flows?
Medium118You 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?
Medium119You 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?
Hard120A 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?
Medium121You 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?
Medium122A 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?
Medium123You 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?
Easy124You 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?
Easy125A 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?
Medium126A 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?
Medium127A 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?
Easy128A 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?
Easy129You 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?
Hard130An 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?
Hard131Your 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?
Hard132Refer 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?
Medium133Your 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?
Medium134A 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?
Medium135A 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?
Easy136Refer to the exhibit. The JSON shows a trigger definition for a Power Automate flow. What will cause the flow to trigger?
Medium137A 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?
Easy138Your 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?
MediumOther domains
All PL-900 exam domains
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.