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

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 validating Microsoft 365 skills for PL-200. 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 toward PL-200 readiness.

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.

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