PL-200T00: Microsoft Power Platform Functional Consultant

• Work with an organization to gather requirements and implement Microsoft Power Platform solutions
• Build model-driven, canvas, and portal apps
• Create Power Automate flows
• Design a simple chatbot using Power Virtual Agents
• Analyze data using Power BI visualizations and dashboards

• 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

If you are new to Power Platform, we’d recommend you to attend PL-900T00: Microsoft Power Platform Fundamentals to familiarize yourself with the business value and product capabilities of Power Platform.

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.

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

• 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: 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

• Work 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.

Lessons

• Building blocks of model-driven apps
• Design model-driven apps
• Forms and views

Lab : Modify views
Lab : Modify forms
Lab : App designer

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.

Lessons

• 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.

Lessons

• 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.

Lessons

• Business rules
• Power Automate overview

Lab : Configure a new business rule
Lab : Create security roles
Lab : Create users
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.

Lessons

• 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.

Lessons

• 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.

Lessons

• Why use business process flows
• Using business process flow designer
• Automating your business process flow

Lab : Build a branching business process flow
Lab : Build a 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.

Lessons

• 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.

Lessons

• 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 consultant 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.

Lessons

• 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 consultant skills

PL-100T00: Microsoft Power Platform App Maker

This Microsoft Certified Power Platform App Maker course will teach you how to build apps with low-code techniques to simplify, automate, and transform business tasks and processes using Microsoft Power Platform.

PL-300T00: Microsoft Power BI Data Analyst

This PL-300T00: Microsoft Power BI Data Analyst course will discuss the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI.

PL-400T00: Microsoft Power Platform Developer

In this Power Platform Developer training course, students will learn how to build Power Apps, Automate Flows and extend the platform to complete business requirements and solve complex business problems.

PL-500T00: Microsoft Power Automate RPA Developer

Candidates for this PL-500T00: Microsoft Power Automate RPA Developer course automate time-consuming and repetitive tasks by using Microsoft Power Automate. 

PL-600T00: Power Platform Solution Architect

In this course, students will learn about decisions a Solution Architect makes during an implementation, covering security, integrations, Power Apps architecture, Power Automate architecture, and more. 

The PL-200T00: Microsoft Power Platform Functional Consultant course prepares learners for the Microsoft Certified: Power Platform Functional Consultant Associate certification.

The PL-200 exam measures your ability to complete the following tasks: configure Microsoft Dataverse; create apps by using Microsoft Power Apps; create and manage Microsoft Power Automate; implement Microsoft Power Virtual Agents chatbots; integrate Microsoft Power Apps with other apps and services; and manage solutions.

Skills measured

• Configure Microsoft Dataverse (20-25%)
• Create apps by using Microsoft Power Apps (15-20%)
• Create and manage Microsoft Power Automate (15-20%)
• Implement Microsoft Power Virtual Agents chatbots (10-15%)
• Integrate Microsoft Power Apps with other apps and services (10-15%)
• Manage solutions (15-20%)

Your Guide to Power Platform Certifications in 2023

Do you love using Microsoft Power Platform to analyze data, build solutions, automate processes, and more? Have you considered earning your certification to validate your ability to support your team and organization with this technology? If you answered yes to either, read on!

Building Your Career with Microsoft Power Platform: The Ultimate Guide

In today's rapidly evolving technological landscape, professionals must continuously adapt and develop new skills to stay ahead of the curve. Microsoft Power Platform has emerged as a key player in the world of digital transformation, enabling organizations to build custom applications, automate processes, and harness the power of data analytics. 

Whether you're an IT professional, developer, or business analyst looking to expand your skill set, or a complete beginner seeking a career change, Microsoft Power Platform offers a wealth of opportunities to grow and thrive in the tech industry. 

Check out our ultimate guide to building a career with Power Platform.

What skills and knowledge are required to earn the Power Platform Functional Consultant Associate certification?

To earn the Power Platform Functional Consultant Associate certification, individuals must demonstrate skills in configuring and implementing solutions that use the Power Platform, including Power Apps, Power Automate, Power BI, and Dynamics 365.

What types of job roles or industries can benefit from earning the Power Platform Functional Consultant Associate certification?

The Power Platform Functional Consultant Associate certification can benefit individuals in various job roles and industries, including business analysts, functional consultants, project managers, and IT professionals.

Why get Microsoft Certified?

Getting Microsoft certified can provide numerous benefits for your career. Here are some insights and data that support the value of Microsoft certifications:

• Enhanced job prospects: According to Microsoft, 91% of hiring managers consider certification as a criterion for hiring, and 64% of IT hiring managers rate certifications as having high or medium value in validating the skills and expertise of job candidates.
• Increased earning potential: Microsoft certifications can lead to higher-paying job opportunities. 
• Improved professional credibility: Microsoft certifications demonstrate your expertise in specific technologies and products, providing validation of your skills and knowledge to potential employers, clients, and peers.
• Demonstrated commitment to professional development: Earning Microsoft certifications requires an investment of time and effort, demonstrating your commitment to professional development and staying up-to-date with the latest technologies and trends in your field.
• Staying up-to-date with the latest technologies: Microsoft certifications require you to stay up-to-date with the latest technologies and updates within specific products and technologies, helping you stay current with industry trends and technologies and giving you a competitive edge in your field.