Microsoft Certified: Power Platform Functional Consultant Associate (PL200)

Microsoft Power Platform Functional Consultant (PL-200T00)

Module 1: Introduction to Microsoft Power Platform

• What is Microsoft Power Platform?
• The business value of Microsoft Power Platform
• Data Connectors
• Data loss prevention, compliance, privacy, and accessibility
• Pulling it all together

Module 2: Create tables in Dataverse

• Table characteristics
• Dual-write vs. virtual tables
• Dataverse auditing
• Import data into your Microsoft Dataverse database

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

Module 5: 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 6: Working with choices in Dataverse

• Define choice column
• Standard choices column

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

Module 8: 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
• Enable and disable auditing

Module 9: Manage Dynamics 365 model-driven app settings and security

• Configure role-based security
• Manage teams and business units
• Explore settings and customizations

Module 10: Introduction to Microsoft Power Platform security and governance

• Identify Microsoft Power Platform environments
• Data Loss Prevention policies
• Microsoft Power Platform Center of Excellence Starter Kit

Module 11: 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 12: 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
• Use specialty views
• Configure charts overview
• Dashboards overview
• Use interactive streams and tiles

Module 13: Get started with Power Apps canvas apps

• Introduction to Power Apps
• Power Apps building blocks
• Ways to build Power Apps
• Power Apps related technologies
• Additional Power Apps related technologies
• Designing a Power Apps app

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

Module 15: Manage apps in Power Apps

• Power Apps review

Module 16: Build your first app with Power Apps and Dataverse for Teams

• Create your first app with the hero template
• Customize your app with Power Apps Studio
• Publish your app
• Install template apps

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

Module 18: Explore Power Pages templates

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

Module 19: Access Dataverse in Power Apps portals

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

Module 20: Authentication and user management in Power Apps portals

• Power Apps portals authentication settings
• User registration in Power Apps portals
• Portal user authentication management
• Power Apps portals authentication providers

Module 21: Power Apps portals maintenance and troubleshooting

• Portal maintenance

Module 22: Define and create business rules in Dataverse

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

Module 23: Get started with Power Automate

• Introducing Power Automate
• Troubleshoot flows

Module 24: Use the Admin center to manage environments and data policies in Power Automate

• Administer flows
• Export and import flows
• Learn how to distribute button flows

Module 25: Use Dataverse triggers and actions in Power Automate

• Dataverse triggers
• Use triggers
• Work with Dataverse actions

Module 26: Extend Dataverse with Power Automate

• Set up a flow and configure its trigger
• Email Dataverse record
• Add to-do items
• Test and run your flow

Module 27: Introduction to expressions in Power Automate

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

Module 28: Build your first Power Automate for desktop flow

• Set up the environment
• Explore Power Automate for desktop
• Create your first Power Automate for desktop flow
• Record Power Automate for desktop actions
• Edit and test recorded actions

Module 29: Run a Power Automate for desktop flow in unattended mode

• Set up an unattended desktop flow
• Create a new cloud flow that calls an existing flow in unattended mode
• Perform a test run
• Best practices

Module 30: Optimize your business process with process advisor

• Get familiar with process advisor
• Create your first recording
• Edit recordings and group actions
• Analyze recordings and interpret results
• Automation recommendations

Module 31: Get started with Power Virtual Agents bots

• Get started working with environments
• Create bots and work with the Power Virtual Agents interface
• Create topics
• Test bots
• Publish bots and analyze performance

Module 32: Enhance Power Virtual Agents bots

• Use Power Automate to add actions
• Transfer conversations to agents by using Omnichannel for Customer Service
• Create topics for existing support content
• Analyze bot performance

Module 33: Manage topics in Power Virtual Agents

• Work with bot topics
• Branch a topic
• System topics
• Create topics for existing support content
• Work with system fallback topics
• Manage topics

Module 34: Manage Power Virtual Agents

• Environments in Power Virtual Agents
• Bot topics permissions
• Bot entities and flow permissions
• Monitor and diagnose
• Administer and manage
• Export and import bots
• Authentication

Module 35: Get started building with Power BI

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

Module 36: Get data with Power BI Desktop

• Overview of Power BI Desktop
• Explore Power BI Desktop
• Connect to data sources
• Get data from Excel
• Transform data to include in a report
• Combine data from multiple sources
• Clean data to include in a report

Module 37: Model data in Power BI

• Introduction to modeling your data
• How to manage your data relationships
• Create calculated columns
• Optimize data models
• Create measures
• Create calculated tables
• Explore time-based data

Module 38: Use visuals in Power BI

• Introduction to visuals in Power BI
• Create and customize simple visualizations
• Create slicers
• Map visualizations
• Matrices and tables
• Create scatter, waterfall, and funnel charts
• Modify colors in charts and visuals
• Page layout and formatting

Module 39: Explore data in Power BI

• Introduction to the Power BI service
• Quick insights in Power BI
• Create and configure a dashboard
• Ask questions of your data with natural language
• Create custom Q&A suggestions
• Share dashboards with your organization
• Display visuals and tiles in full screen
• Edit tile details and add widgets
• Get more space on your dashboard

Module 40: Publish and share in Power BI

• Introduction to using workspaces
• Publish Power BI Desktop reports
• Print and export dashboards and reports
• Introducing Power BI Mobile
• Create workspaces in Power BI
• Build apps
• Use apps
• Integrate OneDrive for Business with Power BI
• Publish to web

Module 41: 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 42: Load/export data and create data views in Dataverse

• View data in a table
• Create or edit views of data in a table
• Load data into a table
• Export data from a table
• Add, update, or delete data in a table by using Excel
• Import data using Power Query
• Generate a new dataflow from an Excel Template
• Dataflow and Azure integration

Module 43: Get started with AI Builder

• Introduction to AI Builder
• Choose an AI capability
• Create your first model
• Ways to use your models

Module 44: Manage models in AI Builder

• Model lifecycle
• Manage model versions
• Share your models

Module 45: Use AI Builder in Power Automate

• Introduction to AI Builder usage in Power Automate
• AI Builder in Power Automate saves time
• Advanced usage of AI Builder in Power Automate

Module 46: Functional Consultant skills

• Create entity relationship diagrams
• Create and document mock-ups
• Document functional requirements and artifacts
• Complete fit-gap analysis
• Discuss stakeholder management responsibilities
• Understand industry accelerators
• Define Application Lifecycle Management
• Participate in testing
• Evaluate options
• Define connectors
• Understand Power Apps component framework