Demonstrate the capabilities of Power Automate

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?

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?

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?

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?

You need to design a Power Automate flow that processes orders from a CSV file in SharePoint. The flow should read each row and create a record in a SQL database. If a row contains invalid data, the flow should continue with the next row. Which configuration should you use?

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

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?

You review a failed flow run with the log shown. The flow is supposed to send an email when a SharePoint item is created. What is the most likely issue?

You are a Power Platform administrator for a large enterprise. You have created a Power Automate cloud flow that sends an approval email to the manager whenever a new employee is added to the HR system. The flow uses a SharePoint list as the trigger and a Common Data Service (CDS) connector to update the employee record. Recently, the flow has been failing intermittently with the error: 'The request failed due to a network error. The server returned an error: GatewayTimeout'. You check the flow run history and see that the error occurs on the CDS update action. The SharePoint trigger and approval actions complete successfully. The flow runs with a concurrency setting of 10. The CDS environment is in another region. You need to resolve the timeout issue. What should you do?

Which TWO scenarios are suitable for using a scheduled cloud flow in Power Automate?

Refer to the exhibit. The flow fails to send the email. What is the most likely cause?

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?

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

Match each Power Apps license type to its description.

Your organization uses Power Automate to automate approval workflows in SharePoint. When a user creates a new item in a SharePoint list, an approval request should be sent to their manager. However, some approvals are not being triggered. What is the most likely cause?

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

Refer to the exhibit. You have a Power Automate flow that sends an approval email and then checks if the email was sent successfully. If successful, it updates a SharePoint item status to 'Approved'. Otherwise, it sends a rejection email. However, the flow always updates the SharePoint item to 'Approved' even when the approval email fails. What is the likely issue?

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?

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?

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?

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

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

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

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?

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?

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

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

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

You are creating a Power Automate flow to copy files from a SharePoint document library to a OneDrive for Business folder. The flow triggers when a new file is created in SharePoint. After saving the flow, you get a warning that the flow uses a trigger that is not supported in the 'Solutions' context. What does this mean?

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?

A Power Automate flow uses the 'Parse JSON' action to process incoming webhook data. The flow fails with the error 'Invalid JSON' when the webhook sends data. You review the sample payload used to generate the schema and notice the webhook sometimes includes additional optional fields. What is the most likely cause?

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

Which THREE Power Automate features are available only in premium licenses? (Choose 3)

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

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?

Refer to the exhibit. A Power Automate flow definition is shown. The flow is triggered by an HTTP request with a 'score' property. When the score is greater than 0.8, it sends an approval email to the manager. Otherwise, it logs the score to a SharePoint list. The flow runs but when a score of 0.9 is submitted, no email is sent and the SharePoint log is created. What is the most likely cause?

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?

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?

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?

Refer to the exhibit. The JSON snippet shows a Power Automate action definition. Which action is this?

A Power Automate flow runs on a schedule and exports data from Microsoft Dataverse to a CSV file in SharePoint. Recently, the flow has been taking longer than expected and sometimes times out. Which approach should you take to improve performance?

Your organization uses Power Automate to automate approval workflows for purchase orders. The compliance team requires that all approvals be auditable and that the flow logs include the identity of the user who initiated the approval. Which feature should you use?

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?

A Power Automate flow that processes incoming emails and creates tasks in Microsoft To Do is not triggering for some emails. The flow uses the 'When a new email arrives' trigger with a filter on the subject containing 'Task'. What is the most likely reason some emails are missed?

Which THREE are valid trigger types in Power Automate? (Select THREE.)

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

Which THREE components are part of a Power Automate cloud flow? (Select THREE.)

Which TWO are valid ways to share a Power Automate flow? (Select TWO.)

Which THREE are valid connectors in Power Automate? (Select THREE.)

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?

A sales team uses Power Automate to create a lead in Dynamics 365 Sales when a new row is added to a Google Sheets spreadsheet. The flow fails with a 'Forbidden' error. What is the most likely cause?

An organization has a Power Automate flow that runs on a schedule and processes sensitive data. The compliance team requires that the flow cannot be triggered manually and must use a managed identity for authentication. Which feature should be used to meet these requirements?

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?

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?

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?

Which THREE of the following are valid ways to handle errors in a Power Automate flow? (Select THREE.)

Which TWO of the following are types of connectors available in Power Automate? (Select TWO.)

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?

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?

A company uses Power Automate to automate approval workflows. An employee reports that an approval request sent to their manager is not being delivered. The manager is listed in Microsoft Entra ID with the correct email address. What is the most likely cause?

A Power Automate flow processes incoming emails from a shared mailbox. Recently, some emails are being missed. You suspect the flow is hitting a service protection limit. Which action should you take to diagnose the issue?

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?

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?

You have a Power Automate flow that copies files from OneDrive for Business to a SharePoint document library. The flow runs successfully but the files are not appearing in SharePoint. What should you check first?

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

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

Which THREE are valid trigger types in Power Automate?

Refer to the exhibit. A Power Automate flow is triggered when an item is created in a SharePoint list. However, the flow runs for every new item, even those with Status other than 'New'. What is the issue?

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?

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?

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?

You want to automate a business process that requires human interaction for approval. Which type of Power Automate flow should you use?

A Power Automate flow is triggered when a new file is added to a SharePoint document library. The flow should then copy the file to a different library. However, the flow fails when the file name contains a colon (:). What is the most likely reason?

A company uses Power Automate to automate invoice processing. When a new email with an Excel attachment arrives in a shared mailbox, the flow should parse the attachment and create a record in Dataverse. However, the flow fails intermittently. Upon review, the flow uses the 'When a new email arrives' trigger with the 'Include Attachments' option set to 'No'. What is the most likely cause of the failure?

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

Your company has a Power Automate flow that copies files from SharePoint to OneDrive for Business. Recently, some files have not been copied due to permission errors. You need to ensure the flow runs with the appropriate permissions. What should you do?

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?

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?

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?

Your organization uses Power Automate to synchronize data between Salesforce and Dataverse. The flow runs successfully for most records, but some records fail with a 'duplicate record' error in Dataverse. You need to prevent duplicate records from being created. What should you do?

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

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

You need to design a Power Automate cloud flow that processes incoming emails and creates tasks in Microsoft To Do. The flow should only run for emails from specific senders. Which TWO actions should you use?

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

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

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

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?

A Power Automate flow sends an email to a manager when a leave request is submitted in Microsoft Forms. The flow frequently fails because the manager's mailbox is full. Which approach best handles this error?

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

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?

A Power Automate flow processes sensitive employee data and must be run only by HR managers. Which is the best way to restrict access?

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?

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?

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

Which THREE components are required to create an automated approval process using Power Automate and Microsoft Teams?

Which TWO are valid trigger types in Power Automate?

Refer to the exhibit. The Power Automate flow trigger is configured to run when a new email arrives. What will trigger this flow?

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?

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?

A company uses Power Automate to automate invoice processing. The flow must send an email with the invoice PDF as an attachment to the manager for approval. However, the approval step is failing with an error. What is the most likely cause?

A Power Automate flow triggers when a new item is added to a SharePoint list. The flow uses a 'Send an HTTP request to SharePoint' action to update a related item in another list. The flow runs but the update does not occur. What is the most likely cause?

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?

A company has a Power Automate flow that posts a message to Microsoft Teams when a new lead is created in Dynamics 365. The flow uses the 'Post a message' action. Some users report they do not receive the message in Teams. What should the administrator check first?

A Power Automate flow uses the 'Apply to each' control to process a list of items. The flow runs but only processes the first 10 items. What is the most likely reason?

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?

A user wants to create a flow that automatically sends a thank-you email when a customer fills out a Microsoft Forms survey. Which trigger should the user select?

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?

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?

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

Which THREE conditions are required for a Power Automate flow to use the 'When an email arrives' trigger for a shared mailbox? (Select THREE.)

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

Refer to the exhibit. A Power Automate flow uses the 'When a new email arrives' trigger with a filter for emails that have attachments. The trigger sometimes fires even when the incoming email has no attachment. What is the most likely reason?

Refer to the exhibit. A Power Automate flow triggers when an item is created in a SharePoint list. The flow does not trigger for items created immediately after the flow is enabled. What is the most likely cause?

You are troubleshooting a Power Automate flow that uses the 'Send an email' action. The flow runs successfully, but recipients report not receiving the email. What is the most likely cause?

A Power Automate flow is designed to copy files from OneDrive for Business to a SharePoint document library. Some files fail to copy because the file name contains special characters. Which action should be added to the flow to handle this?

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?

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?

A Power Automate flow that sends approval requests is being used by multiple teams. The flow uses the 'Start and wait for an approval' action. The approver reports that they are not receiving the approval request email. What should you check first?

You are designing a Power Automate flow that processes orders. The flow must wait for a manager's approval if the order amount exceeds $10,000. If the approval is rejected, the flow should notify the salesperson and stop processing. Which actions should be used?

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

Which THREE are valid connectors in Power Automate? (Choose three.)

Which TWO of the following are types of triggers available in Power Automate? (Choose two.)

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

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?

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?

You are designing a Power Automate flow that processes sensitive employee data from Dataverse. The flow must run in a secure environment and be triggered by changes to a table that supports auditing. The company policy requires that all flows handling sensitive data use managed identities for authentication and execute within a dedicated environment with data loss prevention (DLP) policies applied. Which combination of features should you use?

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?

You need to create a flow that automates the onboarding process for new employees. When a new employee record is added to a Human Resources (HR) system in Dataverse, the flow should: (1) send a welcome email, (2) create user accounts in Microsoft Entra ID, and (3) assign licenses. The flow must run with high reliability and should not fail if one of the actions fails. Which flow design pattern should you use?

A company uses Power Automate to send push notifications to mobile devices via the Microsoft Power Platform notification action. The flow is triggered when a high-priority support ticket is created in Dynamics 365. Recently, some users reported not receiving notifications. The flow runs successfully without errors. What is the most likely cause of the issue?

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?

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?

A marketing team uses a Power Automate flow that posts a message to Microsoft Teams when a new lead is added to a SharePoint list. The flow runs successfully, but the message is not appearing in the expected Teams channel. What is the first thing you should check?

Which TWO of the following are valid trigger types that can start a Power Automate flow?

Which TWO of the following are capabilities of Power Automate that help with monitoring and troubleshooting flows?

Contoso Ltd. has a Power Automate flow that runs daily at 8:00 AM to synchronize customer data from an on-premises SQL Server database to Dataverse. The flow uses an on-premises data gateway to connect to the SQL Server. Recently, the flow started failing with the error: 'Unable to connect to the gateway. The gateway is offline.' The IT administrator confirms that the gateway service is running on the on-premises server, and the server has internet connectivity. You need to resolve the issue. What should you do?

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?

A non-profit organization uses Power Automate to automatically send thank-you emails to donors after they make a donation through a third-party payment gateway. The flow is triggered when a new row is added to a Dataverse table named 'Donations'. The flow then uses the 'Send an email (V2)' action to send the email. The flow has been working for months, but today donors started complaining that they are not receiving the thank-you emails. The flow run history shows that the flow runs successfully and the 'Send an email' action shows 'Succeeded'. What is the most likely cause of the issue?

Which TWO capabilities are provided by Power Automate flows?

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?

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?

You are a Power Automate administrator. A user reports that a cloud flow stopped working after you updated the environment's data loss prevention (DLP) policy. The flow uses the SharePoint and Outlook connectors. The new DLP policy only allows these connectors in the 'Business' group, but the flow was previously working. What is the most likely cause of the failure?

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?

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?

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?

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?

You have a Power Automate flow that uses a Dataverse connector to update a record when an approval is completed. The flow previously worked but now fails with an error 'Connection not found'. You verify that the connection to Dataverse still exists and the user has appropriate permissions. What is the most likely cause?

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?

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?