PL-200 Exam Study Guide (Microsoft Power Platform Functional Consultant)

You can access PL-200 Exam Microsoft official page here

Preparing for the PL-200 Microsoft Power Platform Functional Consultant Certificate exam? Don’t know where to start? This post is the PL-200 Certificate Study Guide (with links to each exam objective).

I have curated a list of articles from Microsoft documentation for each objective of the PL-200 exam. I hope this article will help you to achieve the PL-200 Microsoft Power Platform Functional Consultant Associate Certification. Also, please share the post within your circles so it helps them to prepare for the exam.

Skills Measured

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%)

PL-200 Exam Free Study Guide

For each test objective, I’ve compiled a thorough collection of articles from Microsoft documentation. Please feel free to forward this page to your friends and coworkers in order to assist them in preparing for the test .

Configure Microsoft Dataverse (25-30%)

Manage an Existing Data Model

Assign a type for a table including standard, activity, or virtual
Types of tables
Configure tables ownership
Standard table ownership
Create new tables or modify existing tables
Create a custom table
Edit a table
Determine which type of relationship to implement including 1: N and N: N
Types of table relationships
Create N:N table relationships in Dataverse
Create a 1:N or N:1 relationship
Configure table relationship behaviors including cascading rules
Configure entity relationship cascading behavior
Automate business processes
Create new relationships or modify existing relationships
Create a relationship between tables
Edit relationships
Create new columns or modify existing columns
How to create and edit columns
Create alternate keys for tables
Work with alternate keys
Configure table properties
Configure connection roles
Configure connection roles

Create and Manage Processes

Define requirements for business rules
Business rules for Dataverse
Define and implement business rule logic
Apply business logic in Microsoft Dataverse
Define the scope for business rules
Define the components of a business rule
Configure and test business rules
Create a business rule
Validate a business rule
Configure a synchronous classic workflow
Replace classic Common Data Service workflows with flows

Configure Dataverse

Configure Relevance Search
Search across entity data using relevance search
Relevance search API
Configure auditing
Auditing overview
Configure entities and attributes for auditing
Perform data management tasks
Add or remove sample data
Merge data
Remove a large amount of data with bulk deletion
Remove user personal data
Configure duplicate detection settings
Detect duplicate data using code
Enable and disable duplicate detection
Set up duplicate detection rules to keep your data clean
Configure privacy preferences
Compliance and data privacy

Configure Security Settings

Create and manage business units
Business units
Create or edit business units
Create and manage security roles
Get started with security roles in Dataverse
Security roles and privileges
Assign a security role to a user
Create and manage users and teams
Create users and assign security roles
About the Microsoft Dataverse for Teams environment
Create and manage column security profiles
Field security entities
Configure hierarchy security
Hierarchy security to control access
Configure Conditional Access settings
Block access by location with Azure AD Conditional Access

Create Apps by Using Power Apps (20-25%)

Create Model-driven Apps

Create and configure forms
Create and design model-driven app forms
Create and configure views
Create and edit model-driven app views
Create and configure charts
Create a model-driven app system chart
Create and configure dashboards
Create or edit model-driven dashboards
Configure site maps
Create a model-driven app site map
Select applicable assets for an app including tables, forms, views, business process flows, dashboards, and charts
Add model-driven app components in the Power Apps app designer
Share a model-driven app
Share a model-driven app using Power Apps
Apply organizational branding by using themes
Use a theme to create a custom look for your app

Create Canvas Apps

Create a canvas app
Create a canvas app from scratch based on Excel data
Create a canvas app in Power Apps
Configure Dataverse as a data source for an app
Create a canvas app from scratch using Dataverse
Connect to Microsoft Dataverse
Create canvas app screens
Add a screen to a canvas app
Implement form navigation, formulas, variables and collections, and error handling
Navigation in a canvas app in Power Apps
Use basic formulas to make better Power Apps canvas apps
Understand canvas-app variables in Power Apps
Create and update a collection in a canvas app
‘IfError’ and ‘IsError’ functions in Power Apps
Build reusable components and component libraries
Create a component for canvas apps
Create a component library for canvas apps
Configure offline capabilities for apps
Develop offline-capable canvas apps
Implementing offline capability in your app
Run Power Automate flows based on actions that occur in a canvas app
Start a flow in a canvas app
Interpret App Checker results and resolve identified issues
App checker results for Canvas apps in solutions
Power Apps Checker includes rules for canvas apps & flows
Review a canvas app for accessibility in Power Apps
Test, monitor, and share apps
Testing and troubleshooting your app
Working with Test Studio (experimental)
Debugging canvas apps with Monitor
Share a canvas app in Power Apps

Create Portal Apps

Create a portal app
Create a portal in an environment
Expose Dataverse data
Integrate Power Apps portals with Dataverse
Configure Power Apps portals security
Configure portal web pages, forms, and navigation
Manage web pages in Power Apps portals
Configure a web form for a portal
Navigation
Render up to 3 levels of page hierarchy with hybrid navigation
Render a website header & primary navigation bar
Configure portal security including web roles and page access
Create web roles for portals
Manage page permissions

Create and Manage Power Automate (15-20%)

Create Flows

Describe types of flows and flow components
Overview of the different types of flows
3 major components of Microsoft Flow
Trigger a flow by using Dataverse connectors
Create an automated flow by using the Common Data Service connector
Run actions by using the Dataverse connector
Write data into Dataverse
Dataverse: Write data using actions
Implement logic control
Build more powerful conditions in flows
Implement dynamic content and expressions
Use expressions in flow actions
Working with Dynamic Content
Interpret and act on Flow Checker results
Power Apps checker now includes Flow checker results
Activate and deactivate flows
Turn flows on or off
Interpret flow analytic data
Announcing Microsoft Flow Analytics
View analytics for flows

Create and Manage Business Process Flows

Configure a business process flow
Create a business process flow in Power Automate
Add business rules, workflows, and action steps to a business process flow
Create a business process flow to standardize processes
Define stages and steps
Configure background workflow stages and steps
Configure parallel branches
Create parallel approval workflows with Power Automate
Manage the business process flow table for a business process flow
Business process flows overview

Build Desktop Flows

Describe types of desktop flows
Introduction to other types of desktop flows
Identify use cases for desktop flows
5 practical Power Automate examples your business will love
Differentiate between attended and unattended desktop flows
Run attended and unattended UI flows
Attended vs Unattended UI Flows
Record business process tasks
Record flows in Power Automate Desktop

Implement Power Virtual Agents Chatbots (10-15%)

Create Chatbot

Assign a chatbot to an environment
Assign environment security roles
Publish a chatbot
Publish a chatbot to various channels
Share a chatbot
Share your bot with other users
Add chatbots to Teams and other channels
Add a bot to Microsoft Teams
Add a bot to Facebook
Add a bot to mobile and custom apps
Monitor and diagnose bot performance, usage, and topic usage
Analyze chatbot usage
Analyze bot performance and usage in Power Virtual Agents
Analyze topic usage in Power Virtual Agents

Configure Topics

Define topic conversation triggers
Power Virtual Agent topic triggers
Create questions, messages, and conditions
Create and edit topics in your Power Virtual Agents bot
Extract topics from a web page
Create topics from existing online support content
Implement greetings, escalations, error messages, and statuses
Configure your bot to start the conversation automatically
Configure hand-off to omnichannel for customer service
Topic errors
Topic status
Call a Power Automate flow to run an action
How to Call an Action through Power Automate?
Call child flows

Configure Entities

Create custom entities
Custom entities
Implement entities in conversations
Use entities in a conversation
Implement variables to store data
Use variables
Reuse variables across topics

Integrate Power Apps with Other Apps and Services (15-20%)

Integrate Power BI with Power Apps

Create Power BI visualizations
Power Apps visual for Power BI
Create data flows and schedule data flow runs
Create and use dataflows in Power Apps
Schedule refresh for your Dataflow
Filter data
Filtering data in Power Apps based on Power BI
Power Apps Power BI integration dynamic filtering
Build reports and dashboards
Create Power BI reports & dashboards with PowerApps
Publish and share reports and dashboards
Publish and share in Power BI
Add Power BI tiles to model-driven apps and canvas app
Add Power BI visualizations on your dashboard
Embed a Power BI report in a model-driven form
Canvas app
Embed Power BI tiles in PowerApps
Power BI tile control in Power Apps
Add canvas apps to a Power BI dashboard
Embed a Power Apps visual in a Power BI report
Trigger Power Automate flows from Power BI alerts
Integrate Power BI data alerts with Power Automate
Set up data alerts for the Power BI dashboard

Implement AI Builder

Determine which AI Builder model type to use
What is AI Builder?
AI builder model types
Create an AI Builder model
Build a model in AI Builder
Prepare source data for use by models
Data preparation
AI Builder binary classification – data preparation
Train, test, and publish a model
Train your model in AI Builder
Publish your model in AI Builder
Prediction model performance
Consume a model by using Power Apps
Use your prediction model in Power Apps
Consume a model by using Power Automate
Use a prebuilt model in Power Automate
Use a custom model in Power Automate

Integrate Power Apps with Microsoft 365

Add apps to Microsoft Teams
Add an app to Microsoft Teams
Embed a canvas app as a personal app in Teams
Create a Teams app from a Power Apps app
Create apps in Microsoft Teams by using Power Apps
Create an app directly in Teams
Create your first app in Microsoft Teams
Configure app policies
Manage Power Platform apps in the Teams admin center
Manage app permission policies
Manage app setup policies
Create a Teams channel by using Power Automate
Create a private channel in Teams using Flow
Create a flow that will create a channel
Configure and use Microsoft Word and Microsoft Excel templates
Work with Excel and Word templates

This brings us to the end of the PL-200 Microsoft Power Platform Functional Consultant Study Guide.

Follow Me to Receive Updates on PL-200 Exam

Share the PL-200 Study Guide in Your Network