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

Question 1

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?

Accepted Answer

The trigger is set to 'When an item is created or modified' and the item is being created and then modified immediately.. The SharePoint trigger 'When an item is created' must be set to trigger only on new items, not on changes. A common misconfiguration is setting the trigger to 'When an item is created or modified', which can cause missed triggers if the item is created and then quickly modified. Option A is incorrect because SharePoint triggers do not require a premium license for basic actions. Option C is incorrect because permissions to the list do not affect the trigger's ability to fire. Option D is incorrect because the delay is unrelated to the trigger configuration.

Answer

The flow requires a premium Power Automate license.

Answer

The user does not have permission to view the SharePoint list.

Answer

The flow has a 'Delay' action before the approval step.

Question 2

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

Accepted Answer

When a user is added to a group. The 'When a user is added to a group' trigger is designed for this scenario. Option B is a trigger for Office 365 users, not Entra ID. Option C is a trigger for Microsoft Entra ID but requires a premium license and is for user modifications. Option D is a trigger for Microsoft Entra ID but is for user deletions.

Answer

When a user is deleted (Microsoft Entra ID)

Answer

When a user is modified (Microsoft Entra ID)

Answer

When a new user is created (Office 365 Users)

Question 3

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?

Accepted Answer

The flow uses 'Send an email' instead of a proper approval action.. The condition checks the status of the 'Send_approval_email' action, but the action only sends the email; it does not wait for the recipient to respond. The status 'Succeeded' simply means the email was sent, not that it was approved. To implement an approval, you should use the 'Start and wait for an approval' action. Option B is incorrect because the condition syntax is correct. Option C is incorrect because the status is correctly referenced. Option D is incorrect because the email address is provided.

Answer

The 'email/To' parameter is missing the recipient's email.

Answer

The condition expression is incorrectly formatted.

Answer

The 'body' function should be 'outputs' instead.

Question 4

A manufacturing company uses Power Automate to monitor equipment sensors. When a temperature sensor exceeds a threshold, a flow sends an alert to the maintenance team. However, duplicate alerts are being sent for the same event. What should the flow developer implement to prevent duplicates?

Accepted Answer

Use a 'When an HTTP request is received' trigger and check for a unique identifier.. Using a 'Cooldown' or 'Debounce' pattern with a variable or a data operation can prevent duplicate triggers. The trigger for HTTP request can receive the same event multiple times if the sensor resends. Option A would delay all alerts, not prevent duplicates. Option B would not prevent duplicates because the trigger fires for each HTTP request. Option D is not a built-in feature and would require custom logic.

Answer

Use the 'Get changes' action for the sensor data.

Answer

Increase the threshold value so alerts are less frequent.

Answer

Add a 'Delay' action of 5 minutes before sending the alert.

Question 5

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?

Accepted Answer

Recurrence. The Recurrence trigger is the correct choice because it initiates a flow on a fixed schedule (e.g., every hour) regardless of any events occurring in SharePoint. This trigger is ideal for polling scenarios where you need to periodically check for new files, as it runs autonomously without requiring an external event.

Answer

Compose

Answer

When an item is created

Answer

Power Apps button

Question 6

Refer to the exhibit. A flow is triggered when an email with 'Invoice' in the subject arrives, and it saves the first attachment to a SharePoint document library. However, the flow fails with an error 'InvalidTemplate'. What is the most likely cause?

Accepted Answer

An email with 'Invoice' in the subject arrives without an attachment.. The trigger includes attachments, but if an email with 'Invoice' in the subject arrives without an attachment, the expression to access the first attachment fails because the attachments array is empty. The error 'InvalidTemplate' occurs when an expression cannot be evaluated. Option A is incorrect because the trigger is configured to include attachments. Option C is incorrect because the folder path is valid. Option D is incorrect because the file name is taken from the attachment, not the subject.

Answer

The SharePoint folder path is incorrect.

Answer

The trigger is not set to include attachments.

Answer

The file name is taken from the email subject instead of the attachment.

Question 7

A 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?

Accepted Answer

Use a SQL Server connector with a 'Recurrence' trigger to query and move data.. Using a SQL Server connector with a recurrence trigger is the appropriate approach for querying a database on a schedule. Option A is event-driven and not scheduled. Option C is for approval, not data movement. Option D is for real-time streaming, not batch processing.

Answer

Use a 'When an item is created' trigger on the SQL table.

Answer

Create an instant flow triggered by a Power Apps button for manual archiving.

Answer

Use a 'When a HTTP request is received' trigger from an external scheduler.

Question 8

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?

Accepted Answer

When a file is created (OneDrive for Business). Option C is correct because the requirement specifies a OneDrive for Business folder, and the 'When a file is created (OneDrive for Business)' trigger is the only one that directly monitors a OneDrive for Business location for new file additions. This trigger uses the OneDrive for Business connector, which is designed to work with the Microsoft Graph API for OneDrive for Business, and it fires specifically when a new file is created, not modified.

Answer

When a file is created (SharePoint)

Answer

When a file is modified (OneDrive for Business)

Answer

When a file is created (OneDrive)

Question 9

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?

Accepted Answer

Use 'Parse JSON' to define the schema, then 'Apply to each' with 'Insert row' inside.. First, parse the JSON to define the schema, then use 'Apply to each' to iterate over the array, and inside the loop use 'Insert row' to create SQL records. Option A is missing the parse step. Option C uses 'Filter array' which is for filtering, not iteration. Option D is missing the loop.

Answer

Use 'Filter array' to select objects, then 'Insert row'.

Answer

Use 'Compose' to store the JSON, then 'Insert row' directly.

Answer

Use 'Select' to transform the array, then 'Insert row' with a batch.

Question 10

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

Accepted Answer

Generating a daily sales report at 8 AM. Scheduled flows are designed to run on a recurring schedule, such as daily or weekly, without requiring a trigger event. Option B requires a daily report to be generated at a fixed time (8 AM), which is a classic scheduled flow use case. Option C requires archiving records every Sunday, another recurring schedule. Both scenarios rely on time-based triggers, not event-driven triggers.

Answer

Sending an approval request when a new expense report is submitted

Answer

Creating a task in Planner when a new email arrives with specific subject

Answer

Posting a message to Teams when a new file is added to SharePoint

Question 11

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

Accepted Answer

Use a 'Scope' action to group actions and configure error handling. Power Automate provides built-in actions for error handling. Option A is a scope action that can have run after settings. Option B is a configuration on actions. Option C is a built-in action. Option D is not an action; it's an expression. Option E is a configuration on actions.

Answer

Enable 'Retry policy' on an action to automatically retry on failure

Answer

Use the 'if' function in expressions to check for errors

Question 12

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

Accepted Answer

SharePoint. SharePoint is a standard connector available in Power Automate with Office 365 licenses, which do not require a premium license. It enables workflows for list item creation, approval processes, and document management without additional per-user costs.

Answer

SQL Server

Answer

Azure Blob Storage

Answer

Salesforce

Question 13

You 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?

Accepted Answer

When a new response is submitted. The 'When a new response is submitted' trigger for Microsoft Forms is the correct trigger. Option B is for when a response is modified. Option C is for viewing responses. Option D is for editing responses.

Answer

When a response is viewed

Answer

When a response is edited

Answer

When a response is modified

Question 14

A company uses Power Automate to process incoming emails. Some emails need to be forwarded to a manager, while others need to be saved to SharePoint. The decision is based on the email subject. Which action should be used to implement the branching logic?

Accepted Answer

Condition. The 'Condition' action allows branching based on expressions. Option A is for iteration. Option B is for switching based on multiple values. Option C is for data transformation. Option D is not a flow action.

Answer

Switch

Answer

Compose

Answer

Select

Answer

Apply to each

Question 15

You are a Power Automate administrator for Contoso Corporation. The company uses Microsoft 365 E5 licenses. The sales team uses a SharePoint Online list named 'Leads' to track potential customers. The list has columns: Title (single line of text), Email (single line of text), Status (choice: New, Contacted, Qualified, Lost), and Score (number). The sales manager wants to automate the following process: When a new lead is added with Status = 'New' and Score > 50, an approval request should be sent to the manager. If approved, the lead Status should be updated to 'Contacted' and an email should be sent to the lead's email address. If rejected, the lead Status should be updated to 'Lost'. Additionally, if the lead is not approved within 7 days, the flow should automatically set Status to 'Lost'. The manager is often on leave, so the flow should also send a reminder to the manager every 2 days if the approval is pending. You need to design the flow using Power Automate. Which of the following designs best meets the requirements?

Accepted Answer

Use a 'When an item is created' trigger with a condition on Score > 50 and Status = 'New'. Inside the condition, use 'Start and wait for an approval' with a 7-day timeout. After approval, update item and send email. For reminders, create a separate scheduled flow that runs every 2 days, queries SharePoint for items with Status = 'New' and approval pending, and sends an email.. Option B correctly uses a recurrence trigger to check for pending approvals and send reminders, and also uses the 'Start and wait for an approval' action which can have a timeout. Option A uses a trigger on item creation but does not handle the 7-day timeout or reminders. Option C uses a manual trigger which is not automated. Option D uses an approval action without timeout and does not handle reminders.

Answer

Use a 'When an item is created' trigger with a condition on Score > 50 and Status = 'New'. Use 'Send an email' to notify the manager and include a link to a Power Apps approval screen. Use a separate flow triggered by an HTTP request from Power Apps to update the item.

Answer

Use a 'When an item is created' trigger with a condition on Score > 50 and Status = 'New'. Inside the condition, use 'Start and wait for an approval' with a 7-day timeout. After approval, update the item and send email. Use 'Parallel branch' to send a reminder every 2 days by adding a 'Delay' action followed by an email.

Answer

Use a 'Recurrence' trigger that runs every hour, queries the SharePoint list for items with Status = 'New' and Score > 50, then sends an approval request. Use a 'Delay until' action to set a 7-day timeout. Use a 'Compose' action to track reminders.