PL-200: Microsoft Power Platform Functional Consultant

Microsoft Certified: Power Platform Functional Consultant Associate

Are you a functional consultant, data analyst, or developer looking to hone your consulting and configuration skills, or solution architect on a path to the solution architect certification? Or maybe you’re an IT professional with knowledge and experience configuring Microsoft Power Platform. If this describes you and you’re familiar with using Power Platform components to extend and customize Microsoft apps and services such as Teams, Dynamics 365, Excel, and Word, explore how the Microsoft Power Platform Functional Consultant Associate certification can help enhance your career and make you a key member of your team. This certification indicates to the world that you’re considered qualified to build and implement solutions that use Power Apps, Power BI, and Power Virtual Agents.

As a candidate for this certification, you work with an organization’s stakeholders and subject matter experts, such as solution architects, developers, and testers, to gather requirements and then implement Microsoft Power Platform solutions. You build model-driven, canvas, and portal apps. And you create Power Automate flows, design chatbots using Power Virtual Agents, and analyze data using Power BI visualization and dashboards. You even create application enhancements, custom user experiences, system integrations, data conversions, custom process automation, and custom visualizations.

As a functional consultant, use this certification to market yourself more effectively for projects and other engagements. The Microsoft Power Platform Functional Consultant Associate certification lets organizations know that—with no code or low code—you can build solutions that would normally require developer expertise.

Course Outline

Configure Microsoft Dataverse (20–25 %)

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 apps by using Microsoft Power Apps (15–20 %)

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 and manage Microsoft Power Automate (15–20 %)

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

Implement Microsoft Power Virtual Agents chatbots (10–15 %)

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 Apps with other apps and services (10–15 %)

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

Manage solutions (15–20%)

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

Duration

5 Days

Build An In-house Team Of Cloud Experts With Dedicated Courses!

Learn fundamental to advanced skills using Azure, Microsoft 365, and related business applications. Meet with a Microsoft Certified Training Specialist to design a custom learning plan for your organization!