Microsoft Certified: Power Platform Functional Consultant Associate

As a candidate for this certification, you work with an organization’s stakeholders and subject matter experts, such as solution architects, developers, and testers, to gather requirements and then implement Microsoft Power Platform solutions. You build model-driven, canvas, and portal apps. And you create Power Automate flows, design chatbots using Power Virtual Agents, and analyze data using Power BI visualization and dashboards. You even create application enhancements, custom user experiences, system integrations, data conversions, custom process automation, and custom visualizations.

As a functional consultant, use this certification to market yourself more effectively for projects and other engagements. The Microsoft Power Platform Functional Consultant Associate certification lets organizations know that—with no code or low code—you can build solutions that would normally require developer expertise.

Skills measured

Configure Microsoft Dataverse
Create apps by using Microsoft Power Apps
Create and manage Microsoft Power Automate
Implement Microsoft Power Virtual Agents chatbots
Integrate Microsoft Power Apps with other apps and services
Manage solutions

Course Outline

Manage a data model

assign a type for a table including standard, activity, or virtual
configure tables 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
create and configure views

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 Azure AD group teams

Create model-driven apps

create and configure forms
create and configure views
create and configure charts
create and configure dashboards
configure site maps
select applicable assets for an app including tables, forms, views, business process flows, dashboards, and charts
share a model-drive app
apply organizational branding by using themes

Create portal apps

create a portal app
expose Dataverse data
configure portal web pages, forms, and navigation
configure portal security including web roles and page access
configure portal details and actions
configure portal authentication Create flows
recommend types of flows and flow components including when to use a classic workflow
trigger a flow by using Dataverse connectors
run actions by using the Dataverse connector
implement logic control including branches, loops, conditions, error handling, and variables
implement dynamic content and expressions
test and troubleshoot flows

Build desktop flows

describe types of desktop flows
identify use cases for desktop flows including differentiating between attended and unattended desktop flows
build web and user interface automations by using Power Automate Desktop
implement variables, loops, and conditionals in Power Automate Desktop flows
trigger desktop flows from cloud flows
monitor automation runs
analyze processes by using Process Advisor

Create chatbots

create a standalone chatbot
add standalone chatbots to Teams and other channels
create a chatbot within a Microsoft Teams channel
publish a chatbot
share a chatbot
monitor and diagnose bot performance, usage, and topic usage
authenticate end users for a chatbot

Configure entities

create custom entities
implement entities in conversations
implement variables to store data Integrate Microsoft Power BI with Microsoft Power Platform components
create Power BI visualizations, reports, and dashboards
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

Configure and use templates

configure and use Microsoft Excel templates
configure and use Microsoft Word templates
configure and use email templates

Create a solution in a development environment

create solutions to contain solution assets
create a publisher
add assets to a solution
build solution-aware components
manage solution component dependencies

Create a solution in a development environment

create solutions to contain solution assets
create a publisher
add assets to a solution
build solution-aware components
manage solution component dependencies

About The Exam

This exam measures your ability to complete the following tasks: configure Microsoft Dataverse; create apps by using Microsoft Power Apps; create and manage Microsoft Power Automate; implement Microsoft Power Virtual Agents chatbots; and integrate Microsoft Power Apps with other apps and services.