Microsoft Power Platform Functional Consultant Training (PL-200)

This 4-day hands-on Microsoft Power Platform Functional Consultant training covers the four essential products within Power Platform: Power Apps, Power Automate, Power BI, and Power Virtual Agents, with an additional focus on Microsoft Dataverse, AI Builder, connectors, and portals.

You will learn to perform discovery, capture requirements, engage subject matter experts and stakeholders, translate requirements, and configure Microsoft Power Platform solutions and apps. In addition, the hands-on labs will allow you to create application enhancements, customise user experiences, systems integrations, data conversions, custom process automation, and custom visualisations.

PL-200 Delivery Methods

• In-Person

• Online

PL-200 Course Benefits

• Work with an organisation to gather requirements and implement Power Platform solutions

• Build model-driven, canvas, and portal apps
• Create Power Automate flows
• Design a simple chatbot using Power Virtual Agents

• Analyse data using Power BI visualisations and dashboards

PL-200 Training Outline

Important Course and Certification Information

Recommended Experience:

Attendees in this course should have experience with Power Platform at the level of Learning Tree Course 8571, Microsoft Power Platform Fundamentals Training (PL-900) , and:

• Experience as an IT professional or student.
• Working knowledge of Microsoft Power Platform and its key components.
• Knowledge of Microsoft Dataverse (or general data modelling) and security concepts.

Who should attend?

A Microsoft Power Platform Functional Consultant is responsible for creating and configuring apps, automation, and solutions. They act as the liaison between users and the implementation team. The functional consultant promotes the 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.

Exam Information

This class prepares an individual for Exam PL-200: Microsoft Power Platform Functional Consultant .

Module 1: Introduction to Microsoft Power Platform

In this Module, you will learn how to:

• Identify the key components of Microsoft Power Platform
• Describe the role of a functional consultant

Lessons

• Microsoft Power Platform overview

Lab: Validate lab environment

Module 2: The Functional Consultant role

In this Module, you will learn how to:

• Engage stakeholders with demos
• Create table (entity) relationship diagrams
• Design integrations
• Interact with consultant and customer organisation teams

Lessons

• Consultant skills overview
• Create and validate documentation
• Engage stakeholders
• Perform quality assurance
• Configure integrations

Module 3: Work with Dataverse

In this Module, you will learn how to:

• Understand tables, columns, rows, and relationships
• Configure a data model in Dataverse
• Work in an environment within the Microsoft Power Platform admin center

Lessons

• Work with the data model
• Create and manage processes
• Work with AI Builder
• Configure Dataverse settings
• Import and export data
• Use tabular reporting options
• Configure security settings

Lab: Create an app

Lab: Create tables and columns

Lab: Create relationships

Lab: Additional table options

Module 4: Make Power Apps

In this Module, you will learn how to:

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

Lessons

• Make model-driven apps
• Make canvas apps
• 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

Module 5: Build Power Automate flows

In this Module, you will learn how to:

• Create flows
• Create business process flows
• Understand UI flows

Lessons

• Build flows
• Build business process flows
• 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 a security role

Lab: Configure a new business rule

Lab: Advanced business rules

Module 6: Work with Power Virtual Agents

In this Module, you will learn how to:

• Create a chatbot
• Include a flow in a chatbot
• Create topics and entities

Lessons

• Create a chatbot
• Configure topics
• Automate and integrate
• Configure entities
• Test and publish chatbots

Lab: Create a chatbot

Module 7: Analyze data with Power BI

In this Module, you will learn how to:

• Create visualisations
• Consume data in Power BI
• Export data visualisations for stakeholders

Lessons

• Get started with Power BI
• Model data in Power BI
• Create visualisations
• Create dashboards
• 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