Exam PL-200: Microsoft Power Platform Functional Consultant

Candidates for Exam PL-200: Microsoft Power Platform Functional Consultant exam perform discovery, capture requirements, engage subject matter experts and stakeholders, translate requirements, and configure Power Platform solutions and apps. They create application enhancements, custom user experiences, system integrations, data conversions, custom process automation, and custom visualizations. Candidates implement the design provided by and in collaboration with a solution architect and the standards, branding, and artifacts established by User Experience Designers. They design integrations to provide seamless integration with third-party applications and services.

Learning Objectives

To successfully pass the Exam PL-200: Microsoft Power Platform Functional Consultant, it is highly important to understand the exam objectives. So, here are the learning objectives for Exam PL-200.

Configure Microsoft Dataverse (25-30%)
Create apps by using Power Apps (20-25%)
Create and manage Power Automate (15-20%)
Implement Power Virtual Agents chatbots (10-15%)
Integrate Power Apps with other apps and services (15-20%)

Learning Path

After passing the Microsoft Exam PL-200, you will get the credential of the Microsoft Certified: Power Platform Functional Consultant Associate.

Exam Details

Explaining the format of Exam PL-200 is the most important step. The exam includes 40-60 questions. However, the Microsoft PL-200 exam questions will appear in the form of multiple-choice. The candidate will get 120 minutes to complete the exam, in total, they get 120 minutes. The exam is available in the English language. The candidate has to pay $165 USD as the examination fee. The passing score for PL-200:is 700 (on a scale of 1-1000).

Scheduling the Exam

Pearson VUE: In order to appear in the Microsoft exam, the candidate has to schedule the exam and make themselves register with Microsoft. The candidate can schedule their exam with the Pearson VUE.

Certiport : The candidate also schedules the Exam PL-200 with Certiport. Schedule Your Exam Now!

Now, we have acquired all the information related to Microsoft Power Platform Functional Consultant . It’s time for you to understand the Course Outline. The Course Outline forms the most crucial aspect of the examination. So, let’s begin.

Check PL-200 Interview Questions and Boost your Preparation

Microsoft Exam PL-200 Course Outline

As you know, Exam PL-200 includes technical tasks such as perform discovery, capture requirements, engage subject matter experts and stakeholders, translate requirements, and configure Power Platform solutions and apps. So, it is important to go through the whole course outline once and to understand and learn all the objectives.

The course Outline for the English version was updated on March 28, 2023.

1. Configure Microsoft Dataverse (20-25%)

1.1 Manage a data model

Create or modify standard, activity, or virtual tables
Configure tables ownership (Microsoft Documentation: Types of tables)
create new tables or modify existing tables (Microsoft Documentation: Create a custom table, Editing Table)
Then, determine which type of relationship to implement including 1: N and N: N (Microsoft Documentation: Table relationships, Create N:N (many-to-many) table relationships, Create one-to-many or many-to-one table relationships)
configure table relationship behaviors including cascading rules (Microsoft Documentation: Configuring entity relationship cascading behavior, Table relationships)
create new relationships or modify existing relationships (Microsoft Documentation: Create and edit One-to-many or Many-to-one table relationships, Create a relationship between tables)
After that, create new columns or modify existing columns (Microsoft Documentation: Create and edit columns)
create alternate keys for tables (Microsoft Documentation: Working with alternate keys)
configure table properties
configure connection roles (Microsoft Documentation: Connection roles configuration)

1.2 Configure Dataverse

configure Dataverse Search
After that, configure auditing (Microsoft Documentation: Auditing, Configure entities and attributes for auditing)
perform data management tasks including import, export, and bulk deletion (Microsoft Documentation: Add or remove sample data, Remove a large amount of specific, targeted data with bulk deletion, Merge data)
configure duplicate detection settings (Microsoft Documentation: Detect duplicate data, Enable and Disable duplicate detection, Set up duplicate detection)

1.3 Configure security settings

Firstly, create and manage business units (Microsoft Documentation: Security concepts in Microsoft Dataverse, Create or edit business units)
create and manage security roles (Microsoft Documentation: Create users and assign security roles, Security roles and privileges)
After that, create and manage users and teams (Microsoft Documentation: Microsoft Dataverse for Teams environment, Create users and assign security roles)
create and manage column security
configure hierarchy security (Microsoft Documentation: Hierarchy security to control access)
Configure Microsoft Azure Active Directory (Azure AD) group teams
Manage sharing
Diagnose security issues

2. Create apps by using Microsoft Power Apps (15-20%)

2.1 Create model-driven apps

create and configure multiple forms types (Microsoft Documentation: Create and design model-driven app forms)
Use specialized form components
create and configure views (Microsoft Documentation: Create and edit public or system model-driven app views)
Determine which reporting options to use including embedding Microsoft Power BI or using Fetch-based report
configure site maps and compose model-driven apps
share a model-driven app (Microsoft Documentation: Share a model-driven app using Power Apps)
Configure custom pages (Microsoft Documentation: Add a custom page to your model-driven app)
Create and configure business rules (Microsoft Documentation: Create a business rule for a table)
Configure modern commanding

2.2 Define use cases for canvas apps

Identify when to use a canvas app (Microsoft Documentation: What are canvas apps?)
Describe canvas app structure
Describe form navigation, formulas, variables and collections, and error handling (Microsoft Documentation: Back and Navigate functions in Power Apps, Understand variables in canvas apps, Errors function in Power Apps)
Run power automate flows based on actions that occur in a canvas app

2.3 Build Microsoft Power Pages

Configure pages, forms, and navigation (Microsoft Documentation: About basic forms, Manage web pages)
Configure advanced power pages features (Microsoft Documentation: Advanced configuration)
Configure website security including web roles and page access (Microsoft Documentation: Create web roles for portals)
Describe use cases for templates (Microsoft Documentation: Use Word templates to create standardized documents)
Implement registration options (Microsoft Documentation: Register an application with the Microsoft identity platform)

3. Create and manage Process Automation (20-25%)

3.1 Create cloud flows

Firstly, describe types of flows, use cases and flow components including when to use a classic workflow (Microsoft Documentation: Different types of flows)
Describe common connectors, triggers, and actions (Microsoft Documentation: Connectors overview)
Implement logic controls including branches, loops, conditions, error handling, and variables (Microsoft Documentation: Create loops that repeat workflow actions, Handle errors and exceptions in Azure Logic Apps)
Implement dynamic content and expressions
Test and troubleshoot flows (Microsoft Documentation: Troubleshooting a cloud flow)

3.2 Create and manage business process flows

configure a business process flow (Microsoft Documentation: Create a business process flow)
Add stages, workflows, and action steps to a business process flow (Microsoft Documentation: Create a business process flow)
Manage the business process flow table for a business process flow (Microsoft Documentation: Business process flows)
Configure advanced logic

3.3 Create classic workflows

Configure a workflow
Troubleshoot workflows (Microsoft Documentation: Troubleshoot and diagnose workflow failures in Azure Logic Apps)
Manage workflow logs

4. Describe Microsoft Power Virtual Agents (10-15%)

4.1 Identify use cases for Power Virtual Agents

Identify chatbot environments (Microsoft Documentation: Working with environments in Power Virtual Agents)
Describe chatbot skills and AI capabilities (Microsoft Documentation: Enable advanced AI features in Power Virtual Agents)
Identify options for security

4.2 Identify components of Power Virtual Agents

Describe topics (Microsoft Documentation: Create and edit topics in your Power Virtual Agents bot)
Describe entities
Identify use cases for fallback topics (Microsoft Documentation: Configure the system fallback topic in Power Virtual Agents)

5. Import and visualize data by using dataflows and Power BI (10-15%)

5.1 Consume Power BI in Microsoft Power Platform

Add Power BI tiles to model-driven apps and canvas apps (Microsoft Documentation: Add a Power BI visual into a model-driven app)
Add canvas apps to a Power BI dashboard (Microsoft Documentation: How to create a canvas app with Power BI visual)
Trigger Power Automate flows from Power BI alerts (Microsoft Documentation: Integrate Power BI data alerts with Power Automate)
Use Power BI in Power Pages (Microsoft Documentation: What is Power Pages)

5.2 Create and use dataflows

Import data to Dataverse using Power Query (Microsoft Documentation: Import or export data from Dataverse)
Schedule dataflow runs (Microsoft Documentation: What are dataflow)
Describe Power Fx (Microsoft Documentation: Microsoft Power Fx overview)

6. Define an environment strategy (10–15%)

6.1 Participate in Application Lifecycle Management (ALM)

Describe use cases for App Checker and Solution Checker (Microsoft Documentation: Use the solution checker to validate your model-driven apps in Power Apps)
Create and manage solutions (Microsoft Documentation: Solutions overview)
Describe the difference between managed and unmanaged solutions (Microsoft Documentation: Solution concepts)

6.2 Describe interoperability with other services

Add apps to Microsoft Teams (Microsoft Documentation: Add an app to Microsoft Teams)
Create Teams channels (Microsoft Documentation: Create your first teams and channels in Microsoft Teams)
Identify when to use the on-premises data gateway

Exam PL-200: Microsoft Power Platform Functional Consultant FAQ

Get ready to resolve all your doubts with latest Exam PL-200: Microsoft Power Platform Functional Consultant FAQ

Exam Policies

While preparing for Microsoft Exam PL-200: Microsoft Power Platform Functional Consultant, you will be completely responsible for knowing and complying with Microsoft Certification exam policies, together with the specified exam delivery provider’s policies and procedures.

Also, you can go through the Exam Retake Policy together with other Microsoft exam available and exam testing procedures. The exam policy page provides details of the exam provider’s policies and procedures together with the exam provider’s details. Note, you will have 30 days after taking an exam to challenge your exam score for that exam.

Preparation Guide to qualify Microsoft Exam PL-200

To start the ideal preparation for the Exam PL-200: Microsoft Power Platform Functional Consultant, the following PL-200 study guide details provides analytical steps that you should consider for developing an ideal schedule for your Exam PL-200 preparation.

Exam PL-200: Microsoft Power Platform Functional Consultant preparatory guide

Microsoft Learning Platform

Microsoft offers PL-200 learning paths, the candidate should visit the official website of Microsoft. The candidate can find every possible information on the official site. For this, the candidate will find many Microsoft PL-200 learning paths and documentations. Finding relatable content on the Microsoft website is quite an easy task. Also, you can find the study guide for PL-200 on the official website of Microsoft.

Microsoft Documentation

Microsoft Documentations are an important learning resource while preparing for Exam PL-200: Microsoft Power Platform Functional Consultant. The candidate will find documentation on every topic relating to the particular exam. This step is very valuable in preparing for becoming a certified functional consultant. You can refer to the following documentation for Exam PL-200:

Instructor-Led Training

The Microsoft PL-200 exam training programs that Micorosft provides itself are available on their website. The instructor-led training is an essential resource in order to prepare for the exam like PL-200. The candidate can find the instructor-led training on the page of the particular exam on the Microsoft website. There are various Microsoft PL-200 training courses available prior to one exam. The following is the training program offered by Microsoft.

Course PL-200T00-A: Microsoft Power Platform Functional Consultant

Module 1: Introduction to the Power Platform
Module 2: The Functional Consultant role
Module 3: Work with Dataverse
Module 4: Make Power Apps
Module 5: Build Power Automate flows
Module 6: Work with Power Virtual Agents
Module 7: Analyze data with Power BI

Books and Guides

The next step in the preparatory guide should be books and study guides. The candidate needs to find those books which are enriched with information. Candidates should study some books and guides which will definitely help them to gather knowledge about the particular exam. We at Testprep training recommends the following Microsoft PL-200 books:

Microsoft Power Platform Functional Consultant: PL-200 Exam Guide: Learn how to customize and configure Microsoft Power Platform and prepare for the PL-200 exam by Julian Sharp

Join a Study Group

For passing the Microsoft Power Platform Functional Consultant, the candidate needs to get and share knowledge. So, we are suggesting you join some study where you can discuss the concepts with the people who have the same goal. This will lead the candidate throughout their preparation.

Evaluate yourself with Practice Test

The most important step is to try your hands on the practice test. The Microsoft PL-200 Practice tests are the one which ensures the candidate about their preparation. There are many practice tests available on the internet nowadays, the candidate can choose whichever they want. The practice test is very beneficial in preparing the Exam PL-200: Microsoft Power Platform Functional Consultant. So, Start Preparing Now!