Microsoft
Microsoft Business Apps
General
PL-200T00: Microsoft Power Platform Functional Consultant (PL-200T00)

Microsoft Power Platform empowers organizations to automate business processes, develop their own rich app experiences, and connect with customers better and faster. In this 5-day course, students will learn to perform discovery, capture requirements, engage subject matter experts and stakeholders, translate requirements, and configure Microsoft Power Platform solutions and apps. They will supplement their learnings with hands-on labs to create application enhancements, custom user experiences, system integrations, data conversions, custom process automation, and custom visualizations. Microsoft Power Platform is comprised of four key products: Power Apps, Power Automate, Power BI, and Power Virtual Agents. In this course, we will cover these four applications in depth, with additional focus on Microsoft Dataverse, AI Builder, connectors, and portals.

Download pdf
Duration: 5 Days
About the course

Prerequisites:

The knowledge and skills that the learner should have before attending this course are as follows:

  • 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

Course Objectives:

Upon completing this course, the learner will be able to meet these overall objectives:

  • 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
Course content

Module 1: Introduction to Microsoft Power Platform

  • Microsoft Power Platform overview

Module 2: The Functional Consultant Role

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

Module 3: Work with Dataverse

  • 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

Module 4: Make Power Apps

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

Module 5: Build Power Automate Flows

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

Module 6: Work with Power Virtual Agents

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

Module 7: Analyze Data with Power BI

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

Lab Outline:

Labs are designed to assure learners a whole practical experience, through the following practical activities:

  • Lab 1: Validate Lab Environment
  • Lab 2: Create an App
  • Lab 3: Create Tables and Columns
  • Lab 4: Create Relationships
  • Lab 5: Additional Table Options
  • Lab 6: App Designer
  • Lab 7: Modify Forms
  • Lab 8: Modify Views
  • Lab 9: Build Dashboards
  • Lab 10: Canvas App Fundamentals
  • Lab 11: Work With Data and Services
  • Lab 12: User Experience
  • Lab 13: Create Users
  • Lab 14: Create Security Role
  • Lab 15: Configure a New Business Rule
  • Lab 16: Advanced Business Rules
  • Lab 17: Create a Flow
  • Lab 18: Build Approval Flow
  • Lab 19: Build A Business Process Flow
  • Lab 20: Add Branching to Business Process Flow
  • Lab 21: Create a Chatbot
  • Lab 22: Build a Word Template
  • Lab 23: Build an Excel Template
  • Lab 24: Duplicate Detection
  • Lab 25: Import Data
  • Lab 26: Export Data
  • Lab 27: Bulk Delete
Who Should Attend

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.