PL-200 : Microsoft Power Platform Functional Consultant

To attend this training, it is recommended to have previously completed the training “PL-900: Microsoft Power Platform Fundamentals”. Practical experience with Power Platform and its key components, as well as Common Data Service and security concepts, is advised.

It is strongly recommended to take this course on a computer with a dual monitor setup for greater comfort.

Create and manage environments in Dataverse

• Identify the different environments that are in Dataverse
• Create and manage environments in Dataverse
• Create a DB instance in Dataverse
• Add users and security roles to a Dataverse environment
• Determine where to manage settings for an environment

 

Create tables in Dataverse

• Create tables with Dataverse
• Import data into a Dataverse database

 

Manage tables in Dataverse

• Tables in Dataverse
• Types of tables available in Dataverse
• Creating a custom table
• Enabling attached documents within a table
• The licensing criteria to be applied for each type of table

 

Create and manage columns within a table in Dataverse

• What a column is in Dataverse
• The types of columns available in Dataverse
• Add a column to a table
• What is a Master Name Column in Dataverse
• Identify restrictions associated with columns
• Create an AutoNumber column
• Create a subkey

 

Use choices in Dataverse

• Explore the choices
• Explore Standard Choices
• Create an election or modify an existing election

 

Load/export data and create data views in Dataverse

• Display data in a table
• Create or modify data views in a table
• Load data into a table
• Export data from a table
• Add, update, or delete data from a table using Excel
• Import data using Power Query into Maker Portal
• Generate a data flow from an Excel template
• Explore data feeds

 

Connect to other data in a Power Apps canvas app

• Understand and use action-based connectors;
• Embed user information and user profile information in a canvas app;
• Use Power Automate with Power Apps.

 

Get started with security concepts in Dataverse

• Different security models available in Dataverse and how they apply to back up data
• Manage user and team security roles and their impact on data access and permissions
• Profit Centers and Their Role in Structuring Security in a Dataverse Environment
• Field-level security and their role in protecting sensitive data
• Ownership of recording, sharing, and how these mechanisms control access to data

 

Get started with security roles in Dataverse

• Learn about security roles and apply them to users in an environment
• Learn how to add users to an environment
• Understand security concepts in Dataverse
• Identify default security roles
• Create a custom role
• Create a custom security role and assign it to entities and users
• Set up Dataverse security teams
• Set up dedicated Dataverse security group teams

 

Use admin options for Dataverse

• Administer Dataverse
• Identify the different portals available for Dataverse

 

Visualize data with Dataverse views

• Learn about the different types of Dataverse views
• Create and edit views
• Use filters and sorting criteria

 

Load data into Dataverse using Power Query

• Understand the different categories of data sources available when using Power Query
• Import data into a Dataverse table using Power Query
• Understand the different refresh options available

 

Use Microsoft Word and Excel templates with Dataverse

• Use Word templates with Dataverse data
• Use Excel templates with Dataverse data

 

Export data from Dataverse and edit records using Microsoft Excel

• Export data from Dataverse to Excel files
• Learn about the different types of exported files
• Learn about security concepts for exported data

 

Manipulate data using Azure and external tools

• Learn about the capabilities of Azure Synapse Link for Dataverse
• Learn how Dataverse community tools make it easy to manipulate data
• Learn how Power BI services and tools relate to Dataverse

 

Create a relationship between tables in Dataverse

• Why segment the data used by your solutions into multiple tables
• Why associate one table with another
• Establish relationships between tables
• Select the appropriate relationship type when you build solutions with Dataverse

 

Define and create business rules in Dataverse

• Define business rules in Dataverse
• Create and manage business rules in Dataverse

 

Create and define calculation or rollup columns in Dataverse

• Define a cumulative column
• Create a cumulative column
• Identify a calculation column
• Create a calculation column
• Define a Formula Column

 

Configure forms, charts, and dashboards in model-driven apps

• Work with form elements and controls
• Configure forms
• Use specialized form components
• Use editable grids
• Identify views and use public views
• Configure charts
• Set up dashboards

 

Use specialized components in a model-driven form

• Learn about other components of a template-driven form
• Create a business process flow
• Integrate a canvas app with a template-driven form
• Add a timeline in a template-driven form
• Create a report in a template-driven form

 

Evaluate Power Platform analytics and AI capabilities

• Learn about planning and needs assessment
• Learn more about operational reporting
• Explore the capabilities of Microsoft Power BI and learn how to use it with Power Platform components
• Use predefined information and custom AI

 

Deploy and fine-tune your app like a pro

• Deploy your app and allow users to discover it;
• Gather feedback and usage information so you can refine your app.

 

Customize the command bar

• Create or edit modern orders
• Use classic commands
• Using Power Fx
• Customize Orders

 

Get started with Power Apps canvas apps

• Learn how Power Apps can make your business more efficient
• Perform different tasks in Power Apps using different technologies
• Create an app in Power Apps in different ways
• Create your first app from data in an Excel workbook

 

Customize a canvas app in Power Apps

• Change the layout of a gallery
• Change the data displayed by a control
• Edit a Form control to display different data fields
• Explore Gallery and Form controls
• Add a screen
• Edit label properties using basic formulas
• Add labels
• Create basic on-screen navigation

 

Create the UI of a canvas app in Power Apps

• Understand the fundamentals of creating the UI through themes, icons, customizing controls, and images
• Use personalization in a canvas app
• Preview and modify an app to fit different form factors

 

Navigate a canvas app in Power Apps

• Understanding the Navigate and Back functions
• Use screen transitions in an app
• Preview and edit an app to fit various form factors
• Gain hands-on experience in creating navigation elements in an app
• Use other controls for app navigation

 

Manage apps in Power Apps

• View and restore versions of an app
• Share an app, including permissions and notifications
• Learn what environments are, how to create them, and how to manage security

 

Build a mobile-optimized app from Power Apps

• Learn about the concept of a mobile-optimized app
• Learn about the components of a mobile-optimized canvas app
• Create a mobile-optimized canvas app
• Review performance considerations in a canvas app
• Monitor the performance of a canvas app

 

Use and understand controls in a canvas app in Power Apps

• Use controls in a canvas app
• Use the different types of controls
• Understand how galleries and forms relate to controls

 

Document and test your Power Apps app

• Learn about the different types of test plans and the components of a good test plan
• Identify and review optimization tools and performance tuning
• Discover the benefits of documenting your application

 

Create formulas to change properties in a Power Apps canvas app

• Understand the basics of working with formulas in a canvas app
• Change the format of a date control
• Perform simple mathematical calculations using a formula
• Change the position of an icon using a formula
• Implement conditional formatting in canvas apps by using a formula.

 

Create formulas to change behaviors in a Power Apps canvas app

• Understanding true and false values
• Control the Visible property with a formula
• Control the DisplayMode property with a formula
• Combine formulas in a single statement

 

Create a basic formula that uses tables and records in a Power Apps canvas app

• Understand tables and records in Power Apps
• Create multi-column tables using Collect and ClearCollect
• Add a collection as a data source to a gallery
• Filter your data table
• Use the LookUp feature

 

Create formulas that use tables, records, and collections in a canvas app in Power Apps

• Use formulas that process multiple records
• Combine text from multiple records using the Concat feature
• Use CountRows, CountIf, and ForAll functions
• Perform mathematical operations on data in a table

 

Use Developer Imperative techniques for canvas apps in Power Apps

• Understand the difference between imperative and declarative expansion
• Understand Power Apps variables
• Find out when to use each of the three types of variables

 

Explore Power Pages Design Studio

• Launch and run the Power Pages design studio
• Identify different workspaces, commands, and tools
• Add new pages, place them in the site structure, and style the site’s appearance
• Learn about the process of setting up specific layouts and adding and editing different types of content on a page.
• Identify where to add or edit custom HTML or CSS code on web pages using the Design Studio

 

Explore the data management and security features of the Power Pages design studio

• Learn about the Data workspace, Dataverse data modeling, and table permissions in the Power Pages design studio;
• Extend the Dataverse data model and add connected data components to your page
• Learn how to secure access to a page
• Identify where to add table permissions to secure business data

 

Use Power Pages metadata

• Review the various Power Pages metadata records and how they allow you to configure specific aspects of a website
• Learn about the Portal Management template-driven app and how it allows you to configure specific aspects of a Power Pages website
• Learn about the structure of a web page record and the various components that allow you to display a web page and content in multiple languages
• Review the page template and web template structure and how they apply consistent layouts and functionality on a web page

 

Explore Power Pages templates

• Identify scenario-based patterns to speed up your site creation
• Explore Dynamics 365 template capabilities
• Review generic site design patterns designed to meet unique business needs
• Discover the blank template as a simple starting point to create a site to your exact specifications

 

Integrate Power Pages websites with Dataverse

• Configure lists to display Dataverse data in different ways and allow website users to interact with it using a variety of techniques
• Implement forms to allow creation, reading, and updating of Dataverse rows
• Create a multi-step form process to enable complex and actionable data entry
• Trigger classic Dataverse workflows from the website
• Combine the different components of Power Pages to create powerful web applications

 

Use the Liquid template language in Power Pages

• Learn about the Liquid template language and how to use it in Power Pages
• Interpret Liquid syntax and write Liquid code
• Differentiate between Liquid tags, objects, and filters
• View Dataverse data using FetchXML

 

Set up Power Pages security

• Learn about the relationship between Dataverse contacts and website users
• Identify the various website security metadata entities such as contacts, web roles, web page access control rules, and table permissions
• Restrict access to web pages by using web page access control rules
• Configure table permissions to secure Dataverse and Dynamics 365 records

 

Access Dataverse in Power Pages websites

• Learn about the Power Pages components available to view and interact with Dataverse data on the Power Pages website
• Identify the various features of Power Pages components
• View a list of data and a related drill down list for details
• Configure a form to access individual table rows
• Trigger classic Dataverse workflows from the website

 

Extend Power Pages websites

• Discover where software development can solve particular website functionality needs
• Use the Lifecycle Management (ALM) app for Power Pages websites
• Apply JavaScript code to website resources
• Use Cascading Style Sheets (CSS) to meet specific website development requirements

 

Administer Power Pages

• Identify the various actions and features of the Microsoft Power Platform admin center for setting up a Power Pages website
• Learn about the lifecycle of a Power Pages website
• Manage SSL certificates and custom domain names
• Differentiate between key features such as website visibility, maintenance mode, and IP address restriction

 

Integrate Power Pages with web technologies

• Learn how the Iframe component allows you to link with other cloud-based technologies
• Set up website integration with SharePoint document libraries
• Embed Power BI reports on a Power Pages page
• Enhance a website page with template-driven graphics

 

Authenticate and manage users in Power Pages

• Explore common authentication tasks in a Power Pages website deployment
• Explore website contact extensions
• Set up and register contacts as website users
• Align website authentication settings with business needs
• Identify the authentication provider’s capabilities and the steps involved in enrollment
• Select and configure identity providers

 

Perform Power Pages maintenance and troubleshoot

• Apply strategies and techniques to troubleshoot Power Pages website issues
• Learn how Site Checker works and how to troubleshoot any website issues
• Complete the process of updating a website

 

Know best practices for handling errors in Power Automate flows

• Get insights into settings options for flow actions
• Learn about the Configure Run After option
• Handle errors using the Configure Run After option
• Explore Microsoft Power Automate analytics

 

Discover expressions in Power Automate

• Create expressions using one or more functions;
• Retrieve data, modify data, evaluate data, and more using functions.

 

Use Dataverse triggers and actions in Power Automate

• Dataverse triggers and actions in Power Automate
• Other Entries Available

 

Extend Dataverse with Power Automate

• Work with files and images stored in Dataverse columns
• Perform related and unrelated transactions
• Search Dataverse data from a cloud feed
• Create or modify Dataverse data in a transaction using change sets

 

Share a cloud feed with Power Automate

• Learn about the ways to share a cloud feed and the benefits of each method
• Find out who you can share cloud feeds with
• Learn about the differences in sharing different types of cloud feeds
• Learn how connections are handled when you share cloud feeds
• Discover the different sharing options using co-ownership
• Learn about run-only permissions
• Learn about the differences between solution-based and non-solution-based cloud flow sharing

 

Understanding Low Code as a Traditional Developer

• Understand what Power Fx is and how to use it
• Create an app using Power Apps
• Edit an app using Power Fx

 

Manage solutions in Power Apps and Power Automate

• Package existing elements in a solution
• Creating solutions
• Modify existing solution-enabled flows and applications in a solution
• Import and export solutions
• Deploy complex solutions with many components
• Discover component dependency on other components

 

Explore solutions for Microsoft Power Platform

• Learn about solutions and how they work
• Explore the concept of solution overlay
• Explore version control for solutions

 

Create tables in Dataverse

• Create tables with Dataverse
• Import data into a Dataverse database

 

Get started with model-driven apps in Power Apps

• Build model-driven applications
• Create a model-driven app

 

Get started with Power Apps canvas apps

• Learn how Power Apps can make your business more efficient
• Perform different tasks in Power Apps using different technologies
• Create an app in Power Apps in different ways
• Create your first app from data in an Excel workbook

 

Get started with Power Automate

• Create a flow that automatically saves email attachments
• Create a button flow to send you a reminder

 

Build automation apps and solutions

• Assessing needs
• Perform a gap analysis of existing assets
• Create the necessary assets from the stated requirements
• Compose applications and automation solutions

Last updated: 08/08/2025

In this training, we mix theory with technical workshops to quickly make you operational. Additionally, each participant receives course materials at the end of the training.

One of our consultant trainers conducts the training. With solid field experience, they make the learning process both interactive and enriching.

For assessment, the trainer regularly asks questions and uses various methods to continuously measure your progress. This approach promotes a dynamic and engaging learning experience.

After the training, we ask you to complete a satisfaction questionnaire. Your feedback helps us to maintain and constantly improve the quality of our training.

Finally, we offer the flexibility to deliver this training both in-person and remotely, and it can be customized to meet your company’s specific needs upon request.

 

This training prepares you for the Microsoft certification exam “PL-200: Power Platform Functional Consultant.” We recommend registering for the exam approximately one month after completing the training. The course materials and labs provided during the training will help you properly review for your certification.

You can register for certification on the Microsoft site. If you would like to buy a certification voucher from us, or if you would like us to support you in this process, please contact us

You can register for one of our training courses up to two business days before it starts, if there are still available places and you signed quote.

If you have specific needs related to a disability, please do not hesitate to make a request; we are happy to adjust our services according to the type of disability.