PL-200: Microsoft Power Platform Functional Consultant Associate - Comprehensive Fact Sheet¶

Exam Information¶

Exam Code: PL-200 Duration: 120 minutes Questions: 40-60 questions Passing Score: 700/1000 Cost: $165 USD Level: Intermediate/Functional Consultant

1. Configure Microsoft Dataverse (25-30%)¶

Dataverse Architecture and Tables¶

📖 What is Microsoft Dataverse? - Core concepts of Dataverse as a secure, cloud-based storage solution for business data

📖 Table Design Best Practices - Guidelines for creating and configuring tables (formerly entities) in Dataverse

📖 Standard vs Custom Tables - Differences between out-of-box standard tables and custom tables you create

📖 Table Ownership Types - Understanding User/Team owned, Organization owned, and Activity tables

📖 Virtual Tables - Creating tables that display data from external sources without storing it

📖 Elastic Tables - High-performance tables optimized for massive scale and NoSQL scenarios

Columns and Data Types¶

📖 Column Types Overview - Comprehensive guide to all column data types available in Dataverse

📖 Calculated Columns - Creating columns that automatically calculate values based on other columns

📖 Rollup Columns - Aggregating data from related records using rollup fields

📖 Choice Columns (Option Sets) - Creating global and local choice columns for standardized data entry

📖 Lookup Columns - Creating relationships between tables using lookup fields

📖 File and Image Columns - Storing files and images directly in Dataverse tables

📖 Currency Columns - Handling multi-currency scenarios in Dataverse applications

Relationships¶

📖 Table Relationships Overview - Creating and managing relationships between Dataverse tables

📖 One-to-Many Relationships - Configuring parent-child relationships between tables

📖 Many-to-Many Relationships - Setting up complex relationships with relationship tables

📖 Relationship Behavior - Understanding cascading behaviors for referential integrity

📖 Connection Roles - Creating flexible many-to-many relationships using connections

Business Rules¶

📖 Business Rules Overview - Creating no-code logic to enforce business logic on forms

📖 Business Rule Conditions - Defining conditions that trigger business rule actions

📖 Business Rule Actions - Available actions including show/hide, set values, recommendations

📖 Business Rule Scope - Understanding Entity vs All Forms scope for business rules

📖 Business Rules Best Practices - Performance and design recommendations for business rules

Data Management¶

📖 Import Data into Dataverse - Using import wizards and tools to load data

📖 Export Data from Dataverse - Exporting data to Excel and other formats

📖 Duplicate Detection Rules - Creating rules to prevent duplicate records

📖 Bulk Delete Jobs - Scheduling jobs to clean up old or unwanted records

📖 Data Import Wizard - Step-by-step guide to importing CSV and Excel files

Dataverse Advanced Features¶

📖 Alternate Keys - Creating alternate keys for external system integration

📖 Hierarchical Data - Configuring and querying self-referencing hierarchies

📖 Auditing - Enabling and managing audit logs for compliance

📖 Change Tracking - Tracking data changes for external synchronization

📖 Data Types and Field Properties - Understanding metadata and field-level properties

2. Create Model-Driven Apps (20-25%)¶

Model-Driven App Design¶

📖 Model-Driven Apps Overview - Understanding component-focused app design approach

📖 Create Model-Driven Apps - Step-by-step guide to building your first model-driven app

📖 App Designer - Using the modern app designer interface

📖 Site Map Designer - Configuring app navigation and menu structure

📖 App Properties - Setting app name, icon, description, and other properties

Forms¶

📖 Form Types - Main, Quick Create, Quick View, and Card forms explained

📖 Form Designer - Using the modern form designer to create and edit forms

📖 Form Columns and Sections - Adding, arranging, and configuring form columns

📖 Form Tabs and Sections - Organizing forms with tabs and sections

📖 Header and Footer Properties - Configuring form header and footer elements

📖 Quick Create Forms - Building lightweight forms for rapid data entry

📖 Quick View Forms - Displaying related record information on forms

📖 Form Properties - Configuring form-level settings and behaviors

📖 Form Script Events - Understanding OnLoad, OnSave, and other form events

Views¶

📖 View Types - Public, Personal, System, and Associated views

📖 Create and Edit Views - Building views to display filtered record lists

📖 View Filters - Creating complex filter criteria for views

📖 View Columns - Selecting and configuring columns to display in views

📖 Public Views - Creating views available to all users

Charts and Dashboards¶

📖 System Charts - Creating visual data representations on views

📖 Dashboard Overview - Building interactive dashboards with multiple visualizations

📖 System Dashboards - Creating organization-wide dashboards

📖 Interactive Dashboards - Building real-time, filterable dashboards for operations teams

📖 Dashboard Components - Adding charts, lists, web resources, and iFrames to dashboards

Business Process Flows¶

📖 Business Process Flows Overview - Guiding users through defined business processes

📖 Create Business Process Flows - Building multi-stage guided processes

📖 Business Process Flow Stages - Defining stages and steps in process flows

📖 Business Process Flow Branching - Creating conditional branches in processes

📖 Business Process Flow Actions - Triggering workflows from process stage changes

📖 Multi-entity Business Process Flows - Creating processes that span multiple tables

Commands and Controls¶

📖 Command Bar Customization - Customizing command buttons on forms and views

📖 Modern Command Designer - Using the new command designer interface

📖 Control Types - Available controls for enhanced user experience

3. Create Canvas Apps (15-20%)¶

Canvas App Fundamentals¶

📖 Canvas Apps Overview - Understanding pixel-perfect, experience-first app design

📖 Create Canvas App from Blank - Building a canvas app from scratch

📖 Create Canvas App from Data - Generating apps automatically from data sources

📖 Canvas App Design Principles - Best practices for user experience and performance

📖 Responsive Design - Creating apps that work across devices and screen sizes

Controls and Components¶

📖 Canvas App Controls - Reference for all available controls and their properties

📖 Gallery Control - Displaying lists and tables of data

📖 Forms in Canvas Apps - Using Edit and Display form controls

📖 Custom Components - Building reusable component libraries

📖 Component Libraries - Sharing components across multiple apps

Formulas and Functions¶

📖 Formula Reference - Complete Power Fx formula reference

📖 Variables in Canvas Apps - Using global, context, and collection variables

📖 Collections - Working with in-memory data collections

📖 Delegation in Canvas Apps - Understanding and working with delegation limits

📖 Filter and Lookup Functions - Querying and filtering data

Data Sources and Connections¶

📖 Connect to Data Sources - Adding connections to external data

📖 Dataverse in Canvas Apps - Connecting canvas apps to Dataverse

📖 SharePoint Integration - Working with SharePoint lists

📖 SQL Server Connection - Connecting to SQL databases

4. Create and Manage Power Automate (20-25%)¶

Cloud Flows¶

📖 Cloud Flows Overview - Understanding automated, instant, and scheduled flows

📖 Create Automated Flows - Building flows triggered by events

📖 Create Instant Flows - Creating manually triggered flows

📖 Create Scheduled Flows - Automating tasks on a schedule

📖 Flow Designer - Using the flow designer interface

Actions and Triggers¶

📖 Triggers in Power Automate - Understanding different trigger types

📖 Dataverse Triggers - When a row is added, modified, or deleted

📖 Actions Overview - Available actions for flow automation

📖 Dataverse Actions - Create, update, delete, and list rows

📖 Condition Actions - Using conditions and switch cases

📖 Apply to Each Loops - Iterating through arrays and lists

📖 Do Until Loops - Repeating actions until a condition is met

📖 Parallel Branch - Running actions simultaneously

Expressions and Dynamic Content¶

📖 Dynamic Content - Using outputs from previous actions

📖 Expression Functions - String, math, date, and logical functions

📖 Compose Action - Building and testing expressions

📖 Variables in Flows - Initialize, set, increment, and append to variables

📖 Parse JSON - Working with JSON data structures

Approvals and Notifications¶

📖 Approval Flows - Creating approval workflows

📖 Approval Types - Sequential, parallel, and custom approvals

📖 Send Email Notifications - Configuring email actions

📖 Teams Notifications - Posting messages to Microsoft Teams

📖 Adaptive Cards - Creating rich, interactive notifications

Error Handling and Monitoring¶

📖 Error Handling - Configure run after settings and scope actions

📖 Scope Actions - Grouping actions for error handling

📖 Flow Run History - Monitoring and troubleshooting flows

📖 Flow Analytics - Viewing flow performance and usage metrics

Connectors¶

📖 Connectors Overview - Browse all available connectors

📖 Standard vs Premium Connectors - Understanding connector licensing

📖 Custom Connectors - Creating connectors for proprietary APIs

📖 HTTP Connector - Making REST API calls

5. Integrate Power BI and AI Builder (10-15%)¶

Power BI Integration¶

📖 Power BI Overview - Understanding Power BI as an analytics platform

📖 Embed Power BI in Model-Driven Apps - Adding Power BI reports to forms and dashboards

📖 Power BI Dataverse Connection - Connecting Power BI to Dataverse data

📖 Power BI Reports in Canvas Apps - Embedding Power BI content in canvas apps

AI Builder¶

📖 AI Builder Overview - Adding AI capabilities to Power Platform solutions

📖 Prebuilt AI Models - Using ready-made models for common scenarios

📖 Document Processing - Extracting information from forms and documents

📖 Text Recognition (OCR) - Reading text from images

📖 Prediction Models - Creating custom prediction models

📖 AI Builder in Power Automate - Integrating AI models into flows

6. Implement Security and Data Loss Prevention (15-20%)¶

Security Roles and Permissions¶

📖 Security Concepts - Understanding role-based security in Power Platform

📖 Security Roles - Creating and managing security roles

📖 Privileges and Access Levels - Understanding Create, Read, Write, Delete, Append, and Assign privileges

📖 Predefined Security Roles - System Administrator, System Customizer, and other default roles

📖 Column-Level Security - Restricting access to sensitive fields

📖 Hierarchy Security - Manager and Position hierarchies for data access

Teams and Business Units¶

📖 Business Units - Organizing users and data by business structure

📖 Teams in Dataverse - Owner teams and access teams for collaboration

📖 Access Teams - Dynamic teams for record-level sharing

📖 Sharing Records - Manually sharing records with users and teams

Data Loss Prevention¶

📖 DLP Policies Overview - Preventing data leakage across connectors

📖 Create DLP Policies - Configuring data group classifications

📖 DLP Connector Classification - Business, Non-business, and Blocked connector groups

📖 DLP Impact Analysis - Understanding policy effects before enforcement

Environment Security¶

📖 Environments Overview - Managing multiple Power Platform environments

📖 Environment Security Groups - Restricting environment access with Azure AD groups

📖 Environment Admin Roles - Environment Admin vs System Administrator roles

7. Solutions and Application Lifecycle Management (10-15%)¶

Solutions¶

📖 Solutions Overview - Understanding solutions for packaging and deployment

📖 Managed vs Unmanaged Solutions - Key differences and when to use each type

📖 Create Solutions - Building solutions to contain components

📖 Add Components to Solutions - Including tables, apps, flows, and other components

📖 Solution Layers - Understanding customization layers and conflicts

📖 Solution Dependencies - Viewing and managing component dependencies

Application Lifecycle Management¶

📖 ALM Overview - End-to-end application lifecycle management

📖 Environment Strategy - Dev, test, and production environment planning

📖 Export Solutions - Packaging solutions for deployment

📖 Import Solutions - Deploying solutions to target environments

📖 Solution Patches - Creating incremental updates to managed solutions

📖 Solution Clone - Cloning solutions for new versions

Environment Variables and Connection References¶

📖 Environment Variables - Parameterizing solutions for different environments

📖 Connection References - Managing connector connections across environments

📖 Component Libraries in Solutions - Including reusable components in solutions

Deployment and Testing¶

📖 Solution Checker - Analyzing solutions for best practices and issues

📖 Test Studio - Creating automated tests for canvas apps

📖 Monitor and Troubleshoot - Debugging apps and flows in real-time

8. Additional Power Platform Features¶

Power Virtual Agents¶

📖 Power Virtual Agents Overview - Creating AI-powered chatbots without code

📖 Create Topics - Building conversation flows

📖 Trigger Phrases - Defining how users invoke topics

📖 Entities in PVA - Extracting information from user messages

📖 Call Power Automate from PVA - Integrating flows into chatbot conversations

Power Pages (Portals)¶

📖 Power Pages Overview - Creating external-facing websites connected to Dataverse

📖 Portal Templates - Starting with pre-built portal templates

📖 Portal Web Roles - Configuring portal user permissions

📖 Table Permissions - Controlling portal access to Dataverse data

Administration¶

📖 Power Platform Admin Center - Central hub for Power Platform administration

📖 Capacity and Licensing - Understanding database and file storage limits

📖 Backup and Restore - Protecting environment data

📖 Copy Environments - Duplicating environments for testing

9. Best Practices and Performance¶

Design Patterns¶

📖 Power Apps Patterns - Common design patterns and solutions

📖 Canvas App Performance - Optimizing canvas app performance

📖 Model-Driven App Performance - Best practices for model-driven apps

📖 Power Automate Performance - Flow optimization strategies

Governance¶

📖 Center of Excellence (CoE) Kit - Tools for governance and adoption

📖 Power Platform Governance - Establishing governance frameworks

📖 Naming Conventions - Standardizing component names

Exam Preparation Resources¶

Official Microsoft Resources¶

📖 PL-200 Exam Page - Official exam details and registration

📖 PL-200 Study Guide - Skills measured and exam objectives

📖 Microsoft Learn PL-200 Path - Free official training modules

📖 Power Platform Community Plan - Free development environment for practice

📖 Power Platform Documentation - Complete platform documentation

Hands-on Practice¶

📖 Power Apps Training Workshops - App in a Day and other workshops

📖 Power Automate Training - RPA in a Day workshop materials

📖 Sample Apps and Flows - Pre-built samples for learning

Key Functional Consultant Skills¶

Analysis and Requirements¶

• Gathering business requirements from stakeholders
• Translating business needs into technical solutions
• Creating functional specifications and design documents
• Identifying appropriate Power Platform components

Implementation¶

• Configuring Dataverse with tables, columns, and relationships
• Building model-driven apps with forms, views, and dashboards
• Creating canvas apps with responsive design
• Developing Power Automate flows for automation
• Implementing security roles and permissions

Testing and Deployment¶

• Performing user acceptance testing (UAT)
• Creating and managing solutions
• Deploying solutions across environments
• Documenting configurations and customizations

Training and Support¶

• Creating user documentation and training materials
• Conducting end-user training sessions
• Providing post-deployment support
• Managing change requests and enhancements

Common Exam Scenarios¶

Dataverse Configuration¶

• Design a data model with appropriate tables and relationships
• Configure security to restrict access to sensitive data
• Create business rules to automate data validation
• Set up duplicate detection to prevent data quality issues

App Development¶

• Build a model-driven app for data-intensive scenarios
• Create a canvas app for mobile field workers
• Design forms with tabs, sections, and business rules
• Configure views with filters and custom columns

Automation¶

• Create approval flows with multiple stages
• Build scheduled flows for data synchronization
• Implement error handling in complex flows
• Use AI Builder for document processing

Integration¶

• Connect Power Apps to SharePoint and SQL
• Embed Power BI reports in model-driven apps
• Create custom connectors for proprietary systems
• Integrate Dataverse with external applications

Security¶

• Design security model with business units and teams
• Configure column-level security for sensitive fields
• Implement DLP policies to prevent data leakage
• Set up environment security groups

ALM¶

• Package customizations into managed solutions
• Deploy solutions from dev to test to production
• Use environment variables for configuration
• Manage solution dependencies and layers

Exam Tips¶

1. Understand the functional consultant role - Focus on configuration over development
2. Know when to use model-driven vs canvas apps - Data-centric vs experience-first
3. Master security concepts - Privileges, access levels, business units, teams
4. Practice building solutions - Hands-on experience is critical
5. Understand ALM concepts - Solutions, environments, deployment strategies
6. Know connector types - Standard vs premium licensing implications
7. Study business process flows - Multi-entity flows and branching logic
8. Learn Power Automate expressions - Dynamic content and functions
9. Understand delegation - Canvas app performance and data limits
10. Review DLP policies - Governance and compliance requirements

Total Embedded Links: 200+ documentation references

This comprehensive fact sheet covers all PL-200 exam domains with extensive official Microsoft documentation links to support your certification preparation. Focus on hands-on practice and understanding business scenarios to succeed as a Power Platform Functional Consultant.