PL-200T00: Microsoft Power Platform Functional Consultant

5 Days - Online Instructor Lead

Course outline 

 

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. 

 

Lessons 

1. 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. Describe the role of a functional consultant 

 

Module 2: The Functional Consultant role 

 

In this module, students will learn more about the functional consultant role and the skills required to 

successfully implement a Microsoft Power Platform solution for an organization. 

 

Lessons 

1. Consultant skills overview

2. Create and validate documentation

3. Engage stakeholders 

4. Perform quality assurance 

5. Configure integrations 

 

After completing this module, students will be able to: 

Engage stakeholders with demos. Create table (entity) relationship diagrams. Design integrations. Interact with 

consultant and customer organization teams.

 

Module 3: Work 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. 

 

Lessons 

1. Work with the data model 

2. Create and manage processes 

3. Work with AI Builder 

4. Configure Dataverse settings 

5. Import and export data 

6. Use tabular reporting options

7. Configure security settings 

 

Lab : Create an app 

Lab : Create tables and columns 

Lab : Create relationships 

Lab : Additional table options 

 

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 4: Make Power Apps 

 

In this module, students will learn the business value of the three types of Power Apps. They will then learn to 

how to configure and design them, including user experience considerations for each type of application. 

 

Lessons 

1. Make model-driven apps

2. Make canvas apps

3. Make portal apps 

​

Lab : Build dashboards 

Lab : Modify views 

Lab : Modify forms 

Lab : App designer 

Lab : Canvas app fundamentals 

Lab : Work with data and services 

Lab : User experience 

 

After completing this module, students will be able to: 

Connect to data in Power Apps. Build a Power App. Design an application user experience 

​

Module 5: Build Power Automate flows 

 

In this module, students will learn how to automate business processes using Power Automate flows, business 

process flows, and UI flows. 

 

Lessons 

1. Build flows 

2. Build business process flows 

3. Build UI flows 

 

Lab : Build a business process flow 

Lab : Add branching to business process flow 

Lab : Build approval flow 

Lab : Create a flow 

Lab : Create users 

Lab : Create security role 

Lab : Configure a new business rule 

Lab : Advanced business rules 

 

After completing this module, students will be able to: 

Create flows. Create business process flows. Understand UI flows 

 

Module 6: Work with Power Virtual Agents 

 

In this module, students will learn how to automate customer interactions with a chatbot using Power Virtual 

Agents. 

 

Lessons 

1. Create a chatbot 

2. Configure topics 

3. Automate and integrate 

4. Configure entities 

5. Test and publish chatbots 

​

Lab : Create 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 7: 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 andcreate visualizations. 

 

Lessons 

1. Get started with Power BI 

2. Model data in Power BI

3. Create visualizations

4. Create dashboards 

5. Publish and share in Power BI 

 

Lab : Build a Word template 

Lab : Build an Excel template 

Lab : Import data 

Lab : Duplicate detection 

Lab : Export data 

Lab : Bulk delete 

 

After completing this module, students will be able to: 

Create visualizations. Consume data in Power BI. Export data visualizations for stakeholders.

 

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.  

​

Prerequisites 

Experience as an IT professional or student 

Working knowledge of Microsoft Power Platform and its key components 

Knowledge of Microsoft Dataverse (or general data modeling) and security concepts