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

Question 1

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

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

Accepted Answer

Start and wait for an approval. The two essential actions are 'Start and wait for an approval' to solicit and capture the manager's decision, and 'Update item' to write that decision back to the SharePoint list. These actions together automate the approval workflow from request to record update. Other actions like sending a separate email or creating a new record are not needed because the approval action handles notification and the scenario requires updating an existing item.

Answer

Send an email (V2)

Answer

Get item

Answer

Create a record

Question 2

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

Accepted Answer

Start and wait for an approval. The flow must halt until a human makes a decision and then act on that decision. The 'Start and wait for an approval' action is purpose-built for this: it sends the request through Teams and blocks the run until a response is received, returning an outcome that later conditions can evaluate to route approved or rejected invoices differently.

Answer

Delay until

Answer

Respond to a Power App or flow

Answer

Create an approval

Question 3

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

Accepted Answer

The flow is trying to update a record that is locked by another transaction, such as a plugin or another flow.. Dataverse uses record-level locking to maintain data consistency. When one process, such as a plugin or another flow run, is updating a record, other processes attempting to update the same record may fail with a lock error. To resolve this, you can implement retry policies on the action, reduce concurrency, or coordinate the processes so they do not contend for the same record. The other options describe permission, trigger, or connection issues that would produce different error messages.

Answer

The flow uses a personal connection instead of a service principal, causing session conflicts.

Answer

The flow's connection to Dataverse uses an account without write privileges on the invoice table.

Answer

The Dataverse trigger is misconfigured and is firing multiple times for the same record.

Question 4

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

Accepted Answer

Recurrence. The Recurrence trigger is designed for flows that must run at regular intervals, such as daily, weekly, or monthly. By setting it to repeat every week on Monday at 9:00 AM, the HR manager creates a reliable, unattended reminder. Other triggers are event-driven and depend on external actions like receiving an email or creating a list item, which may not occur on the desired schedule. Recurrence ensures the flow runs regardless of external activity.

Answer

Manually trigger a flow

Answer

When an item is created – SharePoint

Answer

When a new email arrives (V3) – Office 365 Outlook

Question 5

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

Accepted Answer

When a new response is submitted. The Microsoft Forms connector exposes a dedicated trigger that fires on each new response submission. By using it and then calling 'Get response details', the flow can extract the respondent's email address and pass it to an action that adds the user to the Microsoft 365 group, fully automating the workflow.

Answer

When a new email arrives (V3)

Answer

When a form is created

Answer

When a file is created (properties only)

Question 6

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

Accepted Answer

Enable concurrency control on the Apply to each loop and set the degree of parallelism to a value that stays within the API limit, and configure retry policy on the HTTP action.. Throttling from a downstream API is controlled by limiting outbound request rate and gracefully retrying transient failures. Setting concurrency control on the Apply to each loop to a degree that keeps calls under ten per second, combined with a retry policy on the HTTP action, lets the flow process every row while staying inside the API's limits and absorbing occasional 429 responses.

Answer

Add a Terminate action inside the loop that stops the flow when a 429 response is received.

Answer

Replace the Apply to each loop with a single HTTP action that sends all rows in one request.

Answer

Increase the loop's concurrency to the maximum so all rows finish before the peak window ends.

Question 7

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

Accepted Answer

Use a unique identifier from the item as an idempotency key and check it against a Dataverse table or SharePoint list before creating the downstream record.. Duplicate processing occurs when the same source record is delivered to the flow more than once, which can happen with retries or trigger polling behavior. The reliable fix is to make the downstream write idempotent by recording a unique key and checking it before writing. This preserves the existing trigger and prevents duplicate records regardless of how many times the item is seen.

Answer

Configure the trigger's split-on setting to off and set a trigger condition on the item ID.

Answer

Enable concurrency control on the trigger and set the degree of parallelism to 1.

Answer

Add a 'Get item' action and check whether the item already exists before creating the downstream record.

Question 8

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

Accepted Answer

Recurrence. A scheduled flow that runs every weekday at a specific hour requires the Recurrence trigger, which is built into Power Automate and needs no code. Configuring it with a weekly frequency and selecting Monday through Friday produces the desired cadence, while the other triggers are event-driven and cannot enforce a fixed 7:00 AM start.

Answer

Manually trigger a flow

Answer

When a new email arrives

Answer

When an item is created

Question 9

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

Accepted Answer

Use the 'Recurrence' trigger with a frequency of Week and select Monday through Friday.. To run a flow only on weekdays at a set time, the Recurrence trigger with a weekly frequency and Monday through Friday selected is the correct approach. To include the current date, a Compose action with the utcNow() expression, optionally formatted, provides the date dynamically. The other options either add unnecessary steps, use the wrong action for the purpose, or use an unrelated trigger.

Answer

Add a 'Condition' action to check if the current day is a weekday and terminate the flow if not.

Answer

Configure the flow to run on a schedule using the 'When a file is created' trigger.

Answer

Use the 'Convert time zone' action to get the current date and format it for the email.

Question 10

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

Accepted Answer

On-premises data gateway. To connect Power Automate to an on-premises SQL Server, the on-premises data gateway is required. It securely bridges cloud services and on-premises data, supporting connectors like SQL Server. Other gateway types serve different purposes: Azure Virtual Network gateway is for network connectivity, Microsoft 365 gateway does not exist, and Power BI personal gateway is for individual Power BI use, not for Power Automate flows.

Answer

Power BI personal gateway

Answer

Azure Virtual Network gateway

Answer

Microsoft 365 gateway

Question 11

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

Accepted Answer

When an item is modified. To detect a change in the 'Priority' column of a SharePoint list item, the flow must use a trigger that fires on item modification. The 'When an item is modified' trigger is designed for this purpose. It provides the before and after values of the item, allowing a condition to check if the priority changed from 'Normal' to 'High'. Other triggers either fire on creation, deletion, or are for document libraries. Therefore, the correct trigger is 'When an item is modified'.

Answer

When a file is created or modified (properties only)

Answer

When an item is deleted

Answer

When an item is created

Question 12

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

Accepted Answer

Enable concurrency control on the 'Apply to each' action. Concurrency control on the 'Apply to each' action allows multiple iterations to execute at the same time. When line items are independent and the downstream actions can handle parallel calls, enabling concurrency with an appropriate degree of parallelism significantly shortens the flow's overall run time compared to sequential processing.

Answer

Change the trigger to a Recurrence trigger

Answer

Add a 'Delay' action inside the loop

Answer

Use a 'Scope' action around the loop

Question 13

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

Accepted Answer

Set the Recurrence trigger's Interval to 1 and Frequency to Day, then set the trigger's Time zone and add a Condition action that checks whether the current day is a weekday.. A daily Recurrence trigger with interval 1 fires once every day at the configured time. Setting the trigger's Time zone aligns that firing with local time, and a Condition action can filter out Saturday and Sunday. Together these settings deliver a weekday-only 7:00 AM run without external scheduling tools, which directly meets the stated requirement.

Answer

Set the Recurrence trigger's Interval to 5 and Frequency to Day, then set the trigger's Start time to Monday at 7:00 AM.

Answer

Set the Recurrence trigger's Interval to 1 and Frequency to Week, then add a Condition action that checks the day of the week.

Answer

Replace the Recurrence trigger with a 'When a new channel message is added' trigger and filter the channel for weekday posts.

Question 14

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

Accepted Answer

The Dataverse action's required column is not mapped to a dynamic content value from the SharePoint step.. Dataverse enforces required columns at the service layer, so an action that omits a value for a required field is rejected with a validation error even though the column exists in the table. Mapping dynamic content from the preceding SharePoint step supplies the value, resolving the failure without changing the table schema.

Answer

The SharePoint list is in a different environment than the Dataverse table.

Answer

The SharePoint list contains more than 5,000 items, so the flow cannot read the invoice.

Answer

The flow's connection to Dataverse uses an account without a Power Apps license.

Question 15

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

Accepted Answer

The condition is using the 'is greater than' operator, but the invoice amount field is stored as text.. The most likely cause is a data type mismatch in the condition. If the invoice amount is stored as text, the 'is greater than' comparison uses lexicographic ordering, causing incorrect results. For example, '9000' is considered greater than '10000'. Converting the field to a numeric type or using a numeric function in the condition ensures accurate comparison. Other options would cause different symptoms, such as no runs at all or all approvals failing.

Answer

The flow's trigger is set to run only on weekdays, and some invoices are created on weekends.

Answer

The approval action is inside an 'Apply to each' loop that is not iterating over all invoices.

Answer

The approval action is configured to send to a user who is out of office.