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 |
|---|---|
| Review the skills measured as of January 12, 2024 | This list represents the skills measured AFTER the date provided. Study this list if you plan to take the exam AFTER that date. |
| Review the skills measured prior to January 12, 2024 | Study this list of skills if you take your exam PRIOR to the date provided. |
| Change log | You can go directly to the change log if you want to see the changes that will be made on the date provided. |
| 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 January 12, 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 calculated, 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, 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
Write and use 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
Key to understanding the table: The topic groups (also known as functional groups) are in bold typeface followed by the objectives within each group. The table is a comparison between the two versions of the exam skills measured and the third column describes the extent of the changes.
| Skill area prior to January 12, 2024 | Skill area as of January 12, 2024 | Change |
|---|---|---|
| Audience profile | Major | |
| Configure Microsoft Dataverse | Configure Microsoft Dataverse | % increased |
| Manage a data model | Manage the data model | Major |
| Configure Dataverse | Manage Dataverse | Minor |
| Configure security settings | Configure security settings | Major |
| Create apps by using Microsoft Power Apps | Create apps by using Microsoft Power Apps | % increased |
| Create model-driven apps | Create model-driven apps | Major |
| Define use cases for canvas apps | Describe canvas apps | Minor |
| Build Microsoft Power Pages | Build Microsoft Power Pages | Minor |
| Create and manage process automation | Create and manage logic and process automation | % increased |
| Create cloud flows | Create and manage cloud flows | Major |
| Create and manage business process flows | Create and manage business process flows | Minor |
| Create classic workflows | Create and manage classic Dataverse workflows | Minor |
| Implement low-code logic | Added | |
| Describe Microsoft Power Virtual Agents | Removed | |
| Identify use cases for Power Virtual Agents | Removed | |
| Identify components of Power Virtual Agents | Removed | |
| Import and visualize data by using dataflows and Power BI | Removed | |
| Consume Power BI in Power Platform | Removed | |
| Create and use dataflows | Removed | |
| Define an environment strategy | Manage environments | % increased |
| Participate in Application Lifecycle Management (ALM) | Participate in application lifecycle management (ALM) | Major |
| Describe interoperability with other services | Manage interoperability with other services | Major |
Skills measured prior to January 12, 2024
Audience profile
As a candidate for this exam, you:
Perform discovery.
Capture requirements.
Engage subject matter experts and stakeholders.
Configure Microsoft Power Platform solutions and apps.
You create:
Application enhancements
Tailored user experiences
Process automation
Reporting
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 the integration points to connect to third-party applications and services. You generate training documentation and 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 Microsoft Power Platform components to work with:
Microsoft Teams
Microsoft Excel
Microsoft Word
You should have proficiency in:
Data modeling
User experience design
Requirements analysis
Process analysis
As a candidate, you should have two years' experience.
Skills at a glance
Configure Microsoft Dataverse (20–25%)
Create apps by using Microsoft Power Apps (15–20%)
Create and manage process automation (20–25%)
Describe Microsoft Power Virtual Agents (10–15%)
Import and visualize data by using dataflows and Power BI (10–15%)
Define an environment strategy (10–15%)
Configure Microsoft Dataverse (20–25%)
Manage a data model
Create or modify standard, activity, or virtual tables
Configure table ownership
Create new tables or modify existing tables
Determine which type of relationships to implement including 1:N and N:N
Configure table relationship behaviors including cascading rules
Create new relationships or modify existing relationships
Create new columns or modify existing columns
Create alternate keys for tables
Configure table properties
Configure connection roles
Configure Dataverse
Configure Dataverse search
Configure auditing
Perform data management tasks including import, export, and bulk deletion
Configure duplicate detection settings
Configure security settings
Create and 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
Manage sharing
Diagnose security issues
Create apps by using Microsoft Power Apps (15–20%)
Create model-driven apps
Create and configure multiple form types
Use specialized form components
Create and configure views
Determine which reporting options to use including embedding Microsoft Power BI or using Fetch-based reports
Configure site maps and compose model-driven apps
Share a model-driven app
Configure custom pages
Create and configure business rules
Configure modern commanding
Define use cases for canvas apps
Identify when to use a canvas app
Describe canvas app structure
Describe form navigation, formulas, variables and collections, and error handling
Run Microsoft Power Automate flows based on actions that occur in a canvas app
Build Microsoft Power Pages
Configure pages, forms, and navigation
Configure advanced Power Pages features
Configure website security including web roles and page access
Describe use cases for templates
Implement registration options
Create and manage process automation (20–25%)
Create cloud flows
Describe types of flows, use cases, and flow components including when to use a classic workflow
Describe common connectors, triggers, and actions
Implement logic controls including branches, loops, conditions, error handling, and variables
Implement dynamic content and expressions
Test and troubleshoot flows
Create and manage business process flows
Configure a business process flow
Add stages, workflows, and action steps to a business process flow
Manage the business process flow table for a business process flow
Configure advanced logic
Create classic workflows
Configure a workflow
Troubleshoot workflows
Manage workflow logs
Describe Microsoft Power Virtual Agents (10–15%)
Identify use cases for Power Virtual Agents
Identify chatbot environments
Describe chatbot skills and AI capabilities
Identify options for security
Identify components of Power Virtual Agents
Describe topics
Describe entities
Identify use cases for fallback topics
Import and visualize data by using dataflows and Power BI (10–15%)
Consume Power BI in Microsoft Power Platform
Add Power BI tiles to model-driven apps and canvas apps
Add canvas apps to a Power BI dashboard
Trigger Power Automate flows from Power BI alerts
Use Power BI in Power Pages
Create and use dataflows
Import data to Dataverse using Power Query
Schedule dataflow runs
Describe Power Fx
Define an environment strategy (10–15%)
Participate in application lifecycle management (ALM)
Describe use cases for App checker and Solution checker
Create and manage solutions
Describe the difference between managed and unmanaged solutions
Describe interoperability with other services
Add apps to Microsoft Teams
Create Teams channels
Identify when to use the on-premises data gateway