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

Prepare to pass the PL-200: Microsoft Power Platform Functional Consultant Certification Exam

Course Description

This course will teach you to use Microsoft Power Platform solutions to simplify, automate, and empower business processes for organizations in the role of a Functional Consultant. A Microsoft Power Platform Functional Consultant is responsible for creating and configuring apps, automations, and solutions. They act as the liaison between users and the implementation team. The functional consultant promotes utilization of solutions within an organization. The functional consultant may perform discovery, engage subject matter experts and stakeholders, capture requirements, and map requirements to features. They implement components of a solution including application enhancements, custom user experiences, system integrations, data conversions, custom process automation, and simple visualizations. This course may contain a 1-day Applied Workshop. This workshop will allow you to practice your Functional Consultant skills by creating an end-to-end solution to solve a problem for a fictitious company. The solution will include a Microsoft Dataverse database, Power Apps canvas app, and Power Automate flows.

Audience Profile

A Microsoft Power Platform Functional Consultant is responsible for creating and configuring apps, automations, and solutions. They act as the liaison between users and the implementation team. The functional consultant promotes utilization of solutions within an organization. The functional consultant may perform discovery, engage subject matter experts and stakeholders, capture requirements, and map requirements to features. They implement components of a solution including application enhancements, custom user experiences, system integrations, data conversions, custom process automation, and simple visualizations.

About this Course

Course Outline

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

Duration

5 Days

Prerequisites

none

Level

Intermediate

Product

Power Platform

Role

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