Skip to content
CBT Nuggets
DemoBook a Demo

Microsoft Certified: Power Platform Functional Consultant Associate (PL-200)

Microsoft Power Platform

Associate · Business end-user

This Microsoft Power Platform Functional Consultant (PL-200) training prepares learners to build, automate and integrate tailored solutions using Microsoft Power Platform. Master Power Automate and Power BI to create custom apps, streamline workflows, and analyze data. Use low-code tools to design tailored solutions that automate operations and sharpen decision-making. Microsoft retired the PL-200 exam on 31 August 2026, so the course is assigned today for the Power Platform consulting skills it builds.

Microsoft retired the PL-200 exam on . This course is still available, and the skills it teaches remain valuable. See current Microsoft training: all Microsoft certifications.

Updated August 2026

9Skills
47Videos
7hTotal

Who This Course Is For

This PL-200 training is considered foundational-level Microsoft 365 training, which means it was designed for IT consultants. This Microsoft Power Platform skills course is valuable for new IT professionals with at least a year of experience with low-code development tools and experienced IT consultants looking to validate their Microsoft 365 skills.

Skills Your Team Will Gain

  • Designing custom Power Apps to meet unique needs
  • Low-code and no-code app development
  • Automating workflows using Power Automate
  • Analyzing data effectively with Power BI
  • Creating secure websites with Power Pages
  • Adding smart logic using simple Power Fx formulas

Course Curriculum

One skill is free to watch — no signup needed. The other 8 premium skills unlock for your whole team with a CBT Nuggets plan.

Free skill preview

Navigating Power Apps

John MunjomaDuration: 44m10 videos

Watch this complete skill free — the same trainer, videos, and labs your team gets with a plan.

Watch free skill
  • Premium skill.Configure Security Settings50m · 11 videos
  • Navigating Power AppsFree44m · 10 videos
  • Premium skill.Canvas Apps52m · 14 videos
  • Premium skill.Customizing Apps45m · 11 videos
  • Premium skill.Service Interoperability48m · 15 videos
  • Premium skill.Managing Data Models44m · 12 videos
  • Premium skill.Power Pages45m · 10 videos
  • Premium skill.Power Automate Flows45m · 12 videos
  • Premium skill.Power Platform Business Value45m · 15 videos
Want to browse the locked skills?
with no purchase required. Already have an account?

An account gets you the full catalog to browse, pre-assessments, quiz questions on free skills, and IT Trainerbot, with every answer citing its source video.

Put this course to work for your team

Every subscription includes this course with the full library, virtual labs, and practice exams — or talk it through with sales.

For IT leaders

What IT leaders need to know before assigning this course

For IT leaders: Low-code apps and flows often spread faster than the governance around them. Business units build Power Apps on SharePoint lists, automate tasks with Power Automate, and publish Power Pages sites. Without planned environments, security roles, and clear controls, that growth creates risk.

This course prepares IT practitioners and functional consultants to deliver Power Platform solutions with controls built in:

  • Separate environments for development, testing, and departments.
  • Role-based app access and security-group access.
  • Power Platform administration concepts for managing settings and configuration.
  • Power Pages security topics, including secure sites, web roles, page permissions, and authentication options.

Role fit: Best for team members with about a year of low-code experience, or consultants building Power Platform delivery skills. If someone is new to the platform, consider having them complete PL-900 first.

Time investment: About 7 hours across 9 skills per learner. That covers security, canvas and model-driven apps, data models, Power Pages, Power Automate flows, and business value.

Change-management notes: Learners need a practice tenant. The instructor recommends a Microsoft 365 E5 or E3 license. Premium Power Automate actions require additional licensing, so plan sandbox access before assigning the course.

Team Leads can add this course to Playlists alongside related Microsoft 365 training. Team Reporting helps Training Managers track progress. Microsoft retired the PL-200 exam on 31 August 2026.

Team Impact

How this training helps your team succeed

IT teams complete this training to deliver low-code solutions the business can use right away, without waiting on a full development effort. Instead of commissioning a custom mobile app, your team learns to plan, build, and deploy canvas apps using Power Platform tools, connectors, and data models that support the organization’s workflows.

  • Fewer release mix-ups and unintended changes: Practitioners organize projects and departments in separate environments, helping IT teams keep work isolated and governed as solutions move toward production.
  • Tighter access control: Your team learns to scope environment access to security groups and assign roles, so users can only perform the tasks their role allows.
  • Less manual, repetitive work: Your team builds Power Automate flows that move work through defined phases, support approvals, and apply predefined parameters when requests need to be granted or denied.
  • Safer public-facing sites and better reporting: Practitioners work with Power Pages concepts such as secure sites, web roles, page permissions, and authentication options. They also connect Power BI to business data so leaders can analyze relationships across products, regions, and performance.

The result for IT Directors is a team that can turn business requests into governed apps, flows, and portals with less reliance on outside developers.

After completion

Capabilities your team walks away with

Knowledge

  • How Power Platform environments isolate projects by stage (development, testing, deployment) and by department, and how security groups control who can access each environment
  • How security roles govern what users can do inside the apps your team builds
  • The difference between managed solutions, which protect production components from unintended edits, and unmanaged solutions, which stay editable during development
  • How table relationships in a data model let multiple apps share the same data sets
  • When to use SharePoint lists, Dataverse tables, or SQL Server as an app data source, and the build overhead each one adds
  • How Power BI model views show relationships between products, regions, and seasons that affect business performance

Ability

  • Plan, design, build, test, and deploy a canvas app on a SharePoint data source, and customize controls and properties such as OnSelect actions and hint text
  • Start new apps from templates or a blank canvas based on the business objective
  • Create and secure environments, assign security groups, and package components into solutions
  • Spin up a Power Pages site, preview it on desktop and mobile, and use Site Checker to scan for security issues
  • Build Power Automate desktop flows that run applications, run scripts (DOS, PowerShell, VBS, JavaScript, Python), and record repeatable browser steps
  • Monitor flow runs for success or error notifications, and connect Power BI Desktop to a deployed SQL Server resource

Readiness check

Confirm prerequisite knowledge before training begins

A short placement assessment on the CBT Nuggets assessments platform measures whether a learner already has the foundation this course assumes. IT leaders use it to put the right people in the right training — and any learner can take it right now to make sure they'll get full value from day one.

  • Questions generated from this course's own video transcripts — what gets measured is exactly what gets taught
  • Instant, per-learner results that show whether the prerequisite foundation is in place
  • Results roll up into team readiness reporting, so training hours go where they change outcomes
Runs on assessments.cbtnuggets.com — sign in with an Adept account so results roll up into team readiness reporting. Need one?
.

If gaps show up, start here

Microsoft Certified: Power Platform Fundamentals (PL-900)

This PL-900 training prepares you to leverage the full suite of Microsoft Power Platform tools to drive business value. You will explore the foundational components of the platform, including Dataverse, connectors, and administration/governance. This...

~6h

This course is included with every plan

Unlock this one course, or get one learner — or your whole team — access to all 294 courses, virtual labs, and practice exams.

Course Unlock

Just need this course?

$0one time

No subscription

One year of access to PL-200

CBT Nuggets Individual

Includes IT Trainerbot Plus

$49per month

Billed annually

Every course, for one learner

See Individual pricing
For IT teams

CBT Nuggets Teams

IT Trainerbot for every seat

$59per seat / mo

Billed annually

From 1 learner seat · unlimited admin seats

Checking your access…

Frequently Asked Questions

Is the Power Platform Functional Consultant Associate worth it?

Yes, learning to use Power Platform is a good idea: it's a dynamic, powerful tool for designing business solutions with Power Platform components like Power Apps, Power Automate, and Power BI. This course covers the skills and knowledge necessary to integrate Power Platform with those tools as well as other Microsoft services like Dynamics 365 and Microsoft 365, qualifying you to start a career as a Power Platform Functional Consultant.

Can consultants still sit the PL-200 exam?

Microsoft retired the PL-200 exam on 31 August 2026, so there is no exam fee to budget for. Teams building Power Platform capability assign this course for the skills, and look at Microsoft's current Power Platform track when a credential is the goal.

Is it difficult to work as a Power Platform functional consultant?

The biggest challenge for Power Platform functional consultants is that there's not always one right answer for any problem. It's up to you as a consultant to understand all the Microsoft Power Platform tools and resources well enough to come up with creative solutions. New and novel problems arise every day, and a Power Platform consultant improvises the solutions based on expertise with Microsoft tools.

How demanding is this Power Platform material?

The concepts are approachable, but the breadth is real: a functional consultant needs deep and wide familiarity with every Microsoft Power Platform tool. Your team will configure and integrate Power Apps, Power Automate, Power BI, and Power Virtual Agents, and get comfortable troubleshooting and optimizing solutions that are already in production.

Who should take this Microsoft Power Platform functional consultant training?

The ideal audience for this course is anyone who is actively working as a Power Platform functional consultant or would like to be competitive in applying for jobs as one. But the skills and knowledge you'll gain on this course are also valuable for business analysts, IT professionals, and solutions architects. Anyone who wants to enhance their ability with designing, automating and optimizing business processes with Microsoft tools should consider this course.

Ready to upskill your team?

See how IT leaders fit this course into a team training plan, and what a plan costs for your team's size.