PL-200 Microsoft Power Platform Functional Consultant Training

Topic 1 Describe the business value of the Microsoft Power Platform

• Explore Microsoft Power Platform
• Describe the business value of the Power Platform
• Explore connectors and Microsoft Dataverse
• Use Artificial Intelligence to increase productivity
• Explore the business value of the Power Fx
• Describe how Power Platform works with Microsoft 365 apps and services
• Explore how Power Platform works with Microsoft Teams
• Describe how Power Platform works with Microsoft Dynamics 365 apps
• Explore how Microsoft Power Platform apps work together
• Describe how Power Platform solutions consume Microsoft Azure services

Topic 2 Identify foundational components of Microsoft Power Platform

• Describe Power Platform administration
• Describe Power Platform security and governance
• Explore Microsoft Dataverse
• Examine Power Platform connectors
• Exercise - Build a basic Dataverse data model

Topic 3 Create and manage environments in Dataverse

• Environments in Microsoft Dataverse
• Developer environments
• Create and manage an environment
• Create an instance of a Microsoft Dataverse database
• Add users and roles within an environment
• Manage settings in an environment
• Environment operations

Topic 4 Create tables in Dataverse

• Introduction to Microsoft Dataverse
• Table characteristics
• Dataverse logic and security
• Dataverse auditing
• Dual-write vs. virtual tables

Topic 5 Create and manage columns within a table in Dataverse

• Define columns in Microsoft Dataverse
• Column types in Microsoft Dataverse
• Add a column to a table
• Primary name column
• Restrictions that apply to columns in a table
• Create an auto numbering column
• Create an alternate key

Topic 6 Working with choices in Dataverse

• Define choice column
• Choice columns
• Standard choices column

Topic 7 Create a relationship between tables in Dataverse

• Relate one or more tables - Introduction
• Relationship types that are available in Microsoft Dataverse
• Create a one-to-many relationship between tables
• Create a many-to-many relationship between tables
• Edit or delete relationships

Topic 8 Create and define calculation or rollup columns in Dataverse

• Introduction to roll up columns
• Create a rollup column
• Introduction to calculated columns
• Create a calculation column
• Introduction to Power Fx formula columns

Topic 9 Load/export data and create data views in Dataverse

• View data in a table
• Create or edit views of data in a table
• Dataverse data import options
• Load data into a table
• Dataverse data export options
• Export
• Add, update, or delete data in a table by using Excel
• Import data using Power Query

Topic 10 Get started with security roles in Dataverse

• Introduction to environment roles
• Understand environment roles
• Adding or disabling an environment user
• Understand security concepts in Dataverse
• Understand user security roles and security role defaults
• Check the roles that a user belongs to
• Configure Dataverse teams for security
• Configure Dataverse group teams for security

Topic 11 Use administration options for Dataverse

• Introduction to Microsoft Power Platform Admin Center portal
• Use Microsoft Power Platform Admin Center portal
• Tenant storage capacity
• Advanced Customization options in Power Apps Portal
• Dataverse Search
• Auditing
• Duplicate detection
• Bulk delete
• Long term data retention

Topic 12 How to build your first model-driven app with Dataverse

• Introduction to Dataverse
• Introduction to model-driven apps
• Model-driven apps, powered by Microsoft Dataverse
• Explore sample apps

Topic 13 Get started with model-driven apps in Power Apps

• Introducing model-driven apps
• Components of model-driven apps
• Design model-driven apps
• Incorporate business process flows

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

• Forms overview
• Form elements
• Configure multiple forms
• Use specialized form components
• Configure views overview
• Configure grids
• Create and edit views
• Configure charts overview
• Dashboards overview
• Use interactive streams and tiles

Topic 15 Use specialized components in a model-driven form

• Create business process flows
• Embed a canvas app in a model-driven form
• Add a timeline in a model-driven form
• Create a report in a model-driven form

Topic 16 Customize the command bar

• Create or edit modern commands
• Work with classic commands
• Use Power Fx

Topic 17 Get started with Power Apps canvas apps

• Introduction to Power Apps
• Start Power Apps
• Power Apps data sources
• Use Power Apps with Power Automate and Power BI
• Designing a Power Apps app

Topic 18 Customize a canvas app in Power Apps

• Improve your app by making basic customizations
• Explore controls and screens in canvas apps

Topic 19 Navigation in a canvas app in Power Apps

• Understanding navigation
• The Navigate and Back functions
• More ways to use the Navigate function

Topic 20 Create formulas to change behaviors in a Power Apps canvas app

• Formulas and functionality
• Understanding true and false
• Understanding control behaviors and actions
• Performing multiple actions in a formula
• Control the display mode through a formula
• Use controls and functions to create a dynamic formula

Topic 21 Connect to other data in a Power Apps canvas app

• Overview of the different data sources
• Work with action-based data sources
• Power Automate is a companion to Power Apps

Topic 22 Introduction to Power Apps cards

• Design Power Apps cards
• Send Power Apps cards

Topic 23 Core components of Power Pages

• Introduction to Power Pages
• Get started with Power Pages
• Core tools and components of Power Pages
• Overview of Power Pages security
• Overview of Power Pages extensibility

Topic 24 Access Dataverse in Power Pages websites

• Use lists to display multiple Dataverse records
• Use forms to interact with Dataverse data

Topic 25 Explore Power Pages design studio

• Get Started with Power Pages
• Work with Power Pages websites
• Introduction to Power Pages design studio
• Work with pages
• Page components
• Site styling and templates

Topic 26 Integrate Power Pages websites with Dataverse

• Basic form configuration
• Multistep form processes
• Set up multistep forms
• Extend lists and forms

Topic 27 Integrate Power Pages with web-based technologies

• Document management with SharePoint in Power Pages
• Integration with Power BI in Power Pages
• Model-driven charts in Power Pages

Topic 28 Explore Power Pages design studio data and security features

• Introduction into Power Pages design studio data and security features
• Data workspace in Power Pages design studio
• Power Pages security features

Topic 29 Set up Power Pages security

• Secure static content
• Table permissions

Topic 30 Authentication and user management in Power Pages

• Power Pages authentication settings
• User registration in Power Pages
• Authentication management for Power Pages users
• Power Pages authentication providers

Topic 31 Best practices for error handling in Power Automate flows

• Configure run after option
• Power Automate analytics

Topic 32 Use Dataverse triggers and actions in Power Automate

• Dataverse triggers
• Query data
• Create, update, delete, and relate actions

Topi 33 Introduction to expressions in Power Automate

• Get started with expressions
• Notes make things easier
• Types of functions
• Write complex expressions

Topic 34 Define and create business rules in Dataverse

• Define business rules - Introduction
• Define the components of a business rule
• Create a business rule

Topic 35 Set up low-code plug-ins

• Low-code plug-ins
• Create a low-code plug-in
• Instant plug-ins
• Automated plug-ins

Topic 36 Use common low-code plug-in scenarios

• Use Power Fx with plug-ins
• Implement data validation
• Data manipulation
• Use connectors in plug-in logic
• Use instant plug-ins from Power Apps
• Use instant plug-ins from Power Automate

Topic 37 Get started building with Power BI

• Use Power BI
• Building blocks of Power BI
• Tour and use the Power BI service

Topic 38 Introduction to solutions for Microsoft Power Platform

• Solution layering
• Solution architecture tools and techniques

Topic 39 Use Microsoft 365 services with model-driven apps and Microsoft Dataverse

• Set up mailboxes
• Server-side sync
• Document management options
• Document management
• Deploy the app for Outlook
• Set up Dynamics 365 App for Outlook
• Integrate with Microsoft Teams

Topic 40 Use Microsoft Word and Excel templates with Dataverse

• Create a dynamic Word template
• Create a dynamic Excel template

Practice Exam