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