Study guide for Exam PL-200: Microsoft Power Platform Functional Consultant

Purpose of this document

This study guide should help you understand what to expect on the exam and includes a summary of the topics the exam might cover and links to additional resources. The information and materials in this document should help you focus your studies as you prepare for the exam.

Useful links	Description
How to earn the certification	Some certifications only require passing one exam, while others require passing multiple exams.
Certification renewal	Microsoft associate, expert, and specialty certifications expire annually. You can renew by passing a free online assessment on Microsoft Learn.
Your Microsoft Learn profile	Connecting your certification profile to Microsoft Learn allows you to schedule and renew exams and share and print certificates.
Exam scoring and score reports	A score of 700 or greater is required to pass.
Exam sandbox	You can explore the exam environment by visiting our exam sandbox
Request accommodations	If you use assistive devices, require extra time, or need modification to any part of the exam experience, you can request an accommodation.
Take a free Practice Assessment	Test your skills with practice questions to help you prepare for the exam.

Updates to the exam

Our exams are updated periodically to reflect skills that are required to perform a role. We have included two versions of the Skills Measured objectives depending on when you are taking the exam.

We always update the English language version of the exam first. Some exams are localized into other languages, and those are updated approximately eight weeks after the English version is updated. While Microsoft makes every effort to update localized versions as noted, there may be times when the localized versions of an exam are not updated on this schedule. Other available languages are listed in the Schedule Exam section of the Exam Details webpage. If the exam isn't available in your preferred language, you can request an additional 30 minutes to complete the exam.

Note

The bullets that follow each of the skills measured are intended to illustrate how we are assessing that skill. Related topics may be covered in the exam.

Note

Most questions cover features that are general availability (GA). The exam may contain questions on Preview features if those features are commonly used.

Skills measured as of December 26, 2024

Audience profile

As a candidate for this exam, you:

• Perform discovery.

• Capture requirements.

• Engage subject matter experts and stakeholders.

• Configure business solutions by using Microsoft Power Platform tools and components.

You create:

• Application enhancements

• Tailored user experiences

• Process automation

As a candidate, you implement the design provided by and in collaboration with a solution architect and the standards, branding, and artifacts established by user experience designers. You implement integrations with third-party applications and services. You generate training documentation, and you facilitate training and enablement.

You must interact and effectively communicate with members of a delivery team, stakeholders, and customer teams while championing for their success. You must have an understanding of application lifecycle management (ALM) practices for Microsoft Power Platform and quality assurance.

You should be familiar with using the following Microsoft Power Platform components:

• Microsoft Dataverse

• Microsoft Power Apps

• Microsoft Power Automate cloud flows

• Microsoft Power Pages

• Microsoft Power Platform environments

You should have proficiency in:

• Data modeling

• User experience design

• Requirements analysis

Skills at a glance

• Configure Microsoft Dataverse (25–30%)

• Create apps by using Microsoft Power Apps (25–30%)

• Create and manage logic and process automation (25–30%)

• Manage environments (15–20%)

Configure Microsoft Dataverse (25–30%)

Manage the data model

• Create or modify standard, activity, or virtual tables

• Create new tables or modify existing tables

• Determine which type of relationship to implement, including one-to-many and many-to-many

• Configure table relationships including behaviors and cascading rules

• Create new or modify existing columns, including rollup and formula

• Configure table properties

Manage Dataverse

• Configure Dataverse search, and manage the search index

• Manage auditing

• Describe options for importing and exporting data

• Configure duplicate detection settings

• Configure bulk deletion

Configure security settings

• Manage business units

• Create and manage security roles

• Create and manage users and teams

• Create and manage column security

• Configure hierarchy security

• Configure Microsoft Entra ID group teams

Create apps by using Microsoft Power Apps (25–30%)

Create model-driven apps

• Create and configure multiple form types

• Use controls in the form designer

• Create and configure views

• Configure custom pages

• Configure modern commanding by using Power Fx

• Embed a canvas app in a model-driven app form

• Add Microsoft Power BI dashboards and reports in a model-driven app

Describe canvas apps

• Describe canvas app structure

• Describe form navigation, formulas, variables and collections, and error handling

• Describe how Microsoft Power Automate flows are called from a canvas app

Build Microsoft Power Pages

• Configure pages, forms, lists, and navigation

• Describe advanced Power Pages features, including document management, search, multi-step forms, and Power BI

• Configure website security including web roles and page access

• Describe use cases for templates

• Describe authentication options

Create and manage logic and process automation (25–30%)

Create and manage cloud flows

• Describe types of flows, use cases, and flow components, including when to use a classic workflow

• Describe components of a connector

• Implement logic controls including branches, loops, conditions, error handling, and variables

• Implement dynamic content and expressions

• Work with the Dataverse connector

• Manage and troubleshoot flows

Create and manage business process flows

• Configure a business process flow

• Add stages, workflows, and flow steps to a business process flow

• Manage the business process flow table for a business process flow

Create and manage classic Dataverse workflows

• Configure a workflow

• Troubleshoot workflows

• Manage workflow logs

Implement low-code logic

• Configure low-code plug-ins

• Create and manage Power Fx functions and formulas

• Create and configure business rules

Manage environments (15–20%)

Participate in application lifecycle management (ALM)

• Describe use cases for app checker and solution checker

• Create and manage Dataverse solutions

• Describe the difference between managed and unmanaged Dataverse solutions

• Manage Microsoft Power Platform environments for development

• Import and export Dataverse solutions

Manage interoperability with other services

• Configure email integration

• Configure Microsoft SharePoint integration

• Describe options for document management

• Work with Microsoft Word templates

Study resources

We recommend that you train and get hands-on experience before you take the exam. We offer self-study options and classroom training as well as links to documentation, community sites, and videos.

Study resources	Links to learning and documentation
Get trained	Choose from self-paced learning paths and modules or take an instructor-led course
Find documentation	Microsoft Power Platform documentation Power BI documentation Microsoft Power Apps documentation Power Automate documentation Microsoft Power Virtual Agents documentation AI Builder documentation
Find videos	Exam Readiness Zone #LessCodeMorePower Browse other Microsoft Learn shows
Ask a question	Microsoft Q&A | Microsoft Docs
Get community support	Power Platform Community (microsoft.com)
Follow Microsoft Learn	Microsoft Learn - Microsoft Tech Community

Change log

The table below summarizes the changes between the current and previous version of the skills measured. The functional groups are in bold typeface followed by the objectives within each group. The table is a comparison between the previous and current version of the exam skills measured and the third column describes the extent of the changes.

Skill area prior to December 26, 2024	Skill area as of December 26, 2024	Change
Configure Microsoft Dataverse	Configure Microsoft Dataverse	No % change
Manage the data model	Manage the data model	Minor
Create apps by using Microsoft Power Apps	Create apps by using Microsoft Power Apps	No % change
Build Microsoft Power Pages	Build Microsoft Power Pages	Minor
Create and manage logic and process automation	Create and manage logic and process automation	No % change
Implement low-code logic	Implement low-code logic	Minor