PL-200 Course: Microsoft Power Platform Functional Consultant
In this course, you will learn to use Microsoft Power Platform solutions to simplify, automate, and enhance an organization's business processes in the role of a functional consultant. A Microsoft Power Platform functional consultant is responsible for building and configuring applications, automations, and solutions. They act as a liaison between users and the implementation team. The functional consultant promotes the use of solutions within an organization. They may also conduct discovery, engage subject matter experts and stakeholders, capture requirements, and map requirements to features. They implement solution components, including application enhancements, customized user experiences, system integrations, data conversions, custom process automation, and simple visualizations.
Online course with a free certification exam included. Don't miss this opportunity! The exam is valued at €126 + VAT and is included at no extra cost.
Promotion valid until June 30, 2026. One-opportunity exam available only in Virtual - E-learning format. Not applicable to Self-Learning format.
Level: Intermediate - Product: Microsoft Power Platform - Role: Functional Consultant
Course aimed at
A Microsoft Power Platform functional consultant is responsible for building and configuring applications, automations, and solutions. They act as a liaison between users and the implementation team. The functional consultant promotes the use of solutions within an organization. They may also conduct discovery, engage subject matter experts and stakeholders, capture requirements, and map requirements to features. They implement solution components, including application enhancements, customized user experiences, system integrations, data conversions, custom process automation, and simple visualizations.
Elements of the PL-200 training
- Introduction to Microsoft Power Platform
- Create tables in Dataverse
- Managing tables in Dataverse
- Test of knowledge on creating and managing columns in a table in Dataverse
- Create a relationship between tables in Dataverse
- Working with options in the Dataverse
- Introduction to security roles in the Dataverse
- Use the management options for Dataverse
- Manage the configuration and security of a Dynamics 365 model-based application
- Introduction to Microsoft Power Platform Security and Governance
- Introduction to model-driven apps in Power Apps
- Configure forms, charts, and dashboards in model-driven applications
- Introduction to Power Apps canvas apps
- Connect with other data in the Power Apps canvas application
- Creating the UI in a canvas app in Power Apps
- Application management in Power Apps
- Create your first app with Power Apps and Dataverse for Teams
- Main components of Power Pages
- Explore Power Pages templates
- Access to Dataverse in Power Apps portals
- Authentication and user management in Power Apps portals
- Power Apps portal maintenance and troubleshooting
- Define and create business rules in the Dataverse
- Introduction to Power Automate
- Using the Admin Center to manage environments and data policies in Power Automate
- Using Dataverse Triggers and Actions in Power Automate
- Expand Dataverse with Power Automate
- Introduction to Expressions in Power Automate
- Compile the first Power Automate desktop workflow
- Run Power Automate desktop workflow in unattended mode
- Optimize your business processes with Process Advisor
- Introduction to Power Virtual Agents bots
- Improve Power Virtual Agents bots
- Managing topics in Power Virtual Agents
- Manage Power Virtual Agents
- Introduction to compiling with Power BI
- Obtaining data with Power BI Desktop
- Data modeling in Power BI
- Using visuals in Power BI
- Data exploration in Power BI
- Publishing and sharing in Power BI
- Manage solutions in Power Apps and Power Automate
- Load and export data and create data views in Dataverse
- Introduction to AI Builder
- Manage models in AI Builder
- Using AI Builder in Power Automate
- Functional Consultant Skills
Course content PL-200: Microsoft Power Platform Functional Consultant
Module 1: Introduction to Microsoft Power Platform
This module will provide the learner with background about Microsoft Power Platform and its 4 key components: Power Apps, Power Automate, Power BI, and Power Virtual Agents.
Lesson
- Microsoft Power Platform overview
Lab: Validate lab environment
After completing this module, students will be able to:
- Identify the key components of Microsoft Power Platform
Module 2: Working with Dataverse
In this module, students will learn about creating a data model in Microsoft Dataverse, including importing data, using tabular reporting options, and configuring security. They will also learn about creating easy AI with AI Builder.
Lesson
- Working with tables
- Understand data types and behavior
- Configure security settings
Lab: Create an app
Lab: Create tables and columns
Lab: Create relationships
Lab: Additional table settings
After completing this module, students will be able to:
- Understand tables, columns, rows, and relationships
- Configure a data model in Dataverse
- Work in an environment within the Microsoft Power Platform admin center
Module 3: Make model-driven apps with Power Apps
In this module, students will learn the business value of Power Apps model-driven apps. They will then learn to how to configure and design them, including user experience considerations.
Lesson
- Building blocks of model-driven apps
- Design model-driven apps
- Forms and views
Lab: App designer
Lab: Modify forms
Lab: Modify views
After completing this module, students will be able to:
- Connect to data in Power Apps
- Build a Power Apps model-driven app
- Design an application user experience
Module 4: Make canvas apps with Power Apps
In this module, students will learn the business value of Power Apps canvas apps. They will then learn to how to configure and design them, including user experience considerations.
Lesson
- Power Apps Studio
- Canvas apps capabilities
- User experience
Lab: Build a canvas app
Lab: Work with data and services
Lab: User experience
After completing this module, students will be able to:
- Build a Power Apps canvas app
- Configure user experience in a canvas app
- Understand the building blocks of a canvas app
Module 5: Make portals with Power Apps
In this module, students will learn the business value of Power Apps portals. They will then learn to how to access Dataverse data in a portal and how portal authentication works.
Lesson
- Power Apps portals architecture
- Access Microsoft Dataverse in your portal
- Authentication and user management
After completing this module, students will be able to:
Understand how to use Dataverse data in a portal
Recognize types of Power Apps portals for different audiences
Register users for portal access
Module 6: Introduction to automation
In this module, students will learn about business rules and when they can be used. Students will also get an overview of Power Automate.
Lesson
- Business rules
- Power Automate overview
Lab: Create users
Lab: Create security roles
Lab: Configure a new business rule
Lab: Advanced business rules
After completing this module, students will be able to:
- Create users and grant security roles
- Create and configure security roles
- Create and configure advanced business rules
Module 7: Build Power Automate cloud flows
In this module, students will learn the fundamentals of cloud flows, including triggers and flows. They will create two flows, including an approval flow.
Lesson
- Fundamentals of cloud flows
- Triggers
- Actions
Lab: Create a flow
Lab: Build an approval flow
After completing this module, students will be able to:
- Create cloud flows
- Understand the fundamentals of cloud flows
- Use triggers and actions
Module 8: Build Power Automate desktop flows
In this module, students will learn what desktop flows are and how they are created. Students will also learn how desktop flows are used and how to use process advisor to better understand places to streamline workflows.
Lesson
- Build desktop flows
- Use desktop flows
- Process advisor
After completing this module, students will be able to:
- Understand the value of desktop flows
- Identify when to use desktop flows and how process advisor can help
Module 9: Build business process flows
In this module, students will learn the value of business process flows and how to use the business process flow designer. They will also practice building business process flows and learn how they can be automated.
Lesson
- Why use business process flows
- Using business process flow designer
- Automating your business process flow
Lab: Build a business process flow
Lab: Build a branching business process flow
After completing this module, students will be able to:
- Create business process flows
- Use the business process flow designer
- Know how to add automation to a business process flow
Module 10: Build chatbots with Power Virtual Agents
In this module, students will learn how to automate customer interactions with a chatbot using Power Virtual Agents.
Lesson
- Create a chatbot
- Configure topics
- Automate and integrate
- Configure entities
- Test and publish chatbots
Lab: Build a chatbot
After completing this module, students will be able to:
- Create a chatbot
- Include a flow in a chatbot
- Create topics and entities
Module 11: Analyze data with Power Bi
In this module, students will learn how to work with Power BI Desktop and Power BI Service to analyze data and create visualizations.
Lesson
- Use tabular reporting options in Dataverse
- Use charts and dashboards in Dataverse
- Get started with Power BI
- Model data in Power BI
- Create visualizations and dashboards
- Publish and share in Power BI
After completing this module, students will be able to:
- Create visualizations
- Consume data in Power BI
- Export data visualizations for stakeholders
Module 12: Putting it all together
In this module, students will learn how the concepts of this course pull together and how to use functional consulting skills on Microsoft Power Platform engagements. They will also learn how solutions are used in Microsoft Power Platform and will be introduced to AI Builder.
Lesson
- Using solutions
- AI Builder
- Consultant skills
Lab: Build charts
Lab: Build dashboards
Lab: Build delete data
Lab: Build a Word template
Lab: Build an Excel template
Lab: Duplicate detection
Lab: Import data
Lab: Export data
After completing this module, students will be able to:
- Understand how the concepts of this course work together
- Manage solutions in Microsoft Power Platform
- Use AI Builder to create and manage models
- Apply functional consulting skills
Prerequisites
-
Experience as an IT professional or student.
-
Practical knowledge of Microsoft Power Platform and its main components.
-
Knowledge of Microsoft Dataverse (or general data modeling) and security concepts
Language
- Course: English / Spanish
- Labs: English / Spanish
Official Microsoft Certification: Power Platform Functional Consultant Associate
Microsoft Certified: Power Platform Functional Consultant Associate
Demonstration of the use of Microsoft Power Platform solutions to simplify, automate, and enhance the business processes of organizations in the role of a functional consultant.
Level: Intermediate
Role: Functional Consultant
Product: Microsoft Power Platform
Subject: Business applications
