

PL-200: Microsoft Power Platform Functional Consultant
Course Information

Course Name
PL-200: Microsoft Power Platform Functional Consultant

Exam code
PL-200

Duration
5 Days
Certification
Overview
This course will teach you to use Microsoft Power Platform solutions to simplify, automate, and empower business processes for organizations in the role of a Functional Consultant. 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. This course may contain a 1-day Applied Workshop. This workshop will allow you to practice your Functional Consultant skills by creating an end-to-end solution to solve a problem for a fictitious company. The solution will include a Microsoft Dataverse database, Power Apps canvas app, and Power Automate flows.
Audience Profile
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.
Prerequisites
- Experience as an IT professional or student
- Working knowledge of the Power Platform and its key components
- A knowledge of Microsoft Dataverse (or general data modeling) and security concepts
Course Outline
- Module 1: Create and manage environments in Dataverse
- Module 2: Create tables in Dataverse
- Module 3: Manage tables in Dataverse
- Module 4: Create and manage columns within a table in Dataverse
- Module 5: Working with choices in Dataverse
- Module 6: Load/export data and create data views in Dataverse
- Module 7: Connect to other data in a Power Apps canvas app
- Module 8: Get started with security concepts in Dataverse
- Module 9: Get started with security roles in Dataverse
- Module 10: Use administration options for Dataverse
- Module 11: Visualize data with Dataverse views
- Module 12: Use Power Query to load data in Dataverse
- Module 13: Use Microsoft Word and Excel templates with Dataverse
- Module 14: Export data from Dataverse and use Microsoft Excel to edit records
- Module 15: Use Azure and external tools to manipulate data
- Module 16: Create a relationship between tables in Dataverse
- Module 17: Define and create business rules in Dataverse
- Module 18: Create and define calculation or rollup columns in Dataverse
- Module 19: Configure forms, charts, and dashboards in model-driven apps
- Module 20: Use specialized components in a model-driven form
- Module 21: Solution Architect series: Evaluate Power Platform analytics and AI
- Module 22: Describe how to build applications with Microsoft Power Apps
- Module 23: Deploy and refine your app like a pro
- Module 24: Customize the command bar
- Module 25: Get started with Power Apps canvas apps
- Module 26: Customize a canvas app in Power Apps
- Module 27: How to build the User Interface in a canvas app in Power Apps
- Module 28: Navigation in a canvas app in Power Apps
- Module 29: Manage app versions, app sharing, and environments in Power Apps.
- Module 30: Build a mobile-optimized app from Power Apps
- Module 31: Navigation in a canvas app in Power Apps
- Module 32: How to build the User Interface in a canvas app in Power Apps
- Module 33: Use and understand Controls in a canvas app in Power Apps
- Module 34: Document and test your Power Apps application
- Module 35: Create formulas to change properties in a Power Apps canvas app
- Module 36: Create formulas to change behaviors in a Power Apps canvas app
- Module 37: Author a basic formula that uses tables and records in a Power Apps canvas app
- Module 38: Create formulas that use tables, records, and collections in a canvas app in Power Apps
- Module 39: Use imperative development techniques for canvas apps in Power Apps
- Module 40: Explore Power Pages design studio
- Module 41: Explore Power Pages design studio data and security features
- Module 42: Work with Power Pages metadata
- Module 43: Integrate Power Pages websites with Dataverse
- Module 44: Work with Liquid template language in Power Pages
- Module 45: Set up Power Pages security
- Module 46: Build user experience in Power Pages
- Module 47: Access Dataverse in Power Pages websites
- Module 48: Extend Power Pages websites
- Module 49: Build custom Power Pages web templates
- Module 50: Power Pages administration
- Module 51: Integrate Power Pages with web-based technologies
- Module 52: Authentication and user management in Power Pages
- Module 53: Power Pages maintenance and troubleshooting
- Module 54: Explore Power Pages templates
- Module 55: Best practices for error handling in Power Automate flows
- Module 56: Introduction to expressions in Power Automate
- Module 57: Use Dataverse triggers and actions in Power Automate
- Module 58: Extend Dataverse with Power Automate
- Module 59: Share a cloud flow with Power Automate
- Module 60: Understanding Low Code as a Traditional Developer
- Module 61: Manage solutions in Power Apps and Power Automate
- Module 62: Introduction to solutions for Microsoft Power Platform
- Module 63: Create tables in Dataverse
- Module 64: Get started with model-driven apps in Power Apps
- Module 65: Get started with Power Apps canvas apps
- Module 66: Get started with Power Automate
- Module 67: Challenge project – Build applications and automation solutions
Overview
Overview
This course will teach you to use Microsoft Power Platform solutions to simplify, automate, and empower business processes for organizations in the role of a Functional Consultant. 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. This course may contain a 1-day Applied Workshop. This workshop will allow you to practice your Functional Consultant skills by creating an end-to-end solution to solve a problem for a fictitious company. The solution will include a Microsoft Dataverse database, Power Apps canvas app, and Power Automate flows.
Audience Profile
Audience Profile
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.
Prerequisities
Prerequisites
- Experience as an IT professional or student
- Working knowledge of the Power Platform and its key components
- A knowledge of Microsoft Dataverse (or general data modeling) and security concepts
At Course Completion
Course Outline
Course Outline
- Module 1: Create and manage environments in Dataverse
- Module 2: Create tables in Dataverse
- Module 3: Manage tables in Dataverse
- Module 4: Create and manage columns within a table in Dataverse
- Module 5: Working with choices in Dataverse
- Module 6: Load/export data and create data views in Dataverse
- Module 7: Connect to other data in a Power Apps canvas app
- Module 8: Get started with security concepts in Dataverse
- Module 9: Get started with security roles in Dataverse
- Module 10: Use administration options for Dataverse
- Module 11: Visualize data with Dataverse views
- Module 12: Use Power Query to load data in Dataverse
- Module 13: Use Microsoft Word and Excel templates with Dataverse
- Module 14: Export data from Dataverse and use Microsoft Excel to edit records
- Module 15: Use Azure and external tools to manipulate data
- Module 16: Create a relationship between tables in Dataverse
- Module 17: Define and create business rules in Dataverse
- Module 18: Create and define calculation or rollup columns in Dataverse
- Module 19: Configure forms, charts, and dashboards in model-driven apps
- Module 20: Use specialized components in a model-driven form
- Module 21: Solution Architect series: Evaluate Power Platform analytics and AI
- Module 22: Describe how to build applications with Microsoft Power Apps
- Module 23: Deploy and refine your app like a pro
- Module 24: Customize the command bar
- Module 25: Get started with Power Apps canvas apps
- Module 26: Customize a canvas app in Power Apps
- Module 27: How to build the User Interface in a canvas app in Power Apps
- Module 28: Navigation in a canvas app in Power Apps
- Module 29: Manage app versions, app sharing, and environments in Power Apps.
- Module 30: Build a mobile-optimized app from Power Apps
- Module 31: Navigation in a canvas app in Power Apps
- Module 32: How to build the User Interface in a canvas app in Power Apps
- Module 33: Use and understand Controls in a canvas app in Power Apps
- Module 34: Document and test your Power Apps application
- Module 35: Create formulas to change properties in a Power Apps canvas app
- Module 36: Create formulas to change behaviors in a Power Apps canvas app
- Module 37: Author a basic formula that uses tables and records in a Power Apps canvas app
- Module 38: Create formulas that use tables, records, and collections in a canvas app in Power Apps
- Module 39: Use imperative development techniques for canvas apps in Power Apps
- Module 40: Explore Power Pages design studio
- Module 41: Explore Power Pages design studio data and security features
- Module 42: Work with Power Pages metadata
- Module 43: Integrate Power Pages websites with Dataverse
- Module 44: Work with Liquid template language in Power Pages
- Module 45: Set up Power Pages security
- Module 46: Build user experience in Power Pages
- Module 47: Access Dataverse in Power Pages websites
- Module 48: Extend Power Pages websites
- Module 49: Build custom Power Pages web templates
- Module 50: Power Pages administration
- Module 51: Integrate Power Pages with web-based technologies
- Module 52: Authentication and user management in Power Pages
- Module 53: Power Pages maintenance and troubleshooting
- Module 54: Explore Power Pages templates
- Module 55: Best practices for error handling in Power Automate flows
- Module 56: Introduction to expressions in Power Automate
- Module 57: Use Dataverse triggers and actions in Power Automate
- Module 58: Extend Dataverse with Power Automate
- Module 59: Share a cloud flow with Power Automate
- Module 60: Understanding Low Code as a Traditional Developer
- Module 61: Manage solutions in Power Apps and Power Automate
- Module 62: Introduction to solutions for Microsoft Power Platform
- Module 63: Create tables in Dataverse
- Module 64: Get started with model-driven apps in Power Apps
- Module 65: Get started with Power Apps canvas apps
- Module 66: Get started with Power Automate
- Module 67: Challenge project – Build applications and automation solutions
