Training: Microsoft Power Platform Functional Consultant (PL-200)

Module 1: 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

Module 2: Create tables in Dataverse

• Table characteristics
• Table relationships
• Dataverse logic and security
• Dataverse auditing
• Dual-write vs. virtual tables

Module 3: Manage tables in Dataverse

• Identify tables and table types in Dataverse
• Create a custom table
• Enable attachments within a table
• Licensing requirements for each table type

Module 4: 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 column
• Restrictions that apply to columns in a table
• Create an auto numbering column
• Create an alternate key

Module 5: Work with choices in Dataverse

• Define choice column
• Choice columns
• Standard choices column

Module 6: 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

Module 7: Connect to other data in a Power Apps canvas app

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

Module 8: Get started with security concepts in Dataverse

• Role-based security
• Business units
• Hierarchy security
• Table/record ownership
• Column-level security to control access
• Manage security across multiple environments

Module 9: Get started with security roles in Dataverse

• Understand environment roles
• Adding or disabling an environment user
• 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

Module 10: Use administration options for Dataverse

• 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

Module 11: Visualize data with Dataverse views

• Create and edit views in Power Apps maker portal
• Filter and sort data for Dataverse views

Module 12: Use Power Query to load data in Dataverse

• Import static data by using Power Query
• Import dynamic data by using Power Query

Module 13: Use Microsoft Word and Excel templates with Dataverse

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

Module 14: Export data from Dataverse and use Microsoft Excel to edit records

• Export data to Excel
• Edit and update data in Excel

Module 15: Use Azure and external tools to manipulate data

• Use Dataverse community tools for data manipulation
• Review Power BI integration with Dataverse

Module 16: 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

Module 17: Define and create business rules in Dataverse

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

Module 18: Create and define calculation or rollup columns in Dataverse

• Create a rollup column
• Create a calculation column

Module 19: 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

Module 20: 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

Module 21: Solution Architect series: Evaluate Power Platform analytics and AI

• Power Platform reporting capabilities
• Power BI overview
• Data requirements
• Power BI and Power Platform
• Dataflows
• AI

Module 22: Deploy and refine your app like a pro

• Publish the app
• Share the app
• Use QR codes
• Collect feedback and analyze telemetry

Module 23: Customize the command bar

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

Module 24: Get started with Power Apps canvas apps

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

Module 25: Customize a canvas app in Power Apps

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

Module 26: How to build the User Interface in a canvas app in Power Apps

• Use themes to quickly change the appearance of your app
• Brand a control
• Icons
• Images
• Personalization
• Build for phones or tablets

Module 27: Navigation in a canvas app in Power Apps

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

Module 28: Manage apps in Power Apps

• Review of managing Power Apps

Module 29: Build a mobile-optimized app from Power Apps

• Learn about mobile-optimized apps
• Identify components to make a canvas app mobile-optimized
• Create a mobile-optimized app that uses responsive designs
• Identify performance considerations for a mobile-optimized canvas app

Module 30: Navigation in a canvas app in Power Apps

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

Module 31: How to build the User Interface in a canvas app in Power Apps

• Use themes to quickly change the appearance of your app
• Brand a control
• Icons
• Images
• Personalization
• Build for phones or tablets

Module 32: Use and understand Controls in a canvas app in Power Apps

• Core properties of controls
• Entering and displaying data with text controls
• Additional controls for enhancing your app’s usability
• Media
• Modern controls
• Work with component libraries

Module 33: Document and test your Power Apps application

• Create test plans
• User interface testing
• Performance optimization
• Diagnostics and analytics
• Documentation and the customer

Module 34: Create formulas to change properties in a Power Apps canvas app

• Formulas overview
• Use a formula to modify the format of controls
• Use formulas to perform calculations
• Use a control to modify the property of other controls
• Conditional formatting
• Functions for validating data

Module 35: 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

Module 36: Author a basic formula that uses tables and records in a Power Apps canvas app

• Records and tables
• Using the Table function
• Store a table
• Filter your table
• Use the lookup function to return a record
• Additional table functions

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

• Formulas that process multiple records
• Math operations on tables
• Combine and separate records
• The ForAll function

Module 38: Use imperative development techniques for canvas apps in Power Apps

• Imperative versus declarative development
• The three types of variables in Power Apps
• Global variables
• Contextual variables
• Collections
• Additional variable concepts

Module 39: Explore Power Pages design studio

• Work with pages
• Page components
• Site styling and templates

Module 40: Explore Power Pages design studio data and security features

• Data workspace in Power Pages design studio
• Power Pages security features

Module 41: Work with Power Pages metadata

• Power Pages metadata
• Webpages
• Power Pages templates

Module 42: Explore Power Pages templates

• Site design templates
• Scenario-based templates
• Dynamics 365 Power Pages site templates

Module 43: Integrate Power Pages websites with Dataverse

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

Module 44: Work with Liquid template language in Power Pages

• Liquid basics
• Access Dataverse data
• Data security and Liquid

Module 45: Set up Power Pages security

• Secure static content
• Table permissions

Module 46: Access Dataverse in Power Pages websites

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

Module 47: Extend Power Pages websites

• Power Pages website life cycle management
• Extend with scripts
• Advanced CSS
• Advanced client-side development

Module 48: Power Pages administration

• Power Pages administrative tools
• Power Pages life cycle
• Set up essential features of a Power Pages website

Module 49: 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

Module 50: 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

Module 51: Power Pages maintenance and troubleshooting

• Power Pages website maintenance
• Power Pages website troubleshooting

Module 52: Best practices for error handling in Power Automate flows

• Configure run after option
• Power Automate analytics

Module 53: Introduction to expressions in Power Automate

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

Module 54: Use Dataverse triggers and actions in Power Automate

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

Module 55: Extend Dataverse with Power Automate

• Work with files and images
• Perform operations
• Search data
• Changesets

Module 56: Share a cloud flow with Power Automate

• Share by using co-ownership
• Share by using the run-only option
• Use the Send a copy feature
• Solutions and sharing

Module 57: Understanding Low Code as a Traditional Developer

• What is low code?
• Understand Power Fx

Module 58: Manage solutions in Power Apps and Power Automate

• Add and remove apps, flows, and entities in a solution
• Edit a solution-aware app, flow, and table
• Build and deploy a complex solution with flows, apps, and entities
• Automate solution management

Module 59: Introduction to solutions for Microsoft Power Platform

• Solution layering
• Solution architecture tools and techniques
• Use version control for solutions

Module 60: Create tables in Dataverse

• Table characteristics
• Table relationships
• Dataverse logic and security
• Dataverse auditing
• Dual-write vs. virtual tables

Module 61: 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

Module 62: Get started with Power Apps canvas apps

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

Module 63: Get started with Power Automate

• Introducing Power Automate
• Create your first flow
• Troubleshoot flows

Module 64: Challenge project – Build applications and automation solutions

• Prepare