PL-200: Microsoft Power Platform Functional Consultant – Renewal Practice Questions with Answers

0
2

Microsoft Power Platform Functional Consultant Renewal Practice Questions with Answers

Preparing for the Microsoft Certified: Power Platform Functional Consultant Associate renewal?
This practice set includes real exam-style questions covering Power Apps, Power Automate,
Dataverse, Power Pages, ALM, Copilot, and Power Fx.

Each question includes a hidden answer. Try answering first, then select Reveal answer
to check your response.

Note: These are practice questions created for learning and exam preparation.
They are not official Microsoft exam questions. Always review Microsoft Learn for the latest guidance.

What You Will Practice

  • Modern command bar customization
  • Power Pages invitations and external identities
  • Power Automate sharing, throttling, and troubleshooting
  • Power Platform ALM and source control
  • Dataverse calculated, rollup, and formula columns
  • Canvas app formulas, DisplayMode, Visible, and formatting
  • Excel-to-Dataverse app creation with Copilot

Practice Questions

Question 1: Power Fx command bar properties

You are editing a command bar command by using Power Fx. Which three properties can you use?

  • Item
  • State
  • Visible
  • Unsaved
  • Enable rules
Reveal answer

Correct answers: Item, State, Unsaved

These are available through the selected record context for Power Fx commands.
Visible is a command property, not one of the selected context properties.
Enable rules belong to classic commanding.

Question 2: Power Fx and classic command visibility

How can you use Power Fx to control visibility of a classic command?

  • Edit the ribbon XML.
  • Create a component library.
  • Update the command scope.
  • Recreate as a modern command.
Reveal answer

Correct answer: Recreate as a modern command

Power Fx visibility formulas are used with modern commands. Classic commands use classic ribbon rules,
XML, and JavaScript-based customization patterns.

Question 3: Power Pages invitations

Which two benefits do invitations created in a Power Pages site provide administrators?

  • Power Pages allows the sender to link an invitee to a specific contact record.
  • Power Pages can assign a predetermined set of web roles to the invitee.
  • Power Pages ensures that local authentication will be used.
  • Power Pages adds the invitee as a guest user in the site tenant’s Microsoft Entra ID.
Reveal answer

Correct answers: Link an invitee to a specific contact record; assign a predetermined set of web roles

Power Pages invitations are associated with Dataverse contact records. They can also assign web roles
when the invitation is redeemed.

Question 4: Social media authentication in Power Pages

A user requires the ability to use social media authentication to connect to the portal instead of using
their Active Directory email address. Which feature should you use?

  • External handlers
  • Local identities
  • Multifactor authentication
  • External identities
  • Contact records
Reveal answer

Correct answer: External identities

Social sign-in providers are external identity providers. Local identities use username/password
credentials stored for the site user.

Question 5: Allow another user to edit a Power Automate flow

You need to allow a user to edit a flow that you created in Microsoft Power Automate. What should you do?

  • Add the flow to a solution.
  • Add the flow to a Microsoft Teams channel.
  • Share the flow with the user and add them as a co-owner.
  • Send a copy of the flow to the user and have them import it.
Reveal answer

Correct answer: Share the flow with the user and add them as a co-owner

Co-owners can edit, manage, and maintain a shared cloud flow. Sending a copy creates a separate flow,
not shared editing access.

Question 6: Flow run quota exceeded

You need to identify the effect of exceeding your flow run quota. What is the impact?

  • Flow runs are held in a queue.
  • Flow runs are throttled.
  • Flow runs are retried.
  • The flow is turned off.
Reveal answer

Correct answer: Flow runs are throttled

The immediate impact of exceeding limits is throttling or slowdown. Long-term repeated violations can
cause additional enforcement, but the exam answer is throttling.

Question 7: Shared cloud flow not visible

You created a non-solution cloud flow and shared it with a colleague. The flow no longer appears under
Cloud flows in My flows. What should you do?

  • Request that the colleague share the flow with you.
  • Add the flow to a solution.
  • Open the Shared with me tab.
  • Request that the environment administrator assign you the Run Flows privilege.
Reveal answer

Correct answer: Open the Shared with me tab

Shared flows are commonly found under Shared with me rather than the standard Cloud flows list.

Question 8: Bad request error in Power Automate

You are investigating why a Power Automate flow run failed. The error message includes the phrase
Bad request. Which type of issue is causing the flow to fail?

  • Licensing
  • Data usage
  • Temporary
  • Authentication
  • Action configuration
Reveal answer

Correct answer: Action configuration

A bad request usually means the action sent invalid input, missing values, or incorrectly formatted parameters.

Question 9: Environment type for all users

Users require an environment where they can create their own canvas apps and Power Automate flows.
All users must have access without IT support. Which environment type should the company use?

  • Default
  • Developer
  • Production
  • Sandbox
Reveal answer

Correct answer: Default

The default environment is automatically available to users in the tenant and supports personal productivity
app and flow creation.

Question 10: Auditing code changes

Several developers are working on a Dynamics 365 Sales project at the same time. The company must control
code changes and retain change history for auditing. Which solution should you use?

  • Power Apps CLI
  • Azure DevOps
  • Power Apps solution
  • Power Platform admin center
Reveal answer

Correct answer: Azure DevOps

Azure DevOps provides source control, commit history, pull requests, and traceability across development work.

Question 11: ALM hotfix support

An ALM strategy must support work on the next version while allowing a production bug fix independently
of work in progress. Where should solution components be stored?

  • Development environment
  • Source control
  • Default environment
  • Parent solution
Reveal answer

Correct answer: Source control

Source control supports branching, version history, hotfixes, and parallel development.

Question 12: Review changes to individual solution components

A company stores Power Platform customizations in source control. You need to review changes made to
individual components. Which tool should you use?

  • Plug-in Registration
  • Configuration Migration
  • Package Deployer
  • Solution Packager
Reveal answer

Correct answer: Solution Packager

Solution Packager extracts a solution into individual files so source control can show component-level changes.

Question 13: Modernize calculated column

You have a calculated column that sums multiple fields in the same table. The calculation updates when
data is retrieved. You need to modernize the solution so the same calculation can be used in a canvas app.

  • Convert the calculated column to a virtual column.
  • Replace the calculated column with a rollup column.
  • Replace the calculated column with a Power Fx formula column.
  • Replace the calculated column with a numeric column and update it using Power Automate.
Reveal answer

Correct answer: Replace the calculated column with a Power Fx formula column

Formula columns use Power Fx and are the modern approach for Dataverse calculations.

Question 14: Formula column interest calculation

You are creating a Power Fx formula column named InterestAmount.
The formula is: 

LoanAmount * InterestRate / 100

The column must support fractional values. Which column data type should you use?

  • Currency
  • Decimal
  • Whole Number
Reveal answer

Correct answer: Decimal

Decimal supports fractional values. Whole Number does not. Currency should be used when currency behavior
is specifically required.

Question 15: Correct Excel column names before app creation

You create a new app from Excel using Copilot. After import, the column headers do not match expectations.
The database logical names must accurately reflect the column headers. What are two ways to correct this?

  • Edit the column names on the app’s form.
  • Add new column headers after publishing the app.
  • Rename the columns before saving and opening the app.
  • Fix the column names in Excel and reimport by selecting Use first row as column headers.
Reveal answer

Correct answers: Rename the columns before saving and opening the app; fix the column names in Excel and reimport using first row as column headers

Logical names should be corrected before or during import. Changing labels on a form does not correct the
underlying logical column names.

Question 16: Change column names and data types before creating app

You have Excel worksheet data and plan to create a canvas app using Copilot. You need to change table
column names and data types before creating the app, while avoiding unnecessary extra components.
Which two options should you use?

  • Start with Copilot
  • Start with data
  • Create new tables
  • Connect existing data
  • Start with a page design
Reveal answer

Correct answers: Start with data; Create new tables

Use Start with data and then create/import the table from Excel so you can review and edit
the table schema before creating the canvas app.

Question 17: Excel-to-app table name source

You have data stored in a Microsoft Excel worksheet and plan to create a canvas app using Copilot.
You need to identify how the name of the table is populated. What is the name of the table derived from?

  • Filename
  • Data rows
  • Column name
  • Worksheet name
Reveal answer

Correct answer: Data rows

When Copilot is used, it generates table metadata based on the uploaded Excel data. This is a common
exam trap because the table name is not simply the filename or worksheet name.

Question 18: Copilot prerequisite for Excel-to-app

You have Excel worksheet data and plan to create a canvas app using Copilot. Which prerequisite should
you ensure is in place?

  • Copilot credits
  • Microsoft Dataverse
  • Managed environment
  • Production environment
Reveal answer

Correct answer: Microsoft Dataverse

Excel-to-app creation with Copilot creates a Dataverse table and an app based on that table.

Question 19: Currency formatting in a canvas app

A canvas app includes a currency column named Amount.
The app must display a currency symbol and two decimal places. Which formula should you use?

  • Trunc(ThisItem.'Amount'),2)
  • Set(Label, "$" & ThisItem.'Amount')
  • Concatenate("$",ThisItem.'Amount')
  • Text(Value(ThisItem.'Amount'), "$ ##.00")
Reveal answer

Correct answer: Text(Value(ThisItem.'Amount'), "$ ##.00")

The Text function formats the value. The format string adds the currency symbol and two decimals.

Question 20: Toggle controls editability

A canvas app has a Text input named TextInput1 and a Toggle named Toggle1.
The text input must be editable when the toggle is on and read-only when the toggle is off.
Which formula should you use for the DisplayMode property?

  • If(Toggle1.Value, DisplayMode.Edit, DisplayMode.View)
  • If(Toggle1.Value, DisplayMode.View, DisplayMode.Edit)
  • If(Toggle1.Value = false, DisplayMode.Edit)
  • If(Toggle1.Value = true, DisplayMode.View)
Reveal answer

Correct answer: If(Toggle1.Value, DisplayMode.Edit, DisplayMode.View)

When the toggle is true, the input is editable. When false, the input is view-only.

Question 21: Improve canvas app performance

A canvas app contains multiple text input controls. Each input control has an associated button with an
OnSelect formula. When testing, the app performs poorly. Which two actions should you perform?

  • Move the formulas to the OnChange property of the input controls.
  • Merge the buttons.
  • Create named formulas.
  • Combine multiple actions.
Reveal answer

Correct answers: Move the formulas to OnChange; Create named formulas

OnChange reduces unnecessary button-driven actions, and named formulas help centralize and optimize reusable logic.

Question 22: Reorder button visibility

You are building an inventory app. Products must be replenished when the level1 inventory
level is fewer than 100 units. Which two formulas can be used for the Visible property of the reorder button?

  • Coalesce(ThisItem.level1 < 100,"true")
  • If(ThisItem.level1 < 100,true,false)
  • If(ThisItem.level1 < 100,True)
  • !(ThisItem.level1 >= 100)
  • less(ThisItem.level1,100)
Reveal answer

Correct answers: If(ThisItem.level1 < 100,true,false); !(ThisItem.level1 >= 100)

The Visible property expects a Boolean value. Both selected formulas return true when level1 is below 100.

Question 23: Power Fx comments

You are creating a canvas app with complex formulas. You need to add comments to explain formula purpose.
How should you precede your comments?

  • //
  • --
  • #
  • '
Reveal answer

Correct answer: //

Power Fx supports single-line comments with //. It also supports block comments using
/* ... */.

Question 24: Save button DisplayMode based on FormMode

You are building a canvas app that includes a Form control named EditForm1.
Inside the form, you have a Save button named ButtonSave.
The Save button must be available only when the form is in Edit or New mode and unavailable in View mode.

  • If(EditForm1.Mode = FormMode.View, DisplayMode.Disabled, DisplayMode.Edit)
  • If(EditForm1.Mode = FormMode.New, DisplayMode.Disabled, DisplayMode.Edit)
  • If(EditForm1.Mode = FormMode.Edit, DisplayMode.Disabled, DisplayMode.View)
  • If(EditForm1.Mode = FormMode.View, DisplayMode.Edit, DisplayMode.Disabled)
Reveal answer

Correct answer: If(EditForm1.Mode = FormMode.View, DisplayMode.Disabled, DisplayMode.Edit)

This disables the button in View mode and enables it in both Edit and New modes.

Question 25: Button formula execution

You add a button to a screen in a canvas app. You need to set up the button to run a formula when selected.
Which property should you set?

  • OnSelect
  • Pressed
  • Select
  • TabIndex
  • Visible
Reveal answer

Correct answer: OnSelect

The OnSelect property defines the formula that runs when the user selects the button.

Quick Study Notes

Topic Remember This
Power Fx comments // for single-line comments
Button click behavior Use OnSelect
Visibility formulas Return Boolean values: true or false
Currency formatting Use Text(value, format)
Modern Dataverse calculations Use Power Fx formula columns
Excel-to-app with Copilot Requires Microsoft Dataverse
ALM and hotfixes Use source control
Component-level solution review Use Solution Packager

Common Exam Traps

  • Classic commands cannot directly use Power Fx visibility. Recreate as a modern command.
  • Bad request usually points to action configuration, not licensing.
  • Flow run limits usually result in throttling first.
  • FormMode.View is when save buttons should usually be disabled.
  • Formula columns are the modern replacement pattern for many Dataverse calculated column scenarios.
  • Source control is required for branching, auditing, and hotfix support.

Final Thoughts

The Microsoft Power Platform Functional Consultant Associate renewal assessment focuses less on memorization
and more on recognizing practical implementation choices. If you understand how Power Apps, Power Automate,
Power Pages, Dataverse, and ALM fit together, you can answer most questions confidently.

For your final review, spend extra time on:

  • Power Fx formula behavior
  • Canvas app control properties
  • Dataverse formula columns
  • Excel-to-Dataverse app creation with Copilot
  • Power Platform ALM with source control

Study tip: For each question, do not just memorize the answer. Ask yourself:
“What platform behavior is Microsoft testing here?”