Microsoft Power Platform Functional Consultant (PL-200T00)

1. Introduction to Microsoft Power Platform

   This lesson 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.
   1. Microsoft Power Platform overview
   2. On completing this lesson, you will have learned to:
      • Identify the key components of Microsoft Power Platform

2. Work with Dataverse

   In this lesson, 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.
   1. Work with tables
   2. Understand data types and behavior
   3. Configure security settings
   4. On completing this lesson, you will have learned to:
      • Understand tables, columns, rows, and relationships
      • Configure a data model in Dataverse
      • Work in an environment within the Microsoft Power Platform admin center

3. Make model-driven apps with Power Apps

   In this lesson, 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.
   1. Building blocks of model-driven apps
   2. Design model-driven apps
   3. Forms and views
   4. On completing this lesson, you will have learned to:
      • Connect to data in Power Apps
      • Build a Power Apps model-driven app
      • Design an application user experience

4. Make canvas apps with Power Apps

   In this lesson, 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.
   1. Power Apps studio
   2. Canvas apps capabilities
   3. User experience
   4. On completing this lesson, you will have learned to:
      • Build a Power Apps canvas app
      • Configure user experience in a canvas app
      • Understand the building blocks of a canvas app

5. Make portals with Power Apps

   In this lesson, 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.
   1. Power Apps portals architecture
   2. Access Microsoft Dataverse in your portal
   3. Authentication and user management
   4. On completing this lesson, you will have learned to:
      • Understand how to use Dataverse data in a portal
      • Recognize types of Power Apps portals for different audiences
      • Register users for portal access

6. Introduction to automation

   In this lesson, students will learn about business rules and when they can be used. Students will also get an overview of Power Automate.
   1. Business rules
   2. Power Automate overview
   3. On completing this lesson, you will have learned to:
      • Create users and grant security roles
      • Create and configure security roles
      • Create and configure advanced business rules

7. Build Power Automate cloud flows

   In this lesson, students will learn the fundamentals of cloud flows, including triggers and flows. They will create two flows, including an approval flow.
   1. Fundamentals of cloud flows
   2. Triggers
   3. Actions
   4. On completing this lesson, you will have learned to:
      • Create cloud flows
      • Understand the fundamentals of cloud flows
      • Use triggers and actions

8. Build Power Automate desktop flows

   In this lesson, 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.
   1. Build desktop flows
   2. Use desktop flows
   3. Process advisor
   4. On completing this lesson, you will have learned to:
      • Understand the value of desktop flows
      • Identify when to use desktop flows and how process advisor can help

9. Build business process flows

   In this lesson, 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.
   1. Why use business process flows
   2. Using business process flow designer
   3. Automating your business process flow
   4. On completing this lesson, you will have learned to:
      • Create business process flows
      • Use the business process flow designer
      • Know how to add automation to a business process flow

10. Build chatbots with Power Virtual Agents

    In this lesson, students will learn how to automate customer interactions with a chatbot using Power Virtual Agents.
    1. Create a chatbot
    2. Configure topics
    3. Automate and integrate
    4. Configure entities
    5. Test and publish chatbots
    6. On completing this lesson, you will have learned to:
       • Create a chatbot
       • Include a flow in a chatbot
       • Create topics and entities

11. Analyze data with Power Bi

    In this lesson, students will learn how to work with Power BI Desktop and Power BI Service to analyze data and create visualizations.
    1. Use tabular reporting options in Dataverse
    2. Use charts and dashboards in Dataverse
    3. Get started with Power BI
    4. Model data in Power BI
    5. Create visualizations and dashboards
    6. Publish and share in Power BI
    7. On completing this lesson, you will have learned to:
       • Create visualizations
       • Consume data in Power BI
       • Export data visualizations for stakeholders

12. Putting it all together

    In this lesson, 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.
    1. Using solutions
    2. AI Builder
    3. Consultant skills
    4. On completing this lesson, you will have learned 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

Course Labs

1. Validate lab environment
2. Create an app
3. Create tables and columns
4. Create relationships
5. Additional table settings
6. Modify views
7. Modify forms
8. App designer
9. Build a canvas app
10. Work with data and services
11. User experience
12. Configure a new business rule
13. Create security roles
14. Create users
15. Advanced business rules
16. Create a flow
17. Build an approval flow
18. Build a branching business process flow
19. Build a business process flow
20. Build a chatbot
21. Build charts
22. Build dashboards
23. Build delete data
24. Build a Word template
25. Build an Excel template
26. Duplicate detection
27. Import data
28. Export data