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

Microsoft Certified: Microsoft Power Platform Functional Consultant Associate

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

At Course Completion

Course Outline

• Get started using Dataverse

• 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

• Manage permissions and administration for Dataverse

• 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

• Visualize, import, and export Microsoft Dataverse data

• 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

• Create relationships, business rules, calculations, and rollups in Dataverse

• 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

• Advanced Model-Driven Apps with Power Apps: Configuration, Customization, and Deployment Techniques

• 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

• Create a canvas app in Power Apps

• 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

• Use the UI and controls in a canvas app in 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

• Use basic formulas to make better Power Apps canvas apps

• 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

• Advanced Canvas App Development in Power Apps: Mastering Formulas and Development Techniques

• 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

• Work with Power Pages websites

• 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

• Extend Power Pages

• Module 47: Access Dataverse in Power Pages websites

• Module 48: Extend Power Pages websites

• Module 49: Build custom Power Pages web templates

• Administer Power Pages

• 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

• Mastering Power Platform Essentials: Templates, Error Handling, and Expressions in Power Automate

• 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

• Integrate Power Automate flows and Dataverse

• Module 57: Use Dataverse triggers and actions in Power Automate

• Module 58: Extend Dataverse with Power Automate

• Power Platform Solution Management: Sharing, Customization, and Low-Code Development Essentials

• 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

• Validate your Power Platform Functional Consultant skills

• 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

All Microsoft certification courses are conducted by certified trainers from Iverson.

Digital Methods acts as the official training partner and assists with program consultation, registration, coordination, scheduling, and administrative arrangements to ensure a seamless and professionally managed training experience.