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

Question 1

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?

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

Accepted Answer

Add a Condition action to check the expense amount and then use two separate approval actions. Adding a Condition action that checks the expense amount and then branches to two separate approval actions is the simplest, lowest-maintenance way to route based on a threshold. It keeps everything in one flow, uses native controls, and requires no additional flows or complex orchestration. This directly satisfies the requirement with minimal moving parts.

Answer

Use a Scope action to group the approval actions

Answer

Create a child flow that handles the approval routing

Answer

Add parallel branches for each approval path

Question 2

Which TWO capabilities are provided by Power Automate flows?

Accepted Answer

Automate tasks in cloud services like SharePoint and Outlook. Power Automate provides cloud flows that connect to services such as SharePoint and Outlook to automate tasks like triggering a flow when a file is added or sending an email automatically, so option A is correct. It also provides desktop flows (formerly UI flows) through Power Automate Desktop, which use robotic process automation (RPA) to interact with legacy systems that lack APIs, so option D is correct. Option B is not a Power Automate capability because relational database design for analytics is handled by tools like Azure SQL Database, Microsoft Fabric, or Power BI data modeling. Option C is incorrect because managing user permissions in Microsoft Entra ID is done through the Entra admin center, Microsoft Graph, or PowerShell, not Power Automate flows. Option E is incorrect because building custom mobile app user interfaces is the role of Power Apps, not Power Automate.

Answer

Design relational databases for analytics

Answer

Manage user permissions in Microsoft Entra ID

Answer

Build custom user interfaces for mobile apps

Question 3

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?

Accepted Answer

Create an automated cloud flow. An automated cloud flow in Power Automate is triggered by an event — such as 'When a new email arrives' — and runs without user interaction, which is exactly what's needed to save attachments to SharePoint. It uses the Outlook and SharePoint connectors natively. This is the canonical Power Automate pattern for email-driven document routing.

Answer

Create a business process flow

Answer

Create a desktop flow

Answer

Create an approval flow

Question 4

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?

Accepted Answer

Automated cloud flow. An automated cloud flow can use the 'When a new member is added to a team' trigger from Microsoft Teams connector. Instant flows require manual trigger. Scheduled flows run on a schedule. Desktop flows are for desktop automation.

Answer

Desktop flow

Answer

Scheduled cloud flow

Answer

Instant cloud flow

Question 5

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?

Accepted Answer

Scheduled cloud flow. A scheduled cloud flow can run on a recurring schedule (e.g., first day of month) and includes actions to query SharePoint and send email. Automated flows trigger on events, not schedules. Desktop flows are for desktop automation. Business process flows guide users through stages.

Answer

Business process flow

Answer

Desktop flow

Answer

Automated cloud flow

Question 6

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?

Accepted Answer

Automated cloud flow. An automated cloud flow is triggered automatically by an event, such as an item being added to a SharePoint list. This matches the requirement: the flow must start when a new purchase order item is created, evaluate the amount, and conditionally send an approval. Automated flows are the correct type for event-driven, server-side orchestration without user initiation.

Answer

Business process flow

Answer

Instant cloud flow

Answer

Desktop flow

Question 7

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?

Accepted Answer

Instant cloud flow. An instant cloud flow is triggered manually by a user action, such as pressing a button in a mobile app. It runs immediately upon trigger and is ideal for scenarios where the flow should execute on demand, like sending an email with the current location. This matches the requirement exactly.

Answer

Scheduled cloud flow

Answer

Automated cloud flow

Answer

Desktop flow

Question 8

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?

Accepted Answer

Dynamics 365 connector. The Dynamics 365 connector provides a 'When a record is created' trigger. SharePoint, Outlook, and Teams connectors do not trigger on Dynamics 365 leads.

Answer

SharePoint connector

Answer

Outlook connector

Answer

Microsoft Teams connector

Question 9

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?

Accepted Answer

Scheduled cloud flow. A scheduled cloud flow is designed to run on a recurring schedule, such as every hour. It is triggered by a time-based recurrence, not by an event. This matches the requirement to check a SharePoint list hourly and send reminder emails.

Answer

Desktop flow

Answer

Automated cloud flow

Answer

Business process flow

Question 10

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?

Accepted Answer

Check the trigger configuration to ensure the correct library and site are selected. When a flow does not trigger on file creation, the most common cause is a misconfigured trigger — the wrong site address, library name, or folder path selected in the 'When a file is created' trigger. Verifying the trigger configuration is the fastest first diagnostic step because it directly controls whether the flow fires. Other checks (licensing, environment state, target library) are valid but less likely to be the root cause of a non-firing trigger.

Answer

Verify that the flow owner has a valid Power Automate license

Answer

Confirm that the target library exists and is accessible

Answer

Ensure that the environment is not in a disabled state

Question 11

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

Accepted Answer

Trigger: When an item is created (SharePoint); Action: Post message in a chat or channel (Microsoft Teams). The correct trigger must monitor the SharePoint list for new items, and the action must post to a Teams channel. 'When an item is created' is the appropriate SharePoint trigger, and 'Post message in a chat or channel' is the correct Teams action. Other triggers target different event sources, and other actions send emails rather than channel messages.

Answer

Trigger: When a new response is submitted (Microsoft Forms); Action: Post message in a chat or channel (Microsoft Teams)

Answer

Trigger: When a file is created (SharePoint); Action: Post message in a chat or channel (Microsoft Teams)

Answer

Trigger: When an item is created (SharePoint); Action: Send an email (Outlook)

Question 12

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

Accepted Answer

Recurrence. The 'Recurrence' trigger is specifically designed for time-based scheduling, allowing configuration of frequency, time zone, and specific days. It is the only trigger among the options that can run automatically every weekday at a set time. The other triggers are event-driven and would not initiate the flow on a schedule.

Answer

When a new email arrives (Outlook)

Answer

Manually trigger a flow

Answer

When an item is created (SharePoint)

Question 13

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

Accepted Answer

Use the 'When an item is created' trigger for SharePoint, then add a 'Send an email (V2)' action from Outlook.. The 'When an item is created' trigger for SharePoint is designed to start a flow when a new list item is added, which matches the need to detect new shipments. The 'Send an email (V2)' action from Outlook can use dynamic content from the trigger, such as the tracking number and customer email, to compose the message. This ensures timely and accurate notification without manual intervention.

Answer

Use the 'Recurrence' trigger, then add a 'Get items' action for SharePoint and a 'Send an email (V2)' action.

Answer

Use the 'When a file is created' trigger for SharePoint, then add a 'Post message' action for Microsoft Teams.

Answer

Use the 'When an item is modified' trigger for SharePoint, then add a 'Send an email (V2)' action from Outlook.

Question 14

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

Accepted Answer

Enable concurrency control on the 'Apply to each' action and set a degree of parallelism.. Concurrency control on 'Apply to each' allows parallel execution of loop iterations, significantly speeding up processing of large arrays when operations are independent. The other options either do not improve speed or worsen it. Increasing timeout only extends allowed duration, and adding delays slows the flow. Replacing with 'Do until' is not appropriate for iterating a collection.

Answer

Add a 'Delay' action inside the loop to reduce load on the service.

Answer

Replace the 'Apply to each' action with a 'Do until' loop.

Answer

Increase the flow's timeout setting in the flow properties.

Question 15

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

Accepted Answer

When a row is added, modified or deleted (Microsoft Dataverse). Automating a Teams message from a new Dataverse record requires an event-based Dataverse trigger. The 'When a row is added, modified or deleted' trigger with the Added change type listens to the CustomerOrders table and starts the flow the moment a record is inserted, after which a Teams 'Post message' action can publish to the channel without any code.

Answer

When an HTTP request is received

Answer

When a file is created (properties only)

Answer

Recurrence