Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

PL-200:Microsoft Power Platform Functional Consultant

Name: PL-200:Microsoft Power Platform Functional Consultant
Rating: 4.6 (1576 reviews)

PL-200: Microsoft Power Platform Functional Consultant.

Bestseller

Created byPhillip Burton • over one million students so far, I Do Data Limited

Last updated 7/2026

English

German [Auto],English [Auto],

What you'll learn

Create a Power Pages website (portal app)
Manage solutions and interoperability with other services
Create classic workflows
Configure Microsoft Dataverse: Manage the data model, manage Dataverse and configure security settings

Course content

44 sections • 244 lectures • 22h 49m total length

Part 1 Introduction2:44
Welcome to Udemy0:37
How to get the best out of your Udemy course3:05
Discover how to optimize your Udemy course experience by configuring playback, subtitles, and quality; access course content, notes, and announcements, and download your certificate.
Do you want auto-translated subtitles in more languages?1:20
Curriculum5:25
Delve into the Microsoft Power Platform, including Power Apps, Power Automate, and Power BI. Build Dataverse-driven solutions with canvas and model-driven apps and cloud flows.
Resources0:20
Introduction to the Power Platform5:24
Summarizes power platform components—Power Apps, Power Automate, Power Virtual Agents, Power BI—and the Dataverse with tables, columns, and rows, plus Canvas apps and model driven apps, with AI Boda integration.

Licensing for Power Apps4:50
Explore Power Apps licensing, compare per user, per app, and pay-as-you-go plans; learn how developer and standalone licenses enable development and testing with connectors.
Power Automate using the Power Apps Developer plan0:19
Signing up for Power Apps per user plan2:27
Sign up for the Power Apps developer plan to access a development and testing environment with Power Apps, Power Automate, and Dataverse, and share apps with teammates.
7. Different types of environments, and creation options6:46
Explore how environments in the Power Platform store and share data, apps, and flows, and learn to create and manage them in the admin center with various types and licensing.
Create a Dataverse database, and sample data8:43

43, 44. Creating a canvas app using a template; start to build the app7:09
Saving my Power App4:04
36, 43, 44. Connect to data sources in canvas apps1:50
Build a canvas app from blank by selecting a phone-size canvas and adding data sources and connectors. Connect accounts data from Microsoft Dataverse and prepare to populate the first screen.
41, 43. Build canvas apps screens - Inserting a Gallery4:46
44. Formatting the label component9:05
Explore formatting the label component in a gallery, including literal text and item-based formulas, referencing account name, and adjusting font, color, alignment, and visibility with replicated item behavior.
Practice Activity Number 10:32
Practice Activity Number 1 - The Solution4:23

43. Inserting a new screen and a card component6:55
45. Using formulas in non-English locales4:07
Learn how Power Apps formulas differ by locale, covering navigate function and how dot, comma, semicolon, and two semicolons delimit arguments across English and non-English settings.
45. Using the Navigate and Back functions in the OnSelect event8:11
43, 45. Building an edit screen8:30
Create an edit screen linked to the browse screen, using an edit form to modify account fields, submit or reset the form, and navigate back on success.
41. Adding rectangles and Adding New Items5:22
Sorting and refreshing our gallery, and Deleting Items5:23
Practice Activity Number 20:53
Practice Activity Number 2 - The Solution9:30

10. Create a high-level design3:27
Expand the accounts app by adding an expenses table linked to accounts, define entities, fields, and relationships, and design a high-level data model and user experience for managing expenses.
10. Design data models5:18
10. Create Dataverse tables based on a data model9:10
Create a Dataverse table from the data model, exploring standard, custom, activity, and virtual or complex tables, with ownership, display name, id, and offline options.
10. Adding columns to our Dataverse table12:19
Learn to extend a Dataverse table by adding diverse columns, including text, text area, email, url, phone, currency, date, and image types, with choice-based approvals and security options.
10. Updating our Primary Name Column, and Keys6:28
11. Link entities by using Dataverse entity relationships9:56
10. Adding Calculated Columns12:12
10. Adding Rollup Columns5:33
Configure roll-up columns to summarize related data across tables, such as total expenses by account using a currency type and sum aggregation. Understand scheduled and incremental roll-up calculations and filters.
Practice Activity Number 30:34
Practice Activity Number 3 - The Solution6:29

15. Create tables and table columns by using Copilot in Dataverse9:42
16. Import data into a new table by using Microsoft Excel5:14
16. Import data into an existing table by using Microsoft Excel7:37
Import additional Excel data into an existing table by uploading the file, mapping columns, and resolving mapping errors, using Power Query to load into a new or existing table.
16. Edit and export data by using Microsoft Excel5:43
Explore two editing options, edit in place and edit in Excel via the Power Apps add-in, and exporting options, static CSV export and interactive Excel export that publishes to Dataverse.

41. Adding Expenses screens into our Accounts apps12:54
Add expenses screens to the accounts app by duplicating the browse, detail, and edit screens and connecting them to a new expenses data source.
Practice Activity Number 41:00
Practice Activity Number 4 - The Solution10:21
45. The Filter function - linking the Expenses and Accounts screens together7:11
Link the expenses and accounts screens using the filter function to display only expenses for the selected account, enabling navigation from the account browse screen to the expense browse screen.
44. Default and DefaultSelectedItems4:06
Practice Activity Number 50:40
Practice Activity Number 5 - The Solution7:04
Link user screens to device screens by adding navigation, selecting the user from the gallery, and updating forms to attach a user field to new devices, enabling focused device views.

41. Add Pictures and Image controls6:47
46. Global variables - seeing one account's expenses, or all expenses11:04
Add a menu screen with buttons to view accounts or expenses. Use the set function to implement a global variable that toggles between a single account view and all expenses.
46. Context variables - adding a Sort icon9:36
Add a sort icon using update context to toggle ascending and descending on a single screen, and understand how context updates differ from global set operations.
45. The Search function - Searching for text6:04
Practice Activity Number 61:00
Practice Activity Number 6 - The Solution11:31
Demonstrates adding a picture control linked to the device image column, building a main menu with see all users and see all devices, and configuring a variable to toggle views.

Creating a basic calculator7:28
Create a basic running total calculator on a new screen with a text input and add button. Use a context variable to update the total and reset on visible.
41. Converting the calculator to a component6:24
Create a reusable calculator component in Power Apps, turning controls into a standalone component and using on reset events to manage total while the component remains a black box.
41. Communicating with the component9:30
Explore how to feed data into and retrieve results from a component using input and output custom properties, set an initial value, handle on reset, and observe instance-scoped totals.
41. Exporting and Importing components7:47
Practice Activity Number 70:38
Practice Activity Number 7 - The Solution6:58

41, 43. Adding other media assets to screens2:58
Add images, audio, and video to canvas Power Apps, then configure controls, auto start, loop, and start time. Switch media with a variable and support mp3 and wav formats.
43. Other controls6:35
Explore the wide range of Power Apps controls, including text, input, media, and charts. Learn how gallery, data table, forms, and geospatial features powered by TomTom enable interactive, data-driven apps.
45. Other formulas5:56
37. Design choices and app performance, and App Checker results9:57
Explore how design choices impact canvas app performance and interpret App Checker results, including errors, warnings, and suggestions, to optimize loading, delegation, and data handling.
38, 39. Create+publish new versions, restore a previous version of an app3:59
Save edits to preserve changes, then publish to make the latest version live for all users. Manage versions in Power Apps by saving, restoring as a new version, and publishing.
42. Describe modern controls and themes6:50
43. Containers10:57
6. Using Microsoft Copilot when editing canvas Power Apps5:42

Requirements

This course covers the requirements of the PL-200 exam which are not covered in the PL-100 exam.
Therefore, you will already need to have gone through the requirements of the PL-100 exam.
You will need to know how to create canvas and model-driven apps and create flows.
You need Windows 7 SP1 or above, or for other machines an internet browser (Edge or Chrome preferred) to access most of the apps used in this course.
You need Windows 8 or 10 to access Power BI Desktop; however, you can access Power BI Server on other devices.
There is a 30-day refund guarantee of this Udemy course (see Udemy's refund policy).
Why not have a look at the curriculum below and see what you can learn?

Description

This course covers all of the requirements for the PL-200 certification exam, current as per the PL-200 exam update of 12 January 2024, with minor revisions from 26 December 2024.

The Microsoft PL-200 "Microsoft Power Platform Functional Consultant" exam will be retired on 31 August 2026.

Please note: This course is not affiliated with, endorsed by, or sponsored by Microsoft.

What do people like you say about this course?

Anonymous says: Very detailed and clear. It is easy to understand, practice and prepare for the exam.

Manny says: If you have reached this level of Power Platform that you are thinking about attempting the PL-200 exam, Phillip's course is the only deal in town. He takes you through every topic that is required learning as part of the exam. There's simply no one better than him at this stuff.

Rainier says: I work as a CRM consultant and these courses teach me 'the new stuff' or 'the new way' of doing things. Great courses! I did the PL 100 and now the PL 200.

Daniel says: I passed the PL-200 exam and got the certification for Power Platform Functional Consultant. Thank you Phillip! Your course was excellent and definitely played a huge part in achieving my goal.

This course teaches the advanced requirements for the Microsoft Certificate PL-200 "Microsoft Power Platform Functional Consultant". It focuses on configuring the Microsoft Dataverse, creating Power Pages web sites, and creating business process flows and classic Dataverse workflows.

We will then look at add a new solution with sample data, and create a Power Pages site. We will look at configuring portal web pages, forms and navigation, portal security, details, actions and authentication, together with exposing Dataverse data.

Finally, we will look at Configure Microsoft Dataverse, Managing Solutions, and Manage interoperability with other services.

Once you have completed this course, you will have a good knowledge of Configuring Microsoft Dataverse, Managing solutions, creating portal apps, desktop flows, Power Virtual Agents chatbots and how they interact with each other. And with some practice, you could even go for the official Microsoft certification PL-200 - wouldn't that look good on your CV or resume? And if you are an American college student, you might even get college credit for passing that exam.

I hope to see you in the course - why not have a look at what you could learn?

Who this course is for:

This course is for you if you want to configure Power Platform solutions and Microsoft Dataverse.
You will also be able to create Power Pages web sites.
By the end of this course, after entering the official Practice Tests, you could enter (and hopefully pass) Microsoft's official PL-200 exam.
Wouldn't the "Microsoft Certified: Power Platform Functional Consultant" certification look good on your CV or resume?

PL-200:Microsoft Power Platform Functional Consultant

What you'll learn

Explore related topics

Course content

Part 1 - Introduction7 lectures • 19min

Installing Power Apps and Environments5 lectures • 23min

Creating a canvas app from a template, and creating one from scratch7 lectures • 32min

Expanding our canvas app8 lectures • 49min

Designing data model10 lectures • 1hr 11min

Other ways to create tables, and importing and exporting data4 lectures • 28min

Adding Expenses to our app7 lectures • 43min

Expanding our canvas app further, including using variables6 lectures • 46min

Canvas Apps components6 lectures • 39min

Other controls and other canvas apps topics8 lectures • 53min

Requirements

Description

Who this course is for: