PL-200T00: Microsoft Power Platform Functional Consultant

Course Description

This course will teach you to use Microsoft Power Platform solutions to simplify, automate, and empower business processes for organizations in the role of a Functional Consultant. A Microsoft Power Platform Functional Consultant is responsible for creating and configuring apps, automations, and solutions. They act as the liaison between users and the implementation team. The functional consultant promotes utilization of solutions within an organization. The functional consultant may perform discovery, engage subject matter experts and stakeholders, capture requirements, and map requirements to features. They implement components of a solution including application enhancements, custom user experiences, system integrations, data conversions, custom process automation, and simple visualizations.

Who Should Attend?

A Microsoft Power Platform Functional Consultant is responsible for creating and configuring apps, automations, and solutions. They act as the liaison between users and the implementation team. The functional consultant promotes utilization of solutions within an organization. The functional consultant may perform discovery, engage subject matter experts and stakeholders, capture requirements, and map requirements to features. They implement components of a solution including application enhancements, custom user experiences, system integrations, data conversions, custom process automation, and simple visualizations.

Configure Microsoft Dataverse (20–25%)
Create apps by using Microsoft Power Apps (15–20%)
Create and manage process automation (20–25%)
Describe Microsoft Power Virtual Agents (10–15%)
Import and visualize data by using dataflows and Power BI (10–15%)
Define an environment strategy (10–15%)

Configure Microsoft Dataverse (20–25%)

Manage a data model

Create or modify standard, activity, or virtual tables
Configure table ownership
Create new tables or modify existing tables
Determine which type of relationships to implement including 1:N and N:N
Configure table relationship behaviors including cascading rules
Create new relationships or modify existing relationships
Create new columns or modify existing columns
Create alternate keys for tables
Configure table properties
Configure connection roles

Configure Dataverse

Configure Dataverse search
Configure auditing
Perform data management tasks including import, export, and bulk deletion
Configure duplicate detection settings

Configure security settings

Create and manage business units
Create and manage security roles
Create and manage users and teams
Create and manage column security
Configure hierarchy security
Configure Microsoft Azure Active Directory (Azure AD) group teams
Manage sharing
Diagnose security issues

Create apps by using Microsoft Power Apps (15–20%)

Create model-driven apps

Create and configure multiple form types
Use specialized form components
Create and configure views
Determine which reporting options to use including embedding Microsoft Power BI or using Fetch-based reports
Configure site maps and compose model-driven apps
Share a model-driven app
Configure custom pages
Create and configure business rules
Configure modern commanding

Define use cases for canvas apps

Identify when to use a canvas app
Describe canvas app structure
Describe form navigation, formulas, variables and collections, and error handling
Run Microsoft Power Automate flows based on actions that occur in a canvas app

Build Microsoft Power Pages

Configure pages, forms, and navigation
Configure advanced Power Pages features
Configure website security including web roles and page access
Describe use cases for templates
Implement registration options

Create and manage process automation (20–25%)

Create cloud flows

Describe types of flows, use cases, and flow components including when to use a classic workflow
Describe common connectors, triggers, and actions
Implement logic controls including branches, loops, conditions, error handling, and variables
Implement dynamic content and expressions
Test and troubleshoot flows

Create and manage business process flows

Configure a business process flow
Add stages, workflows, and action steps to a business process flow
Manage the business process flow table for a business process flow
Configure advanced logic

Create classic workflows

Configure a workflow
Troubleshoot workflows
Manage workflow logs

Describe Microsoft Power Virtual Agents (10–15%)

Identify use cases for Power Virtual Agents

Identify chatbot environments
Describe chatbot skills and AI capabilities
Identify options for security

Identify components of Power Virtual Agents

Describe topics
Describe entities
Identify use cases for fallback topics

Import and visualize data by using dataflows and Power BI (10–15%)

Consume Power BI in Microsoft Power Platform

Add Power BI tiles to model-driven apps and canvas apps
Add canvas apps to a Power BI dashboard
Trigger Power Automate flows from Power BI alerts
Use Power BI in Power Pages

Create and use dataflows

Import data to Dataverse using Power Query
Schedule dataflow runs
Describe Power Fx

Define an environment strategy (10–15%)

Participate in Application Lifecycle Management (ALM)

Describe use cases for App checker and Solution checker
Create and manage solutions
Describe the difference between managed and unmanaged solutions

Describe interoperability with other services

Add apps to Microsoft Teams
Create Teams channels
Identify when to use the on-premises data gateway

Experience as an IT professional or student
Working knowledge of Microsoft Power Platform and its key components
Knowledge of Microsoft Dataverse (or general data modeling) and security concepts

This will be a virtual event hosted on Microsoft Teams. In the Microsoft Teams platform and sessions, your name, email address, or title may be viewable by other participants. By joining this event, you agree to this experience. 