PL-200 Free Study Guide: Power Platform Functional Consultant
Free study guide for the Microsoft PL-200 Functional Consultant certification — exam domains, preparation strategy, and resources.
Exam Overview
The PL-200: Microsoft Power Platform Functional Consultant exam is a role-based certification that validates your ability to design, build, and deploy Power Platform solutions. Unlike PL-900 (which tests conceptual knowledge), PL-200 tests practical implementation skills. You need hands-on experience to pass this exam.
| Detail | Value |
|---|---|
| Exam code | PL-200 |
| Number of questions | 40-60 questions |
| Question types | Multiple choice, drag-and-drop, case studies, yes/no sets, hot area (click on diagram) |
| Duration | 100 minutes (plus time for case studies) |
| Passing score | 700 out of 1,000 |
| Cost | $165 USD (check Microsoft Learn for local pricing) |
| Certification earned | Microsoft Certified: Power Platform Functional Consultant Associate |
| Renewal | Annual renewal via free online assessment |
| Prerequisites | None formally, but PL-900 knowledge assumed |
| Recommended experience | 6-12 months hands-on with the Power Platform |
Who Should Take This Exam
- Power Platform practitioners who build solutions for organisations
- Functional consultants implementing Dynamics 365 and Power Platform
- Business analysts who configure (not just design) Power Platform solutions
- Anyone who has been building apps and flows for several months and wants to validate their skills
This exam expects you to know how to do things, not just what they are. You need to have actually built Canvas apps, Model-driven apps, cloud flows, and worked with Dataverse tables and security.
Skill Domains and Weightings
| Domain | Weight | Focus |
|---|---|---|
| Configure Microsoft Dataverse | 20-25% | Tables, columns, relationships, security, solutions |
| Create apps by using Power Apps | 20-25% | Canvas apps, Model-driven apps, design, UX |
| Create and manage Power Automate flows | 25-30% | Cloud flows, business process flows, desktop flows |
| Describe the capabilities of AI features | 10-15% | AI Builder, Copilot, generative AI integration |
| Describe integrations | 5-10% | Connectors, Dataverse APIs, Teams, SharePoint integration |
Domain-by-Domain Study Guide
Domain 1: Configure Microsoft Dataverse (20-25%)
This domain is critical. Dataverse is the foundation of most Power Platform solutions, and the exam tests detailed knowledge of configuration.
Tables and Columns
- Create standard and activity tables
- Understand table types: Standard, Activity, Virtual, Elastic
- Configure column types: text, number, date, choice, lookup, currency, calculated, rollup, formula
- Set column properties: required, searchable, audited, field security
- Know the difference between system columns and custom columns
- Understand primary name column and primary key (GUID)
Relationships
- Create one-to-many (1:N) relationships
- Create many-to-many (N:N) relationships
- Configure cascade behaviours: Assign, Share, Unshare, Reparent, Delete, Merge
- Understand relationship types: Referential, Restrict Delete, Cascade All, Custom
- Configure relationship mapping (auto-populate fields when creating related records)
Security
- Create and configure security roles
- Understand privilege depths: User, Business Unit, Parent-Child Business Unit, Organisation
- Configure field-level security profiles
- Understand business units and teams (Owner teams vs Access teams)
- Configure hierarchy security
- Know how security roles combine (union of permissions)
Solutions and ALM
- Create solutions, add components
- Understand managed vs unmanaged solutions
- Export and import solutions
- Configure solution publishers and prefixes
- Understand solution layering (active layer, managed layers)
- Know the solution upgrade vs update process
Views, Forms, and Charts
- Create and configure views (personal vs system)
- Configure model-driven app forms (main, quick create, quick view, card)
- Add business rules to forms (show/hide fields, set required, set default values)
- Create charts and dashboards
- Configure the command bar
Key study tip: Spend time in a Dataverse environment creating tables, columns, relationships, and security roles. The exam asks specific configuration questions that require hands-on familiarity.
Domain 2: Create Apps by Using Power Apps (20-25%)
Canvas Apps
- Design responsive layouts using containers
- Connect to data sources (SharePoint, Dataverse, SQL, Excel, custom connectors)
- Write Power Fx formulas for common patterns:
- Filtering and sorting galleries
- Patching records (create and update)
- Navigation between screens
- Validating input
- Error handling with IfError and Errors()
- Understand delegation and how to work within its limits
- Configure app settings (data row limit, formula bar, version)
- Share apps and manage permissions
- Use component libraries for reusability
Model-Driven Apps
- Create a model-driven app using the modern app designer
- Configure the sitemap (areas, groups, pages)
- Add tables, forms, views, and dashboards to the app
- Configure form layout: tabs, sections, columns, sub-grids, quick view forms
- Add business rules (no-code form logic)
- Embed Canvas app components (custom pages) within Model-driven apps
- Configure the command bar (ribbon) with Power Fx
Power Pages (Overview)
- Understand what Power Pages is (external-facing portal on Dataverse)
- Know when to use Power Pages vs Canvas vs Model-driven
- Basic awareness of page templates, lists, forms, and authentication
Key study tip: Build at least two apps — one Canvas and one Model-driven — against the same Dataverse table. This gives you practical understanding of the differences in how they connect to data, handle security, and present forms.
Domain 3: Create and Manage Power Automate Flows (25-30%)
This is the largest domain. The exam goes deep on flow design and troubleshooting.
Cloud Flows
- Create automated flows (triggered by events), instant flows (manual trigger), and scheduled flows
- Configure trigger conditions to control when flows run
- Use conditions, switch, apply to each, do until
- Configure parallel branches and run-after settings
- Write expressions using Workflow Definition Language:
- String functions: concat, substring, replace, split, toLower, toUpper
- Date functions: utcNow, addDays, formatDateTime, convertFromUtc
- Logical functions: if, equals, and, or, not, empty, coalesce
- Collection functions: first, last, length, contains, join
- Conversion functions: int, string, json, base64
- Use scopes for try/catch error handling
- Configure retry policies on actions
- Use child flows (call a flow from another flow)
- Implement approval workflows (sequential, parallel, custom responses)
Business Process Flows (BPFs)
- Create business process flows (guided multi-stage processes)
- Configure stages, steps, and branching conditions
- Understand how BPFs interact with Dataverse (create records, enforce stage gates)
- Know when to use a BPF vs a cloud flow
Desktop Flows (Overview)
- Understand what Power Automate Desktop (PAD) does
- Know the difference between attended and unattended desktop flows
- Understand when to use desktop flows (legacy app automation, web scraping, file manipulation)
- Basic awareness of PAD actions (UI automation, Excel, web recorder)
Process Mining (Overview)
- Understand what process mining is (analyse business processes from event logs)
- Know what task mining is (record user actions to discover processes)
- Know when to use process mining vs task mining
Key study tip: Build flows that include expressions, error handling, and approvals. The exam tests expression syntax specifically — know your formatDateTime format strings, your coalesce patterns, and how to safely navigate JSON with ? operators.
Domain 4: Describe the Capabilities of AI Features (10-15%)
AI Builder
- Pre-built models: Document processing (invoice, receipt, identity), text recognition (OCR), object detection, sentiment analysis, language detection, key phrase extraction, entity extraction
- Custom models: Prediction, category classification, object detection (training your own)
- Using AI Builder in Power Apps (AI components) and Power Automate (AI Builder actions)
- Understanding AI Builder credits and consumption
Copilot Features
- Copilot in Power Apps: describe an app in natural language, Copilot generates it
- Copilot in Power Automate: describe a flow, Copilot generates it
- Copilot in Dataverse: natural language to table creation
- Copilot Studio: building AI chatbots with topics and generative answers
- Understanding where Copilot adds value vs where manual configuration is better
Generative AI Integration
- Using GPT-based actions in Power Automate
- Creating AI prompts (prompt builder in AI Builder)
- Understanding responsible AI principles (fairness, transparency, privacy)
Key study tip: You do not need deep AI expertise, but you must know which AI Builder model to use for which scenario. “I need to extract data from invoices” = Document Processing. “I need to classify customer feedback” = Sentiment Analysis or Category Classification.
Domain 5: Describe Integrations (5-10%)
Connectors
- Standard vs Premium vs Custom connectors
- Creating custom connectors from OpenAPI definitions
- Using the HTTP connector for APIs without a dedicated connector
- Connection references and their role in solutions
Integration Patterns
- Dataverse Web API (overview — know it exists and what it does)
- Dataverse plug-ins (overview — know they are server-side extensions, C# code)
- Virtual tables (connect to external data sources as if they were Dataverse tables)
- Dual-write (Dataverse to Finance and Operations sync)
- Teams integration (embedding apps, posting from flows, using adaptive cards)
- SharePoint integration (document management in Model-driven apps)
Key study tip: This is the smallest domain. Focus on knowing the integration options and when to use each. You do not need to write Web API calls or build plug-ins for this exam.
Hands-On Lab Recommendations
The PL-200 requires practical knowledge. Here are specific exercises to build that knowledge:
Lab 1: Dataverse Schema Design
Create a “Project Management” solution with:
- Projects table (name, start date, end date, status choice, budget currency)
- Tasks table (name, due date, assigned to lookup, status choice, estimated hours)
- One-to-many relationship: Project has many Tasks
- Security roles: Project Manager (full access), Team Member (read Projects, own Tasks)
- Business rule: When Task status = “Complete”, set a completion date
Lab 2: Canvas App
Build a Canvas app for the Tasks table:
- Gallery screen showing tasks filtered by status
- Detail screen with an edit form
- New task screen with validation (due date must be in the future)
- Navigation between screens
- Delegation-friendly filtering
Lab 3: Model-Driven App
Build a Model-driven app for the same tables:
- Sitemap with Projects and Tasks areas
- Custom form for Projects with a sub-grid showing related Tasks
- Business process flow: Task lifecycle (New → In Progress → Review → Complete)
- Dashboard with a chart showing tasks by status
Lab 4: Power Automate Flows
Build these flows:
- Automated flow: When a Task is created, send a Teams notification to the assigned user
- Approval flow: When a Task moves to “Review”, request approval from the Project Manager
- Scheduled flow: Every Monday morning, send a summary email of overdue tasks
- Error handling: Add a Try scope around the email action with a Catch that logs failures
Lab 5: AI Builder Integration
- Add document processing to extract data from a sample invoice
- Use an AI prompt to summarise project status from task data
Free Study Resources
Microsoft Learn (Primary Resource)
- Learning path: “Microsoft Power Platform Functional Consultant” on Microsoft Learn
- Duration: Approximately 40-50 hours of content (significantly more than PL-900)
- Practice assessment: Free on Microsoft Learn — search “PL-200 practice assessment”
- Sandbox environments: Some modules include free sandbox environments for hands-on practice
Additional Free Resources
- Microsoft 365 Developer Programme: Free E5 developer tenant with Power Platform capabilities — essential for hands-on labs
- Power Platform documentation: Official docs for Dataverse, Power Apps, Power Automate
- Power Platform Community forums: Real-world questions and answers from practitioners
- Power CAT (Customer Advisory Team) resources: Best practices and reference architectures
- Dynamics 365 FastTrack resources: Solution design patterns and guidance
Study Plan: Four-Week Schedule
PL-200 requires more preparation than PL-900. Plan for 40-50 hours of study.
Week 1: Dataverse Deep Dive
| Day | Focus | Time |
|---|---|---|
| Day 1 | Tables, columns, data types | 2 hours |
| Day 2 | Relationships and cascade behaviours | 2 hours |
| Day 3 | Security roles, business units, teams | 2 hours |
| Day 4 | Solutions, ALM, managed vs unmanaged | 2 hours |
| Day 5 | Views, forms, business rules, charts | 2 hours |
| Day 6 | Lab 1: Build the Project Management schema | 3 hours |
| Day 7 | Review and reinforce Dataverse topics | 1 hour |
Week 2: Power Apps
| Day | Focus | Time |
|---|---|---|
| Day 8 | Canvas app design, containers, responsive layout | 2 hours |
| Day 9 | Power Fx formulas — filtering, patching, navigation | 2 hours |
| Day 10 | Delegation, data sources, performance | 2 hours |
| Day 11 | Lab 2: Build the Canvas app | 3 hours |
| Day 12 | Model-driven app designer, sitemap, forms | 2 hours |
| Day 13 | Lab 3: Build the Model-driven app | 3 hours |
| Day 14 | Power Pages overview + review | 1 hour |
Week 3: Power Automate and AI
| Day | Focus | Time |
|---|---|---|
| Day 15 | Cloud flows — triggers, actions, conditions | 2 hours |
| Day 16 | Expressions — string, date, logical, conversion | 2 hours |
| Day 17 | Error handling, scopes, retry policies, run-after | 2 hours |
| Day 18 | Approvals, child flows, business process flows | 2 hours |
| Day 19 | Lab 4: Build the Power Automate flows | 3 hours |
| Day 20 | AI Builder, Copilot features, Lab 5 | 2 hours |
| Day 21 | Desktop flows and process mining overview | 1 hour |
Week 4: Integration, Review, and Practice
| Day | Focus | Time |
|---|---|---|
| Day 22 | Connectors, custom connectors, integration patterns | 2 hours |
| Day 23 | Practice assessment (first attempt) | 2 hours |
| Day 24 | Review incorrect answers, revisit weak areas | 2 hours |
| Day 25 | Practice assessment (second attempt) | 2 hours |
| Day 26 | Review and lab any remaining weak topics | 2 hours |
| Day 27 | Light review, focus on areas with lowest practice scores | 1 hour |
| Day 28 | Rest before exam | — |
Total study time: Approximately 47 hours.
Exam Tips Specific to PL-200
Case Studies
PL-200 typically includes 1-2 case studies. Each presents a business scenario and asks 4-6 questions about how you would implement the solution. Tips:
- Read the entire case study before answering questions — the requirements often reference each other.
- Pay attention to specific constraints (budget, licences, security requirements, user count).
- Case study answers cannot be changed once you move past them — double-check before submitting.
Expression Questions
The exam will show you expressions and ask what they return, or describe a requirement and ask which expression achieves it. Know these patterns cold:
formatDateTime(utcNow(), 'yyyy-MM-dd')— date formattingcoalesce(triggerOutputs()?['body/field'], 'default')— null handlingif(equals(triggerOutputs()?['body/Status'], 'Active'), 'Yes', 'No')— conditional logicsplit(variables('Tags'), ';')— string to arrayfirst(body('Filter_array'))— get first matching item
Security Role Questions
Several questions will test your understanding of Dataverse security. Remember:
- Security roles are additive — if a user has two roles, they get the union of both roles’ permissions.
- Privilege depth matters: User = own records only; Business Unit = all records in their BU; Organisation = all records everywhere.
- Field-level security restricts by default — when you enable it on a column, only users in the field security profile can see it.
Common Distractors
- Power Pages: Questions may include Power Pages as a distractor option when the scenario is better suited to Canvas or Model-driven. Know when Power Pages is appropriate (external users, anonymous access, public-facing content).
- Desktop flows: Questions may suggest desktop flows when a cloud flow would suffice. Desktop flows are for legacy app automation, not for cloud API integration.
- Custom connectors vs HTTP connector: Custom connectors are reusable and shareable; HTTP connector is ad-hoc. If the scenario involves multiple flows using the same API, the answer is likely custom connector.
After the Exam
The PL-200 certification is an associate-level credential. It validates that you can implement Power Platform solutions professionally. Next steps:
| Path | Certification | Focus |
|---|---|---|
| Solution Architect | PL-600 | Designing enterprise Power Platform solutions |
| Developer | PL-400 | Code-first development (plugins, PCF, custom connectors) |
| RPA Specialist | PL-500 | Desktop automation with Power Automate Desktop |
| Dynamics 365 specialisations | MB-210, MB-220, MB-230, etc. | Specific Dynamics 365 app expertise |
PL-200 combined with PL-900 gives you a strong foundation. If you are building a career in the Power Platform ecosystem, PL-600 (Solution Architect Expert) is the pinnacle certification — but it requires significant real-world project experience beyond what any study guide can provide.