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

Question 1

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 2

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

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, use 'Parse JSON' to define the schema of the JSON array returned by the API. Then, use 'Apply to each' to iterate over each object in the array. Inside the loop, use 'Insert row' to create a record in SQL Server for each object. Option A uses 'Filter array', which only filters the array based on a condition, not iterating; it would still need a loop. Option C uses 'Compose' to store the JSON, but does not provide iteration; 'Insert row' directly would only insert the entire JSON object as a single row, not individual records. Option D uses 'Select' to transform the array's shape, but still lacks the iteration step to process each object individually.

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 4

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 5

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 several built-in features for handling errors and exceptions. Option A is correct: a 'Scope' action groups actions, and you can configure error handling on the scope. Options B and E are correct: the 'Configure run after' option (or 'Run after' settings) on an action allows you to define what happens on failure, timeout, or skip, making it a direct error-handling action. Option C is incorrect because enabling a retry policy is a configuration setting on an action, not a distinct error-handling action like Scope or Run after. Option D is incorrect as the 'if' function is an expression, not an action.

Answer

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

Answer

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

Question 6

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 7

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?

Accepted Answer

The user profile in Microsoft Entra ID does not have a manager assigned.. The 'Get manager' action in Power Automate retrieves the manager from the user's profile in Microsoft Entra ID (formerly Azure AD). If the manager is not assigned in the user profile, the flow will fail with the error 'Unable to find the manager for the specified user'. Option B is incorrect because the SharePoint list column for manager is not used by the Get manager action; the flow uses the Microsoft Entra ID profile. Option C is incorrect because the error occurs during the approval process, not due to the trigger condition. Option D is incorrect because permissions on the SharePoint list do not affect the manager lookup, which happens in Microsoft Entra ID.

Answer

The SharePoint list column for manager is missing.

Answer

The flow trigger is set to 'When a new item is created' but the item already exists.

Answer

The SharePoint list does not have the correct permissions.

Question 8

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?

Accepted Answer

The condition branch has two separate 'Send an email' actions that both run for rating 1.. The most likely cause is that the condition branch for 'Yes' (rating less than 3) contains two separate 'Send an email' actions, both of which are triggered when the condition is met. For rating 1, the condition is true, so both email actions execute, sending two emails. This is a common design error where a duplicate action is accidentally added. Option A is incorrect because the Teams action does not send emails. Option C is incorrect because the trigger fires once per submission. Option D is incorrect because the rating is numeric and the condition works correctly for rating 2, so comparison is not the issue.

Answer

The Teams action is configured to also send an email.

Answer

The flow is triggered multiple times due to multiple submissions.

Answer

The rating value is stored as text and the condition incorrectly compares numbers.

Question 9

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?

Accepted Answer

Ensure the Planner bucket and plan are specified correctly in the action.. The error 'Invalid template specification' in the 'Create a task' action typically occurs when the Planner action is not properly configured, specifically the bucket and plan fields are missing or incorrect. Therefore, ensuring that the Planner bucket and plan are specified correctly (Option B) resolves the issue. Option A is incorrect because the error is not related to the Dynamics 365 connection. Option C is incorrect because changing the trigger does not address the template specification error. Option D is incorrect because the error is about task configuration, not permissions.

Answer

Recreate the connection to Dynamics 365.

Answer

Change the trigger to 'When a record is updated' instead of created.

Answer

Grant the flow service principal Planner permissions.

Question 10

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?

Accepted Answer

Check if the flow includes a 'Get file content' action before the email action.. The most common reason for missing attachments in a Power Automate email is that the file content has not been retrieved separately from the SharePoint list item. The 'Send an email (V2)' action does not automatically include attachments from the triggering item. You must use the 'Get file content' action to retrieve the attachment's binary data and then pass it to the email action. Option B is not the first check because the trigger being correct does not guarantee the attachment is retrieved. Option C, while permissions can be a factor, is not the most direct cause—the flow usually has permissions, but the content needs to be explicitly fetched. Option D is incorrect because 'Send an email with options' is for approvals, not a fix for missing attachments.

Answer

Verify that the flow trigger is set to 'When a new item is created'.

Answer

Ensure the SharePoint list has the correct permissions for the flow.

Answer

Change the email action to 'Send an email with options'.

Question 11

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?

Accepted Answer

The flow does not have a 'Respond to a PowerApp or flow' action to send a response.. When a Power Automate flow is triggered by an HTTP request, it must include a 'Respond to a PowerApp or flow' action to send a response back to the caller. If this action is missing, the flow will still run but the HTTP trigger will timeout or return a 500 error because no response is sent. Option A is incorrect because if the flow were disabled, the trigger would not fire and the external application would likely get a 404 or 503, not a 500. Option B is incorrect because the flow runs, meaning the request was received; a payload mismatch would cause a different error (like a 400) or failure within the flow. Option D is incorrect because authentication issues typically return 401 Unauthorized, not 500.

Answer

The flow is disabled or paused.

Answer

The external application is not sending the correct JSON payload.

Answer

The flow requires authentication and the API key is missing.

Question 12

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?

Accepted Answer

The chosen trigger cannot be used in a solution-aware flow.. The 'When a new file is created' trigger for SharePoint is not available in solution-aware flows (it is a non-solution trigger). Option A is wrong because the OneDrive for Business connector is licensed and supported. Option C is wrong because the flow can be saved outside a solution, but the warning indicates that the trigger cannot be used in a solution. Option D is wrong because the warning is informational and does not prevent the flow from running.

Answer

The OneDrive for Business connector is not licensed.

Answer

The flow cannot be saved outside a solution.

Answer

The flow will not run because of this warning.

Question 13

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?

Accepted Answer

Review the trigger condition or filter query.. The flow uses a trigger condition or filter query that may be set to only fire for specific alert severity levels or types. If the filter is misconfigured, critical alerts might be filtered out even though they are generated in Sentinel. Option A is incorrect because the flow runs, so it is enabled. Option B is incorrect because the issue is not about data connector installation; alerts are appearing in Sentinel logs. Option D is incorrect because if the ServiceNow connector were misconfigured, the flow might fail at a later step, but the issue is likely that the trigger is not firing due to the filter.

Answer

Verify that the flow is enabled.

Answer

Ensure that the Sentinel data connector is properly installed.

Answer

Check if the ServiceNow connector is configured with the correct instance.

Question 14

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?

Accepted Answer

The generated schema does not account for all possible fields.. The 'Parse JSON' action uses a schema generated from a sample payload. If the sample did not include optional fields that the webhook sometimes sends, those fields are not defined in the schema, causing the action to fail with 'Invalid JSON'. Option B is incorrect because the flow receives the data before parsing; the issue is with the schema, not timing. Option C is incorrect because the webhook is sending valid JSON—the error occurs only when the JSON contains fields not in the schema. Option D is incorrect because a missing nested object would cause a different error related to missing property, not 'Invalid JSON'.

Answer

The flow is trying to parse the JSON before receiving it.

Answer

The webhook is not sending a valid JSON payload.

Answer

The JSON contains a nested object that is not defined.

Question 15

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

Accepted Answer

Use parallel branches for independent actions.. Options A and D are correct. Using parallel branches for independent actions reduces execution time and improves performance. Using 'Configure Run After' allows the flow to handle failures and retries, improving reliability. Option B is incorrect because running all actions sequentially can increase latency unnecessarily; parallel branches are better for independent actions. Option C is incorrect because 'Apply to each' loops are used for iterating over arrays, but not all list operations benefit from loops; using loops for all operations can degrade performance. Option E is incorrect because adding approval steps to all flows adds overhead and is not related to performance or reliability; approvals are for human interaction and control.

Answer

Set all actions to run sequentially to avoid conflicts.

Answer

Use 'Apply to each' loops for all list operations.

Answer

Add approval steps to all flows for accountability.