Microsoft Power Platform Functional Consultant

This 5-day course is for those who want to learn about the Power Platform Functional Consultant role.

You will learn to perform discovery, capture requirements, engage subject matter experts and stakeholders, translate requirements, and configure Power Platform solutions and apps. The training includes labs to create application enhancements, custom user experiences, system integrations, data conversions, custom process automation, and custom visualizations.

The details for this course are taken from

You will receive digital access to the Microsoft course materials.

Module 1: Introduction to the Power Platform

This module provides with background information and overview about the Power Platform and key components: Power Apps, Power Automate, Power BI, and Power Virtual Agents.


  • Validate lab environment

Module 2: The Functional Consultant role

In this module, you will learn more about the functional consultant role and the skills required to successfully implement a Power Platform solution for an organization.

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

After completing this module you 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.

  • 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


  • Create an app
  • Create tables and columns
  • Create relationships
  • Additional table options

After completing this module you will be able to:

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

Module 4: Make Power Apps

This module describes the business value of the three types of Power Apps and how to configure and design them, including user experience considerations for each type of application.

  • Make model-driven apps
  • Make canvas apps
  • Make portal apps


  • App designer
  • Modify forms
  • Modify views
  • Build dashboards
  • Canvas app fundamentals
  • Work with data and services
  • User experience

After completing this module you 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

This module shows how to automate business processes using Power Automate flows, business process flows, and UI flows.

  • Build flows
  • Build business process flows
  • Build UI flows


  • Create users
  • Create security role
  • Configure a new business rule
  • Advanced business rules
  • Create a flow
  • Build approval flow
  • Build a business process flow
  • Add branching to business process flow

After completing this module you will be able to:

  • Create flows
  • Create business process flows
  • Describe UI flows

Module 6: Work with Power Virtual Agents

In this module you will learn how to automate customer interactions with a chatbot using Power Virtual Agents.

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


  • Create a chatbot

After completing this module you will be able to:

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

Module 7: Analyze data with Power BI

This module describes how to work with Power BI Desktop and Power BI Service to analyze data and create visualizations.

  • Get started with Power BI
  • Model data in Power BI
  • Create visualizations
  • Create dashboards
  • Publish and share in Power BI


  • Build a Word template
  • Build an Excel template
  • Duplicate detection
  • Import data
  • Export data
  • Bulk delete

After completing this module you will be able to:

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

Contact Details

Expert CRM Services
Ground Floor, Unit 1, The Exchange
9 Station Road, Stansted
CM24 8BE
01279 263646 Contact us