PL-200T00 Microsoft Power Platform Functional Consultant

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
• 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
• Describe how Power Platform solutions consume Microsoft Azure services
• Explore how Microsoft Power Platform apps work together

2 – Create tables in Dataverse

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

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
• Lab – Create a new custom table and enable attachments
• Check your knowledge

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
• Check your knowledge

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
• Check your knowledge

6 – Working with choices in Dataverse

• Define choice column
• Standard choices column
• Lab – Create a new choice or modify an existing choice
• Check your knowledge

7 – Get started with security roles in Dataverse

• 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
• Check your knowledge

8 – Use administration options for Dataverse

• Use Microsoft Power Platform Admin Center portal
• Tenant storage capacity
• Advanced Customization options in Power Apps Portal
• Enable and disable auditing
• Check your knowledge

9 – Manage Dynamics 365 model-driven app settings and security

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

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
• Check your knowledge

11 – Get started with model-driven apps in Power Apps

• Introducing model-driven apps
• Components of model-driven apps
• Design model-driven apps
• Check your knowledge

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
• Check your knowledge

13 – Get started with Power Apps canvas apps

• Power Apps building blocks
• Ways to build Power Apps
• Power Apps related technologies
• Additional Power Apps related technologies
• Designing a Power Apps app
• Check your knowledge

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
• Check your knowledge

15 – How to build the UI in a canvas app in Power Apps

• Use themes to quickly change the appearance of your app
• Branding a control
• Icons
• Images
• Personalization
• Using the tablet or phone form factors
• Check your knowledge

16 – Manage apps in Power Apps

• Power Apps review
• Check your knowledge

17 – 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
• Check your knowledge

18 – Access Dataverse in Power Pages websites

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

19 – 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
• Check your knowledge

20 – Power Pages maintenance and troubleshooting

• Power Pages website maintenance
• Power Pages website troubleshooting
• Check your knowledge

21 – Define and create business rules in Dataverse

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

22 – Get started with Power Automate

• Introducing Power Automate
• Troubleshoot flows
• Check your knowledge

23 – 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
• Check your knowledge

24 – Use Dataverse triggers and actions in Power Automate

• Dataverse triggers
• Use triggers
• Work with Dataverse actions
• Check your knowledge

25 – 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
• Check your knowledge

26 – Introduction to expressions in Power Automate

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

27 – 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
• Check your knowledge

28 – 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
• Check your knowledge

29 – 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
• Check your knowledge

30 – 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
• Check your knowledge

31 – 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
• Check your knowledge

32 – 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
• Check your knowledge

33 – 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
• Check your knowledge

34 – Get started building with Power BI

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

35 – 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
• Check your knowledge

36 – Model data in Power BI

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

37 – Use 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
• Check your knowledge

38 – Explore data in Power BI

• 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
• Check your knowledge

39 – Publish and share in Power BI

• 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
• Check your knowledge

40 – 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
• Check your knowledge

41 – 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
• Check your knowledge

42 – Get started with AI Builder

• Choose an AI capability
• Create your first model
• Ways to use your models
• Check your knowledge

43 – Manage models in AI Builder

• Model lifecycle
• Manage model versions
• Share your models
• Check your knowledge

44 – Use AI Builder in Power Automate

• AI Builder in Power Automate saves time
• Advanced usage of AI Builder in Power Automate
• Check your knowledge

45 – 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

46 – Solution Architect series: Plan application lifecycle management for Power Platform

• Key considerations for ALM
• Solutions
• Configuration and reference data
• Release process
• ALM with Azure DevOps
• Check your knowledge