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

Question 1

A Power Automate flow is triggered when a new file is added to a SharePoint document library. The flow should then copy the file to a different library. However, the flow fails when the file name contains a colon (:). What is the most likely reason?

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

Accepted Answer

The colon character is not allowed in SharePoint file names.. SharePoint file names cannot contain the colon character, so a file with a colon in its name cannot exist in a SharePoint document library in the first place. If the flow is triggered on a new file and then tries to copy it to another library, the copy operation fails because the destination library rejects the invalid character. The colon is one of several reserved characters in SharePoint/OneDrive naming rules.

Answer

The destination library is full.

Answer

The flow is using the wrong connector.

Answer

The flow does not have permissions to read the source library.

Question 2

A company uses Power Automate to automate invoice processing. When a new email with an Excel attachment arrives in a shared mailbox, the flow should parse the attachment and create a record in Dataverse. However, the flow fails intermittently. Upon review, the flow uses the 'When a new email arrives' trigger with the 'Include Attachments' option set to 'No'. What is the most likely cause of the failure?

Accepted Answer

The 'Include Attachments' option is set to 'No', so attachments are not processed.. The 'Include Attachments' option set to 'No' means the flow trigger does not retrieve the Excel attachment, so the subsequent actions cannot parse it. Option B is wrong because the issue is not about premium connectors; the standard 'When a new email arrives' trigger and Dataverse actions work with appropriate licenses. Option C is wrong because the failure is not due to license type; even with correct licensing, the attachment setting prevents processing. Option D is wrong because shared mailboxes are supported for the trigger, but the attachment setting is the root cause.

Answer

The flow requires a premium connector, but only standard connectors are used.

Answer

The user's license does not include Power Automate capabilities.

Answer

The trigger is set to a shared mailbox, which is not supported.

Question 3

Your company has a Power Automate flow that copies files from SharePoint to OneDrive for Business. Recently, some files have not been copied due to permission errors. You need to ensure the flow runs with the appropriate permissions. What should you do?

Accepted Answer

Use a service principal with appropriate permissions and configure the flow to use it.. A service principal (or managed identity) provides a consistent identity with dedicated permissions, ensuring the flow can access both SharePoint and OneDrive without relying on a user's permissions. Option A is incorrect because changing the flow owner does not guarantee that the new owner's permissions match the required access. Option C is incorrect because 'Enhanced mode' is not related to permissions; it affects connector capabilities. Option D is incorrect because running the flow as the triggering user would only use that user's permissions, which may be insufficient and inconsistent.

Answer

Change the flow owner to a user with full permissions to both SharePoint and OneDrive.

Answer

Disable the 'Enhanced mode' in the SharePoint connector.

Answer

Configure the flow to run using the account of the user who triggers it.

Question 4

Your organization uses Power Automate to synchronize data between Salesforce and Dataverse. The flow runs successfully for most records, but some records fail with a 'duplicate record' error in Dataverse. You need to prevent duplicate records from being created. What should you do?

Accepted Answer

Configure duplicate detection rules in Dataverse and use the 'Create a new record' action with duplicate detection enabled.. Configuring duplicate detection rules in Dataverse and using the 'Create a new record' action with duplicate detection enabled will prevent duplicates. Option B is wrong because the 'Compose' action is used to create variables and does not check for duplicates. Option C is wrong because using 'Update a record' requires an existing record; it does not prevent creation of duplicates. Option D is wrong because using 'Delete a record' before creating a new one is not a standard method to handle duplicate detection and may cause data loss.

Answer

Use the 'Compose' action to check for duplicates before creation.

Answer

Use the 'Update a record' action instead of 'Create a new record' to update existing records.

Answer

Use the 'Delete a record' action before creating a new one.

Question 5

You need to design a Power Automate cloud flow that processes incoming emails and creates tasks in Microsoft To Do. The flow should only run for emails from specific senders. Which TWO actions should you use?

Accepted Answer

Condition. Option B (Condition) is correct because a Condition action lets the flow evaluate each incoming email's sender address and branch only when it matches the specified senders, ensuring the flow's task-creation logic runs exclusively for those emails. Option E (Create a task) is correct because the Microsoft To Do connector's 'Create a task' action is the operation that actually creates the task in To Do once the sender filter has been satisfied. The Compose action (A) only stores or transforms data and cannot filter senders or create tasks, 'Send an email' (C) is an output action that sends mail rather than creating To Do tasks, and 'Apply to each' (D) is a looping construct for iterating over collections, not a filtering or task-creation action.

Answer

Compose

Answer

Send an email

Answer

Apply to each

Question 6

Which THREE of the following are valid connectors in Power Automate?

Accepted Answer

Microsoft Teams. Options A (Microsoft Teams), D (Dataverse), and E (SharePoint) are valid connectors in Power Automate. Option B (Google Drive) is not a standard built-in connector; it may be available through third-party or premium connectors, but it is not one of the default connectors. Option C (Microsoft Excel) is not a connector; it is a file format that can be used with connectors like Excel Online (Business) or Excel Online (OneDrive), but "Microsoft Excel" itself is not a connector name.

Answer

Google Drive

Answer

Microsoft Excel

Question 7

You need to design a Power Automate flow that triggers when a specific file is added to a SharePoint document library. Which trigger should you use?

Accepted Answer

When a file is created (properties only). 'When a file is created (properties only)' triggers when a new file is added to the library. Option A ('When a file is shared') triggers on sharing actions. Option B ('When a file is modified') triggers on modifications. Option D ('For a selected file') is a manual trigger that requires user input.

Answer

When a file is shared

Answer

When a file is modified

Answer

For a selected file (manual trigger)

Question 8

A Power Automate flow sends an email to a manager when a leave request is submitted in Microsoft Forms. The flow frequently fails because the manager's mailbox is full. Which approach best handles this error?

Accepted Answer

Configure the email action's 'Run after' settings to retry on failure and then escalate to a secondary manager.. Configuring the email action's 'Run after' settings to retry on failure and then escalate to a secondary manager is the best practice. This handles the transient error (full mailbox) by retrying, and if it still fails, it escalates to a secondary manager, ensuring the notification is delivered. Option A is wrong because terminating on error does not handle the full mailbox scenario. Option B is wrong because it only alerts an admin but does not resolve the need to notify the manager. Option D is impractical as Power Automate cannot easily check mailbox size before sending.

Answer

Configure the flow to terminate on error.

Answer

Use a 'Send an email (V2)' action with 'Error handling' to send a notification to the admin.

Answer

Add a condition to check mailbox size before sending.

Question 9

A Power Automate flow processes sensitive employee data and must be run only by HR managers. Which is the best way to restrict access?

Accepted Answer

Share the flow only with HR managers and set their permissions to 'Owner'.. Sharing the flow only with HR managers and assigning them the 'Owner' permission is the best way to restrict who can run it, because flow-level sharing controls exactly which users can access and execute that specific flow. Owners can edit and run the flow, while other users in the environment are excluded entirely. This directly satisfies the requirement that only HR managers run the flow without affecting unrelated flows or users.

Answer

Create a separate environment for HR flows.

Answer

Use a Data Loss Prevention (DLP) policy to block non-HR users.

Answer

Disable sharing for all flows in the environment.

Question 10

Which THREE components are required to create an automated approval process using Power Automate and Microsoft Teams?

Accepted Answer

A 'Start and wait for an approval' action. Option A is correct because the 'Start and wait for an approval' action is the core Power Automate approval connector action that creates the approval request and pauses the flow until the approver responds, which is essential for any automated approval process. Option C is correct because an automated flow must begin with a trigger, and 'When a new response is submitted' from Microsoft Forms is a valid automated trigger that initiates the approval workflow when a user submits a form. Option E is correct because the 'Post a message in a chat or channel' action (Microsoft Teams connector) notifies the approver in Teams, which is required to make the approval process work with Microsoft Teams as specified in the scenario. Option B is not required because a manual button trigger would make the flow manual rather than automated, contradicting the requirement for an automated approval process. Option D is not required because a SharePoint list for storing approval history is optional logging, not a mandatory component for creating the approval process itself.

Answer

A manual button to start the flow

Answer

A SharePoint list to store approval history

Question 11

Refer to the exhibit. The Power Automate flow trigger is configured to run when a new email arrives. What will trigger this flow?

Accepted Answer

Emails with 'Invoice' in the subject line. The trigger condition 'subjectFilter' is set to 'Invoice', meaning only emails with 'Invoice' in the subject line will trigger the flow. Option A is incorrect because 'includeAttachments' is set to false, so attachments are not required. Option C is incorrect because 'importance' is set to 'Any', so importance is not a filter. Option D is incorrect because the flow requires a specific subject filter, not any email.

Answer

Any email with an attachment

Answer

Emails marked as high importance

Answer

Any email with or without attachments

Question 12

A company uses Power Automate to automate invoice processing. The flow must send an email with the invoice PDF as an attachment to the manager for approval. However, the approval step is failing with an error. What is the most likely cause?

Accepted Answer

The flow does not include the 'Attachments' parameter in the 'Start and wait for an approval' action.. The 'Start and wait for an approval' action in Power Automate only sends attachments if you explicitly populate the 'Attachments' parameter with an array of attachment objects (name and content). If the flow author omits this parameter, the approval request is sent without the PDF, and any downstream logic expecting the file fails.

Answer

The flow is not using a premium license for the approval action.

Answer

The file size exceeds the 10 MB limit for Power Automate attachments.

Answer

The SharePoint connector cannot access PDF files.

Question 13

A Power Automate flow triggers when a new item is added to a SharePoint list. The flow uses a 'Send an HTTP request to SharePoint' action to update a related item in another list. The flow runs but the update does not occur. What is the most likely cause?

Accepted Answer

The site address in the HTTP request is incorrect.. The 'Send an HTTP request to SharePoint' action requires a valid site URL and API endpoint to target the correct list. If the site address is incorrect, the flow will run without error but the request will hit the wrong site or fail silently, so the target list item is never updated. This is the most likely cause when the flow completes but the expected change does not appear.

Answer

The HTTP request action is not available in Power Automate.

Answer

The flow does not have permission to access the target list.

Answer

The HTTP request action cannot update SharePoint list items.

Question 14

A company has a Power Automate flow that posts a message to Microsoft Teams when a new lead is created in Dynamics 365. The flow uses the 'Post a message' action. Some users report they do not receive the message in Teams. What should the administrator check first?

Accepted Answer

Review the Teams connector connection status and permissions.. The Teams connector requires proper authentication and permissions; if the connection is broken or insufficient, messages will fail to post. Option A is incorrect because the 'Post a message' action configuration is not the first thing to check; the trigger and connection status are more fundamental. Option C is incorrect because the flow triggering on new lead creation is a separate issue from the Teams connector itself. Option D is incorrect because Teams notification settings are per-user and not the primary cause of the flow not sending messages.

Answer

Verify that the 'Post a message' action is correctly configured.

Answer

Confirm the flow is triggered by new lead creation.

Answer

Check the Teams notification settings for each user.

Question 15

A Power Automate flow uses the 'Apply to each' control to process a list of items. The flow runs but only processes the first 10 items. What is the most likely reason?

Accepted Answer

The flow has a 'Terminate' action after the 10th item.. The most likely reason the flow processes only the first 10 items is that a 'Terminate' action was placed after the 10th item, which stops the flow run entirely. The 'Apply to each' control does not have a default limit of 10 items, and concurrency settings affect parallel execution, not the total number of items processed. A 'Terminate' action explicitly ends the flow, so any items after the 10th are never processed.

Answer

The 'Apply to each' control only processes the first 10 items by default.

Answer

The list contains exactly 10 items.

Answer

The 'Apply to each' has a concurrency setting limiting the number of items processed.