PL-900 Demonstrate the capabilities of Power Automate Practice Test 7 — 15 Questions

Question 1

A company is building a Power Automate cloud flow that must run when a new item is added to a SharePoint list and then send an adaptive card to a Microsoft Teams channel. The flow should also log the item's ID to an Azure SQL Database. Which two actions are required to complete the flow? (Choose two.)

Choose an answer to begin — your selection is scored in the full session.

Accepted Answer

Post adaptive card in a chat or channel (Microsoft Teams). The flow requires two actions after the trigger: posting an adaptive card to a Microsoft Teams channel and inserting a row into an Azure SQL Database. The SharePoint trigger provides the item data, so no additional SharePoint action is needed. The Teams action and SQL action directly accomplish the required tasks, making them the correct choices.

Answer

Send an email (Office 365 Outlook)

Answer

Get item (SharePoint)

Answer

When an item is created (SharePoint)

Question 2

A financial analyst needs to create a Power Automate cloud flow that runs when a new invoice is added to a SharePoint list. The flow must convert the invoice amount from USD to EUR using a fixed exchange rate stored in a Microsoft Excel table in OneDrive, and then update the SharePoint item with the converted amount. Which action should the analyst use to retrieve the exchange rate from Excel?

Accepted Answer

List rows present in a table. The 'List rows present in a table' action is the correct choice because it reads data from an Excel table stored in OneDrive or SharePoint. The analyst can configure it to retrieve the row containing the exchange rate, then use that value in an expression to convert the invoice amount. This action integrates seamlessly with other flow steps to update the SharePoint item.

Answer

Get file content

Answer

Extract data from Excel

Answer

Get a row

Question 3

You are building a Power Automate cloud flow that must process a list of 500 customer records retrieved from a Microsoft Dataverse table. For each record, the flow needs to call an external REST API that has a rate limit of 10 requests per second. You want to avoid throttling errors and ensure all records are processed. Which action or configuration should you use?

Accepted Answer

Apply to each with concurrency control turned off and a Delay action of 100 milliseconds inside the loop. To respect a per-second API rate limit, the flow must control the rate at which requests are sent. Disabling concurrency in Apply to each forces sequential processing, and inserting a Delay action between calls ensures the required spacing. This combination prevents exceeding the limit and avoids throttling. Concurrency, parallel branches, or relying solely on retries do not proactively enforce the rate limit and can lead to errors or failed runs.

Answer

Use a parallel branch for each record to maximize throughput

Answer

Apply to each with default settings and enable concurrency control set to 10

Answer

Use the 'Send an HTTP request' action with built-in retry policy set to exponential backoff

Question 4

A retail company wants a Power Automate cloud flow to post a message to a Microsoft Teams channel whenever a new file is uploaded to a specific SharePoint document library. The flow must run only for files in the 'Invoices' folder and must not post for other folders. The flow builder is adding the 'When a file is created (properties only)' trigger. Which configuration should the builder apply to limit the flow to the Invoices folder?

Accepted Answer

Set the trigger's Folder parameter to the Invoices library path and add a trigger condition that checks the folder path.. Scoping the trigger to the Invoices folder and adding a trigger condition on the folder path prevents the flow from starting for files in other folders. This is more efficient than filtering after the trigger because trigger conditions are evaluated before the run is created, so non-matching files do not consume flow runs or actions.

Answer

Use the 'Get file properties' action and check the Path property in a later step.

Answer

Add a Condition action after the trigger that compares the file name to 'Invoices'.

Answer

Enable split-on at the trigger and set the concurrency degree to 1.

Question 5

A logistics company uses a Power Automate cloud flow to process shipping manifests. The flow is triggered when a new file is added to a SharePoint document library, and it must run only on weekdays between 9:00 AM and 5:00 PM. The company wants to avoid processing files outside these hours. What should they configure on the flow?

Accepted Answer

Use the 'Recurrence' trigger with a schedule and then check for new files in the document library.. The 'Recurrence' trigger is designed to run flows on a schedule, which directly supports restricting execution to weekdays between 9:00 AM and 5:00 PM. By combining it with a SharePoint action to fetch new files, the flow can process manifests only during the desired window, avoiding off-hours executions and potential performance issues.

Answer

Configure the flow's recurrence schedule to run only on weekdays between 9:00 AM and 5:00 PM.

Answer

Add a condition action that checks the current day and time before processing.

Answer

Set the flow's trigger to run only during business hours using the trigger's settings.

Question 6

A Power Automate cloud flow uses the 'Start and wait for an approval' action to request manager approval for purchase requests. The maker needs the flow to automatically send a reminder to the approver if no response is received within two days, and then continue once the approval is granted or rejected. What should the maker do?

Accepted Answer

Keep the 'Start and wait for an approval' action, and add a parallel branch that contains a Delay of two days followed by a 'Send an email' reminder, then continue the main branch when the approval completes.. The approval action already waits for a response, so the maker must add a concurrent reminder rather than a sequential delay. A parallel branch with a Delay of two days and a 'Send an email' action delivers the reminder without blocking the main flow. The main branch then proceeds based on the approval outcome, meeting the requirement to continue after approval or rejection.

Answer

Configure the approval action's timeout to two days and enable the 'Send reminder every' option, then handle the outcome using the approval action's outputs.

Answer

Add a Delay action set to two days immediately after the approval action, followed by a Condition action that checks the approval outcome.

Answer

Replace the approval action with a 'Create an approval' action, then add a Delay and a Condition to check the approval status.

Question 7

A financial analyst needs to build a Power Automate cloud flow that runs when a new row is added to a Microsoft Dataverse table named 'Invoices'. The flow must then post an adaptive card to a Microsoft Teams channel and wait for a manager's approval before updating the row status. Which two components are required to accomplish this? (Choose two.)

Accepted Answer

The 'Start and wait for an approval' action from the Approvals connector.. The Dataverse trigger detects the new invoice row and starts the flow, while the approval action sends an adaptive card and pauses execution until the manager responds. Together they satisfy the event detection and approval-waiting requirements. The other actions either create unrelated records, target the wrong service, or represent later steps rather than the core required components.

Answer

The 'Send an HTTP request to SharePoint' action.

Answer

The 'Create a record' action from the Common Data Service (current environment) connector.

Answer

The 'Update a row' action from the Dataverse connector.

Question 8

You are designing a Power Automate cloud flow that must send a Microsoft Teams message and create a Planner task whenever a new high-priority item is added to a SharePoint list. You need to ensure the flow only runs for items where the Priority column equals 'High'. Which TWO actions or configurations should you use to achieve this? (Choose two.)

Accepted Answer

Use the SharePoint trigger 'When an item is created' and set a trigger condition using the expression @equals(triggerOutputs()?['body/Priority'], 'High').. To ensure the flow runs only for new high-priority items, you can either use a trigger condition that evaluates the Priority column before the flow starts, or use a Condition action after the trigger to check the value. Both methods prevent the Teams and Planner actions from executing for non-high-priority items. Trigger conditions are more efficient, while Condition actions provide a visual branch. Using a create-or-modify trigger or redundant actions does not meet the requirement as cleanly.

Answer

Use the SharePoint trigger 'When an item is created or modified' and configure a trigger condition to check the Priority column.

Answer

Use the SharePoint trigger 'When an item is created' and enable concurrency control on the trigger.

Answer

Use the SharePoint trigger 'When an item is created' and add a 'Get item' action to retrieve the Priority, then use a Switch action.

Question 9

A financial services firm uses a Power Automate cloud flow to process loan applications. The flow includes an 'Apply to each' loop that iterates over a large array of applications retrieved from a Microsoft Dataverse table. The firm notices that the flow occasionally fails with a 'Concurrency' error and takes a long time to complete. They want to improve performance and reliability. What should they do?

Accepted Answer

Disable concurrency on the 'Apply to each' action and process items sequentially.. The 'Concurrency' error in an 'Apply to each' loop typically occurs when parallel iterations attempt to access or modify the same resources simultaneously, hitting Dataverse concurrency limits. Disabling concurrency ensures sequential processing, which avoids these conflicts and improves reliability. Although it may take longer, it is the correct approach when data integrity and error reduction are priorities.

Answer

Enable the 'Apply to each' concurrency control and set it to a moderate value, such as 10.

Answer

Use a 'Do until' loop instead of 'Apply to each' to process the applications.

Answer

Increase the concurrency control setting on the 'Apply to each' action to its maximum value.

Question 10

A Power Automate flow uses a 'Manually trigger a flow' trigger that expects a text input named 'customerId'. The maker wants to call this flow from a Power Apps canvas app and pass the customerId value. What must the maker do to make the flow available to the app?

Accepted Answer

Add a 'Respond to a PowerApp or flow' action to the flow and map the customerId input, then add the flow to the app from the Power Apps data sources.. Power Apps calls a flow through the built-in flow connector, which requires the flow to include the 'Respond to a PowerApp or flow' action. That action defines the values returned to the app, and the manual trigger's customerId input becomes a parameter the app can pass. After adding the flow as a data source, the app can invoke it and receive the response.

Answer

Publish the flow as a custom connector and import it into the app's environment.

Answer

Share the flow with the app's users and enable the 'Run only' permission on the flow.

Answer

Change the trigger to 'When an HTTP request is received' and configure the app to call the flow's HTTP endpoint.

Question 11

A company wants to use Power Automate to automate a business process that requires an approval from a specific manager before a purchase order is sent to a supplier. The flow must ensure that only that manager can approve, and if the manager does not respond within 5 days, the flow should escalate to the manager's director. What should the maker configure?

Accepted Answer

Use the 'Start and wait for an approval' action with the 'Approve/Reject - First to respond' type, assign it to the manager, and set a timeout of 5 days. Then add a parallel branch that checks the outcome and, if timed out, sends a new approval to the director.. The approval action assigned to the manager with a 5-day timeout creates a controlled approval step. A parallel branch can inspect the outcome and, when the timeout occurs, initiate a new approval for the director. This design ensures only the manager approves initially and escalation happens automatically after the deadline, matching the business process requirements.

Answer

Create a manual trigger flow that the manager runs to approve the purchase order, and a separate scheduled flow that checks for pending approvals every day.

Answer

Use the 'Start and wait for an approval' action with the 'Approve/Reject - Everyone must approve' type, assign it to the manager and the director, and set a timeout of 5 days.

Answer

Use the 'Send an email with options' action to the manager and configure an Outlook rule to forward the email to the director after 5 days.

Question 12

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?

Accepted Answer

When an item is created - SharePoint. The 'When an item is created - SharePoint' trigger is the correct choice because it initiates the flow automatically whenever a new item (in this case, a new employee record) is added to the specified SharePoint list. This event-driven trigger eliminates the need for manual intervention, making it ideal for automating the welcome email process immediately upon creation.

Answer

For a selected item - SharePoint

Answer

Recurrence

Answer

Start and wait for an approval

Question 13

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?

Accepted Answer

A trigger condition is filtering out some files. Trigger conditions in Power Automate allow you to define expressions that must evaluate to true for the flow to run. If a condition is configured to filter out certain files (e.g., based on file name, metadata, or size), those files will not trigger the flow, and no email will be sent. This is the most likely cause when emails are missing for some files but not all.

Answer

The flow uses a premium connector that requires a license

Answer

The file is being co-authored by multiple users

Answer

The file content contains sensitive information

Question 14

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?

Accepted Answer

Start and wait for an approval. The 'Start and wait for an approval' action is specifically designed to send an approval request via email or the Power Automate mobile app, and it allows recipients to approve or reject directly from the email notification without needing to sign in, using adaptive cards or lightweight approval buttons. This meets the requirement for manager approval without authentication.

Answer

Create a file

Answer

Send an email (V2)

Answer

Send an HTTP request

Question 15

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?

Accepted Answer

The on-premises data gateway is not running or unreachable. The 'GatewayTimeout' error indicates that the flow successfully reached the on-premises data gateway but the gateway did not respond within the expected time frame. This typically occurs when the gateway service is not running, the machine hosting the gateway is offline, or network connectivity between the gateway and the SQL Server is broken. Incorrect credentials or missing tables would produce different errors (e.g., 'Login failed' or 'Invalid object name').

Answer

The SQL login credentials are incorrect

Answer

The SQL table does not exist

Answer

The flow trigger did not fire