PL-200: Power Platform Functional Consultant Associate

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.

MODULE 1
Describe the business value of the Microsoft Power Platform
MODULE 2
Identify foundational components of Microsoft Power Platform
MODULE 3
Create and manage environments in Dataverse
MODULE 4
Create tables in Dataverse
MODULE 5
Create and manage columns within a table in Dataverse
MODULE 6
Working with choices in Dataverse
MODULE 7
Create a relationship between tables in Dataverse
MODULE 8
Create and define calculation or rollup columns in Dataverse
MODULE 9
Load/export data and create data views in Dataverse
MODULE 10
Get started with security roles in Dataverse
MODULE 11
Use administration options for Dataverse
MODULE 12
How to build your first model-driven app with Dataverse
MODULE 13
Get started with model-driven apps in Power Apps
MODULE 14
Configure forms, charts, and dashboards in model-driven apps
MODULE 15
Use specialized components in a model-driven form
MODULE 16
Customize the command bar
MODULE 17
Get started with Power Apps canvas apps
MODULE 18
Customize a canvas app in Power Apps
MODULE 19
Navigation in a canvas app in Power Apps
MODULE 20
Create formulas to change behaviors in a Power Apps canvas app
MODULE 21
Connect to other data in a Power Apps canvas app
MODULE 22
Introduction to Power Apps cards
MODULE 23
Core components of Power Pages
MODULE 24
Access Dataverse in Power Pages websites
MODULE 25
Explore Power Pages design studio
MODULE 26
Integrate Power Pages websites with Dataverse
MODULE 27
Integrate Power Pages with web-based technologies
MODULE 28
Explore Power Pages design studio data and security features
MODULE 29
Set up Power Pages security
MODULE 30
Authentication and user management in Power Pages
MODULE 31
Best practices for error handling in Power Automate flows
MODULE 32
Use Dataverse triggers and actions in Power Automate
MODULE 33
Introduction to expressions in Power Automate
MODULE 34
Define and create business rules in Dataverse
MODULE 35
Set up low-code plug-ins
MODULE 36
Use common low-code plug-in scenarios
MODULE 37
Get started building with Power BI
MODULE 38
Introduction to solutions for Microsoft Power Platform
MODULE 39
Use Microsoft 365 services with model-driven apps and Microsoft Dataverse
MODULE 40
Use Microsoft Word and Excel templates with Dataverse
LEARNING PATH
Validate your Power Platform Functional Consultant skills

• Module 1: Create tables in Dataverse
• Module 2: Get started with model-driven apps in Power Apps
• Module 3: Get started with Power Apps canvas apps
• Module 4: Get started with Power Automate
• Module 5: Challenge project – Build applications and automation solutions

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.

Microsoft Certified: Power Platform Functional Consultant Associate after successful completion of the Exam PL-200: Microsoft Power Platform Functional Consultant