Skip to content
CBT Nuggets
DemoBook a Demo

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

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, and earn your PL-200 certification while driving real-world impact. This Microsoft skills course is perfect for PL-200 exam prep, and teams aiming to automate operations and elevate decision-making.

Updated December 2024

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 plan includes this course plus 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

Business teams often adopt low-code tools faster than IT can govern, integrate, and support them. This PL-200 course gives IT Directors a structured way to build functional-consultant capability around Microsoft Power Platform without pulling practitioners into a long training cycle. The curriculum is about 418 minutes — just under seven hours per learner — and fits IT consultants, Team Leads, and IT Practitioners who already have basic low-code experience or need to validate Microsoft 365 Power Platform skills.

For change management, assign this course before expanding citizen-development programs, modernizing manual workflows, or standardizing Power Apps support. The training focuses on security settings, app navigation and customization, canvas apps, service interoperability, data models, Power Pages, Power Automate flows, and business value. CBT Nuggets Playlists and Team Reporting can help Training Managers sequence the course and track team progress; where available, virtual labs and Practice Exams can reinforce hands-on readiness and certification preparation.

Team Impact

How this training helps your team succeed

Teams that deploy this training can improve how quickly consultants deliver working Power Platform solutions — not just designs or proposals, but functional apps and automated workflows.

Reducing manual handoffs. Consultants who complete this training can configure Power Automate flows and triggers that support multi-step approval processes — the kind that often live in email threads or shared spreadsheets. When a consultant understands how triggers, conditions, and connectors interact in the platform, they can reduce dependency on developers for routine workflow configuration.

Faster client onboarding. Functional consultants working in customer-facing roles can independently configure Canvas App layouts, connect SharePoint and SQL data sources, and apply tenant-level security rules — without escalating to a senior architect for each engagement. That compresses the time between scoping and delivery.

Less rework on governance. Teams that skip Power Platform governance fundamentals routinely rebuild environments after a client flags a data policy violation or a Power BI workspace permission issue. This training covers data loss prevention policies, sensitivity labels, and workspace roles specifically — the details that prevent those rebuilds.

Low-code work that actually scales. Consultants who understand the underlying data model — table relationships, Dataverse structure, how Power Pages connects to authentication — build solutions that don't break when client requirements change. That's the difference between a one-off app and something a client keeps using.

For IT Directors managing a consulting bench, this is the difference between team members who need supervision on every Power Platform engagement and those who can scope, build, and hand off independently.

After completion

Capabilities your team walks away with

Knowledge

  • Core responsibilities covered by the PL-200 Power Platform Functional Consultant path.
  • How security settings affect Power Platform administration and solution governance.
  • How canvas apps, customized apps, Power Pages, and Power Automate flows fit into Power Platform solution design.
  • How data models support app behavior and business processes.
  • How service interoperability and business-value framing influence solution planning.

Ability

  • Configure Power Platform security settings in line with team standards.
  • Navigate Power Apps and work with canvas app components.
  • Customize apps to better match business requirements.
  • Manage data models that support low-code applications.
  • Build or support Power Pages and Power Automate flows as part of broader Microsoft 365 solutions.

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 Directors 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 subscription

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

CBT Nuggets Individual

IT Trainerbot Pro

$49per month

Billed annually

Every course, for one learner

See Individual pricing
For IT teams

CBT Nuggets Teams

IT Trainerbot for Teams

$59per seat / mo

Billed annually

From 1 learner seat · unlimited admin seats

Checking your access

Need tenant hosting, reseller terms, or payment plans on a larger agreement? Book a Demo to discuss an Enterprise contract.

See plans and pricing for your team

Trusted by 23,000+ organizations

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.

How much does it cost to earn the Power Platform Functional Consultant?

The Microsoft Certified: Power Platform Functional Consultant only has one exam: PL-200. It costs $165 to try the PL-200 exam, and since the cert doesn't have any prerequisite credentials or Microsoft education, that should end up being the total cost for most people. However, you only get one shot at the test, so it's a good idea to add the cost of a preparation course before you take the certifying exam.

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 difficult is the PL-200 Power Platform Functional Consultant exam?

PL-200 (Microsoft Power Platform Functional Consultant) isn't an especially challenging exam, but passing it does require a deep as well as broad familiarity with the scope and use of each Microsoft Power Platform tool. You'll need to know how to configure and integrate Power Apps, Power Automate, Power BI and Power Virtual Agents. You'll also need to feel comfortable troubleshooting and optimizing existing solutions to face real-world scenarios.

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?

Talk to our sales team to find the right plan for your organization.