Microsoft PL-200 Microsoft Power Platform Functional Consultant Exam Practice Test

Page: 1 / 14
Total 289 questions
Question 1

You are creating a Power Automate cloud flow. The cloud flow will create several SharePoint Online list items based on a variety of conditions.

If any of the dependent SharePoint Online actions fail, you must revert the changes while the automation runs.

You need to design the cloud flow to meet the requirement.

Which two actions should you implement for the design? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.



Answer : B, C


Question 2

A company uses Power Apps.

Users must be able to view only the address1 columns in the Account table.

You need to ensure other address columns are not visible to users when creating views and filters.

What should you do?



Answer : D


Question 3

You plan to create a canvas app.

The app requires a button on the data entry screen that users can select to send an email.

You need to configure the app.

What should you create?



Answer : C


Question 4

A company creates a Power Automate cloud flow for a Power Apps app.

The cloud flow must send a daily email that contains a list of year-to-date (VTD) totals.

You need to configure the flow.

Which feature should you use?



Answer : B

In order to send a daily email that contains a list of year-to-date (YTD) totals, you would need to use a loop in the Power Automate cloud flow. A loop allows you to repeat a specific set of actions until a certain condition is met. In this case, the loop would be used to iterate through the data for each day, accumulating the totals for the year-to-date (YTD) and then sending the email at the end of the loop with the accumulated totals.

Here are some references from Microsoft that may be helpful in understanding how to use loops in Power Automate:

Microsoft docs: Loops in Power Automate

Microsoft docs: Repeating a flow with a loop

Microsoft docs: Using the do-until loop in Power Automate


Question 5

You create a Power Apps app for Microsoft Teams using Microsoft Dataverse for Teams. Users report that they are unable to view the app in Teams. You need to ensure that users can access the app. What should you do?



Answer : C

When you create a Power Apps app for Microsoft Teams using Microsoft Dataverse for Teams, the app needs to be added to the app bar in Teams before it can be accessed by users. This can only be done by a tenant administrator. To ensure that users can access the app, you would need to request that the tenant administrator pin the app to the app bar in Teams.

Sharing the app with a security group by using the Maker portal (A) or in Teams (B) would allow users in that group to access the app, but they would still need to be able to find and open the app.

Here are some references from Microsoft that may be helpful in understanding how to make Power Apps app available in Teams:

Microsoft docs: Add a Power Apps app to a Microsoft Teams channel

Microsoft docs: Pin a Power Apps app to the app bar in Microsoft Teams

Microsoft docs: Distribute Power Apps for Microsoft Teams


Question 6

A company uses a Power Apps app with Microsoft Dataverse.

The company requires the import of records into Dataverse. Duplicate records in the data must be deleted without user intervention.

You create a duplicate detection rule.

You need to configure the rule for the data import.

Which option should you configure?



Answer : D

When configuring a duplicate detection rule in Power Apps with Microsoft Dataverse, to automatically delete duplicate records during a data import, you should enable the 'During data import' option. This option allows the detection rule to automatically delete duplicates as they are imported into the system, without requiring user intervention.


https://docs.microsoft.com/en-us/power-platform/admin/create-duplicate-detection-rule

https://docs.microsoft.com/en-us/power-platform/admin/data-integration-duplicate-detection

Question 7

You need to build a Power Bl dashboard for sales managers to track opportunities.

When a new sale closes that is greater than S1 million, a notification must pop up and an email must be sent to the leadership team.

You need to ensure the email is sent without editing the Microsoft Dataverse.

Which two elements should you configure? Each correct answer is part of the solution.

NOTE: Each correct selection is worth one point.



Answer : A, E

In order to build a Power Bl dashboard for sales managers to track opportunities and send notifications and emails when a new sale closes that is greater than S1 million, you should configure:

A . alerts in Power Bl: You can set up alerts in Power Bl that will trigger when a specific condition is met. For example, you can set an alert to trigger when the value of a specific field in the 'Opportunities' table exceeds $1 million.

E . a Power Automate flow: To send an email to the leadership team when an alert is triggered, you can create a Power Automate flow that is triggered by the Power Bl alert. The flow can then use the 'Send an email' action to send an email to the leadership team with the necessary information about the sale that exceeded $1 million.


https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-alerts

https://docs.microsoft.com/en-us/power-platform/admin/alerts-overview

Page:    1 / 14   
Total 289 questions