Exam PL-200: Microsoft Power Platform Functional Consultant Practice Test
PL-200 practice covers configuring Microsoft Power Platform solutions to meet business requirements. The available question bank uses scenarios involving Power Automate cloud flows, canvas apps, Power Fx, and Dataverse. These examples focus on selecting controls, expressions, table features, and access settings to implement common business processes and user experiences.
Exam overview
About the Exam PL-200: Microsoft Power Platform Functional Consultant Exam
Functional consulting work connects process requirements with maintainable app and data designs. In Dataverse, that can involve choosing column types, defining alternate keys, and applying column-level security to protect sensitive values. Canvas app tasks call for selecting controls and properties, using Power Fx variables and formulas, and publishing changes so users can access the updated app. Flow scenarios involve retrieving records that meet criteria, branching on conditions, and pausing for approval before sending a message or continuing a process. The practical decisions are about matching each requirement to the right platform capability, keeping calculations current, and controlling when data is read or changed. Use these topics to practice explaining why a feature fits a particular requirement, rather than memorizing isolated action names.
Sample Practice Questions
Review a selection from this exam's published US Practice Tests practice bank.
A cloud flow must branch into different actions depending on whether a condition evaluates to true or false. Which control should the maker use?
Show answer
Correct answer: AA Condition control evaluates a logical test and directs the flow through a yes or no branch based on the result.
A canvas app must let a user choose a date and prevent selection of dates before today. Which control property is designed to establish the earliest selectable date?
Show answer
Correct answer: CThe date picker’s MinDate property sets the earliest date a user can select. DefaultDate supplies an initial value, while OnChange defines behavior after a value changes.
A flow should send an email only after a human has reviewed a request and selected an outcome. Which Power Automate capability is designed to pause the flow for that decision?
Show answer
Correct answer: AApproval actions create a review request and provide an outcome that the flow can use to determine subsequent processing. A delay only waits for a duration and does not collect a human decision.
A cloud flow needs to retrieve Dataverse rows that match specified criteria before acting on them. Which action is generally used to query a table for matching rows?
Show answer
Correct answer: AThe Dataverse List rows action retrieves rows from a table and supports query criteria, allowing a flow to work with records that match the specified conditions.
A maker needs a Dataverse table to calculate a value from other columns in the same row and keep the result updated automatically. Which column type is intended for this purpose?
Show answer
Correct answer: AA formula column calculates its value from an expression involving other data, reducing the need to store and manually maintain a derived value.
A canvas app needs to show a total that updates as a user changes values in several input controls. Which Power Fx approach is appropriate for displaying the calculated total?
Show answer
Correct answer: AA label property can use a Power Fx formula to calculate and display a value from current control values, updating as those values change. A flow or Dataverse rule is not needed for this immediate, screen-level calculation.
A maker wants a Dataverse table to identify a row using a business identifier, such as an externally assigned account code, in addition to the system row ID. What should the maker configure?
Show answer
Correct answer: AAn alternate key uses one or more columns as a unique business identifier for a row and can support integrations that identify records by that value. Views, process flows, and charts do not establish an alternate unique identifier.
How to use this practice test
Access is free. A practice session presents up to 20 randomly selected questions from the available PL-200 bank, with results shown after the session. Use missed or uncertain answers to identify which platform feature or configuration choice needs closer review.
Preparation tips
- For flow scenarios, distinguish condition branching, record retrieval, and approval steps; map each requirement to the corresponding Power Automate control or action.
- Practice choosing between Dataverse calculated columns and app-side Power Fx formulas based on where a value must be maintained or displayed.
- Build canvas app examples using date-control properties, global variables, and formulas that recalculate when users change input values.
- Review how alternate keys identify rows using business identifiers and how column-level security limits access to sensitive Dataverse data.
- After editing a canvas app, include saving and publishing in your deployment steps so users receive the updated version.