PL-200: Microsoft Power Platform Functional Consultant

Manage a data model
• create or modify standard, activity, or virtual tables
• configure tables 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
• create and configure views

Create and manage business logic
• define requirements for business rules
• define and implement business rule logic
• define the scope for business rules
• configure and test business rules
• configure a synchronous classic workflow

Configure Dataverse
• configure Dataverse Search
• configure auditing
• perform data management tasks including import, export, and bulk detection
• configure duplicate detection settings
• configure privacy preferences

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 Azure AD group teams

Create model-driven apps
• create and configure forms
• create and configure views
• create and configure charts
• create and configure dashboards
• configure site maps
• select applicable assets for an app including tables, forms, views, business process flows, dashboards, and charts
• share a model-driven app
• apply organizational branding by using themes

Create canvas apps
• create a canvas app
• configure Dataverse as a data source for an app
• create canvas app screens
• implement form navigation, formulas, variables and collections, and error handling
• build reusable components and component libraries
• configure offline capabilities for apps
• run Power Automate flows based on actions that occur in a canvas app
• interpret App Checker and resolve identified issues including accessibility issues
• manage an app
• monitor app analytics data

Create portal apps
• create a portal app
• expose Dataverse data
• configure portal web pages, forms, and navigation
• configure portal security including web roles and page access
• configure portal details and actions
• configure portal authentication

Create cloud flows

• recommend types of flows and flow components including when to use a classic workflow
• trigger a flow by using Dataverse connectors
• run actions by using the Dataverse connector
• 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 business rules, workflows, flow steps, and action steps to a business process flow
• define stages and steps
• configure parallel branches
• manage the business process flow table for a business process flow

Build desktop flows

• describe types of desktop flows
• identify use cases for desktop flows including differentiating between attended and unattended desktop flows
• build web and user interface automations by using Power Automate Desktop
• implement variables, loops, and conditionals in Power Automate Desktop flows
• trigger desktop flows from cloud flows
• monitor automation runs
• analyze processes by using Process Advisor

Create chatbots

• create a standalone chatbot
• add standalone chatbots to Teams and other channels
• create a chatbot within a Microsoft Teams channel
• publish a chatbot
• share a chatbot
• monitor and diagnose bot performance, usage, and topic usage
• authenticate end users for a chatbot

Configure topics

• define topic conversation triggers
• create questions, messages, and conditions
• extract topics from a web page
• implement greetings, escalations, error messages, and statuses
• call a Power Automate flow to run an action
• configure a fallback topic

Configure entities

• create custom entities
• implement entities in conversations
• implement variables to store data

Integrate Microsoft Power BI with Power Platform components
• create Power BI visualizations, reports, and dashboards
• 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

Implement AI Builder
• determine which AI Builder model type to use
• create an AI Builder model
• prepare source data for use by models
• train, test, and publish a model
• consume a model by using Power Apps
• consume a model by using Power Automate

Configure and use templates
• configure and use Microsoft Excel templates
• configure and use Microsoft Word templates
• configure and use email templates

Create a solution in a development environment
• create solutions to contain solution assets
• create a publisher
• add assets to a solution
• build solution-aware components
• manage solution component dependencies

Transport solutions between environments
• resolve connection references
• set environment variables
• export solutions
• import solutions
• update solutions
• configure managed properties
• run Power Apps Checker and interpret results

Localize solutions
• configure currencies
• enable language packs
• export and import translations