PL-900 Study Guide – Microsoft Power Platform Fundamentals

The PL-900 exam is the only exam needed to get the Microsoft Certified Power Platform Fundamentals Certification, and an optional exam in the Microsoft Certified Dynamics Associate and Expert paths. Candidates for this exam are users who aspire to improve productivity by automating business processes, analyzing data to produce business insights, and acting more effectively by creating simple app experiences.

In this PL-900 Study Guide, I will share both free and paid options, whether books, video training or simply links to articles and blog posts. I will not share any dumps as those are against the Microsoft Terms of Service, and by using dumps, we decrease the value of our certifications.


PL-900 Study Guide

Exam Ref Pl-900 Microsoft Power Platform Fundamentals
Exam Ref PL-900 Microsoft Power Platform Fundamentals offers professional-level preparation that helps candidates maximize their exam performance and sharpen their skills on the job. It focuses on the specific areas of expertise modern IT professionals need to demonstrate real-world mastery of Microsoft Power Platform&;s concepts, components, and capabilities for automating business processes, analyzing data, and creating simple app experiences.

Video Training

NOTE: Pluralsight is a paid resource unlike Channel9 and Microsoft Virtual Academy which are free. The quality they provide is also superior because of all the quality checks they go through, and the instructors are one of the best in the industry. The Pluralsight courses have a link to where you can get a free trial and decide for yourself if paying a subscription or not is worth it, but the 10-day free trial should allow you to view all those courses for free.

Microsoft Power Platform Fundamentals (PL-900) Certification Prep Path (6 courses – 10 hours)
This path covers certification objectives for the Microsoft Power Platform Fundamentals (PL-900). Candidates for this exam are users who aspire to improve productivity by automating business processes, analyzing data to produce business insights, and acting more effectively by creating simple app experiences. Read less

Overview of building solutions on PowerApps and the Power Platform
In this video, get a high-level overview of the business problems being solved by Microsoft PowerApps and the Microsoft Power Platform.

Learn Microsoft Flow
Welcome to workflow development. This course is your gateway to workflow design using Microsoft Flow. You will learn to build workflows from scratch and integrate it with many external services.

Microsoft Flow Crash Course
This course teaches you the basic skills required for using Power BI to acquire and transform data, enhance the data for analysis, and produce reports and dashboards.

Fundamentals of Microsoft PowerApps
This course will teach students how to design, build and publish modern mobile first and interactive forms using Microsoft PowerApps without the need to write a single line of code.

Microsoft PowerApps & Flow: Build Business Apps Without Code
You will learn how to build Apps without code using Microsoft PowerApps and Microsoft Flow. A powerful alternative!

Microsoft Power BI – A Complete Introduction
In this course you will learn why Power BI offers you a comprehensive set of Business Intelligence tools for your data analysis goals and how to use these tools to fulfill all the above tasks – and more. Imagine to quickly structure your data, to easily add calculations to it and to create and publish nice-looking charts in just a few minutes.

Microsoft Power Platform Fundamentals
Learn the business value and product capabilities of Power Platform. Create a simple Power App, connect data with CDS, build a Power BI Dashboard, and automate a process with Power Automate.

Instructor-led training (Microsoft Official Courses)

Course PL-900T00-A: Microsoft Power Platform Fundamentals

Learn the business value and product capabilities of Power Platform. Create a simple PowerApp, connect data with CDS, build a Power BI Dashboard, and automate a process with Microsoft Flow

Articles / Blog Posts Per Objective

Describe the business value of Power Platform (15-20%)

Describe the business value of Power Platform services

  1. Take care of what’s important. Automate the rest.
  • use connectors to access services and data
  1. About Connectors
  • create powerful chatbots by using a guided, no-code graphical interface
  1. Power Virtual Agents & Bot Framework – enabling everyone to build intelligent chatbots

Describe Power Platform administration and security

  • describe how Power Platform implements security including awareness of Common Data Service security roles, Azure Identity Services
  1. Security concepts in Common Data Service
  2. Security in Common Data Service
  3. Governance considerations
  4. Configure user security to resources in an environment
  • describe how to manage apps and users
  1. Create and manage environments in the Power Platform admin center
  • describe environments
  1. Environments overview
  2. About environments
  3. Working with environments and Microsoft Power Apps
  4. Establishing an Environment Strategy for Microsoft Power Platform
  5. Create and manage environments in the Power Apps Admin center
  • describe where to perform specific administrative tasks including Power Platform Admin center, Microsoft 365 admin center
  1. Working with the admin portals
  2. About admin roles
  3. Assign admin roles
  4. About the Microsoft 365 admin center
  • describe Data Loss Prevention (DLP) policies
  1. Data loss prevention (DLP) policies
  2. Manage data loss prevention (DLP) policies
  3. Create a data loss prevention (DLP) policy
  4. Data loss prevention policies
  5. New Data Loss Prevention capabilities in public preview
  • describe how the platform supports privacy and accessibility guidelines
  1. Compliance and data privacy
  2. PowerApps Canvas App Accessibility Guidelines
  3. Making apps accessible
  4. Create accessible canvas apps in Power Apps

Identify the Core Components of Power Platform (15-20%)

Describe Common Data Service

  1. How to use Common Data Model
  2. Frequently asked questions about the Common Data Model
  • describe how to use common standard entities to describe people, places, and things
  1. Entities and metadata in Common Data Service

Describe Connectors

  • describe triggers including trigger types and where triggers are used
  1. Power Platform: What are the connectors & triggers in Power Automate? [tracyvanderschyff]
  2. Data Connectors
  • describe actions
  1. Power Platform: What are the connectors & triggers in Power Automate? [tracyvanderschyff]
  2. Data Connectors
  • describe licensing options for connectors including standard or premium tier Identify use cases for custom connectors

Describe AI Builder

  • identify the business value of AI Builder
  1. Introducing AI Builder for Power Platform
  2. What is AI Builder?
  • describe models including business card reader, detection model, form processing model, and prediction model
  1. AI model types
  2. Overview of the prediction model
  3. Create a prediction model
  4. Use your prediction model
  5. Use the business card reader component in model-driven apps
  6. Use the business card reader prebuilt model in Power Automate
  7. Get started with object detection
  8. Use the object detection model in Power Automate
  9. Train and publish your object detection model
  10. Overview of the form-processing model
  11. Create a form-processing model
  12. Use a form-processing model in Power Automate
  13. Train and publish your form-processing model

Demonstrate the capabilities of Power BI (15-20%)

Identify common Power BI components

  • identify and describe uses for visualization controls including pie, bar, donut, and scatter plots and KPIs
  1. Visualizations in Power BI reports
  2. Visualization types in Power BI
  3. Customize visualization titles, backgrounds, and legends
  • describe types of filters
  1. Types of filters in Power BI reports
  • describe the Power BI Desktop Reports, Data, and Model tabs
  1. What is Power BI Desktop?
  2. Get started with Power BI Desktop
  3. Data sources in Power BI Desktop
  4. Data types in Power BI Desktop
  5. Use the updated ribbon in Power BI Desktop
  6. Work with Modeling view in Power BI Desktop
  • describe uses for custom visuals including charts or controls
  1. Create custom visuals for Power BI
  2. Use custom controls for data visualizations
  3. Tutorial: Developing a Power BI visual
  4. Get a Power BI visual certified
  5. How to govern Power BI visuals inside your organization [

Compare and contrast dashboards and workspaces

  • compare and contrast Power BI Desktop and Power BI Service
  1. Comparing Power BI Desktop and the Power BI service

Connect to and consume data

  • combine multiple data sources
  1. Combine data from multiple data sources (Power Query)
  2. Tutorial: Shape and combine data in Power BI Desktop
  3. Tutorial: Shape and combine data using Power Query
  • clean and transform data
  1. Transform, shape, and model data in Power BI – documentation
  • describe and implement aggregate functions
  1. Use aggregations in Power BI Desktop
  2. Work with aggregates (sum, average, and so on) in the Power BI service
  • identify available types of data sources including Microsoft Excel
  1. Find out which data sources are used in a workbook data model ]
  • describe use cases for shared datasets and template apps and how to consume each
  1. What are Power BI template apps?
  2. Shared and certified datasets

Build a basic dashboard using Power BI

  • design a Power BI dashboard
  1. Introduction to dashboards for Power BI designers
  2. Tips for designing a great Power BI dashboard
  3. Create a Power BI dashboard from a report
  • design data layout and mapping
  1. Tips for designing a great Power BI dashboard
  • publish and share reports and dashboards
  1. Ways to collaborate and share in Power BI
  2. Share Power BI dashboards and reports with coworkers and others
  3. Publish datasets and reports from Power BI Desktop
  4. Display the dashboards and reports that have been shared with me

Demonstrate the capabilities of Power Apps (15-20%)

Identify common Power Apps components

  1. Introducing PowerApps Portals: powerful low-code websites for external users
  2. What is Power Apps portals?
  3. Power Apps Portals
  4. Power Apps portals FAQ
  • identify and describe types of reusable components including canvas component libraries and Power Apps Component Framework (PCF) components
  1. Power Apps component framework overview
  • describe use cases for formulas
  1. Get started with canvas-app formulas in Power Apps

Build a basic canvas app

  • describe types of data sources
  1. Data types in canvas apps
  • connect to data by using connectors
  1. Overview of canvas-app connectors for Power Apps
  2. Connect to Common Data Service
  1. Save and publish a canvas app in Power Apps
  2. Share a canvas app in Power Apps

Describe Power Apps portals

  • create a portal by using a template
  1. Create and manage page templates
  2. Create a Common Data Service starter portal
  • describe common portal customizations
  1. Overview of extending portals
  • identify differences in portal behavior based on whether a user is authenticated
  1. Configure portal authentication
  2. Set authentication identity for a portal
  • apply a theme to a portal
  1. Overview of themes in Power Apps portals
  2. Create a theme
  3. Edit CSS for themes in Power Apps portal

Build a basic model-driven app

  • add entities to app navigation
  1. Basic navigation in a model-driven app
  2. Build your first model-driven app from scratch
  • modify forms and views
  1. Customize entity forms
  2. Understand model-driven app views
  3. Create a model-driven app quick view form to view information about a related entity
  4. Create, edit, or configure forms using the form designer
  • publish and share an app
  1. Share a model-driven app using Power Apps
  2. Validate and publish a model-driven app using the app designer

Demonstrate the capabilities of Power Automate (15-20%)

Identify common Power Automate components

  • identify flow types
  1. Types of flows
  • describe use cases for and available templates
  1. Exercise – Create your first flow
  2. Check out the start page
  1. Use the apply to each action in Power Automate to process a list of items periodically
  • describe expressions
  1. Use expressions in flow actions
  • describe approvals
  1. Create and test an approval workflow with Power Automate

Build a basic flow

  • create a flow by using the button, automated, or scheduled flow template
  1. Run flows on a schedule
  2. Introducing instant flows
  3. Introducing button flows with user input
  4. Create a flow in Power Automate
  5. Create a flow from a template in Power Automate
  • modify a flow
  1. Create a flow in Power Automate
  • use flow controls to perform data operations
  1. Use data operations with Power Automate
  • run a flow
  1. Watch your flows in action
  2. Run attended and unattended UI flows

Demonstrate the capabilities of Power Virtual Agents (10-15%)

Describe Power Virtual Agents capabilities

  • describe use cases for Power Virtual Agents
  1. Power Virtual Agents overview
  • describe where you can publish chatbots
  1. Key Concepts – Publish your bot
  • describe topics, entities and actions
  1. Key concepts – Enhanced authoring in Power Virtual Agents
  2. Building a Crisis FAQ bot using Power Virtual Agents
  3. Add actions to a bot using Power Automate

Build and publish a basic chatbot

  • create a chatbot
  1. Create your first Power Virtual Agents bot
  2. Quickstart: Create and deploy a Power Virtual Agents bot
  • create a topic
  1. Create and edit topics in your Power Virtual Agents bot
  2. Create topics from existing support content on the web
  • call an action
  1. Add actions to a bot using Power Automate
  • test a chatbot
  1. Test your Power Virtual Agents bot
  • publish a chatbot
  1. Key Concepts – Publish your bot

Follow me on Social Media and Share this article with your friends!

Additional Tips

I think the best thing that you can do after reading this, or even meanwhile, is to open a free Microsoft 365 with Dynamics 365 trial (or a few), and play with those features, follow the tutorials and you shouldn’t have any problems with the exam!

You can also check out my other Microsoft Certification Study Guides

Did I miss any cool links in this PL-900 Study Guide? Let me know in the comments!


  • May 22, 2020 at 3:24 am
    Aakash Maurya

    Don’t know how to say thanks to you for your efforts that you give to provide such a great information. I did several things to say thanks to you like
    1. Sent a friend request on FB
    2. Followed you on Twitter from my both account
    3. Requested a connection on LinkedIn
    4. Subscribed and pressed Bell icon on your YouTube channel with all my account that I used (5+)
    5. Signing Up for news letter

    Thanks for such a great help.

    • May 23, 2020 at 10:12 pm

      Really glad you enjoy the content, and looking forward to connecting to you on other platforms 🙂

  • June 29, 2020 at 12:26 pm
    Mark Hammecher

    Hi Vlad,

    Is there also some explanation about dynamics?
    I am pretty sure it will be covered in the exam.

    • July 2, 2020 at 1:04 pm

      I did it in Beta, but I did not have many DYnamics questions. They really kept the dynamics in the DP-900 , and Power Platform in the PL-900! I honestly don’t know much about dynamics and still passed :).

  • June 30, 2020 at 1:09 pm

    Vlad – thanks for this list and the training you provide on Pluralsight. I benefitted from them quite a bit! I passed the PL 900 exam and look forward to more learning! Thanks again!

  • July 28, 2020 at 6:52 am
    Syed Muhammad Baber Owais

    Excellent stuff. Very helpful.

  • August 1, 2020 at 12:30 pm
    Ricardo Mendes

    Hi Vlad,
    Do you have any feedbck about measureup tests? I have been doing some and the questions seem to be a litle bit more thn fundamentals.
    Thanks for your sharing.

    • August 1, 2020 at 5:55 pm

      Hello Ricardo,

      I have never tried using them so unfortunately no first hand feedback I can share :(.

  • August 6, 2020 at 3:46 am
    Ricardo Mendes

    thanks for your feedback Vlad.

  • February 9, 2021 at 6:24 pm

    Hi Vlad,

    Watched your videos and passed the PL-900 exam today.

    thank you,

    • February 10, 2021 at 8:48 pm

      Congratulations Michael! What exam are you looking forward to next?

  • March 31, 2021 at 8:01 am

    I passed this recently, and here is my advice. Check the learning site for the latest version of this study guide often. It had changed a week before my test. But the version of the test that I actually took was over 6 months old. Know both the old/new names for MS tools as you don’t know what the date of the test will be. Read all the pages under the Microsoft documentation for each area of this exam. Start at the top and read through it all. Get into the weeds. Even doing this, I had a question where I had not heard of what they were asking about! Go through all the topics in Microsoft Learn. And get hands on. Get a free trial, look at the options available to you for all the tools, know where to go to accomplish tasks. I found it to be a hard exam even with 2 months of prep, reading through documentation twice, watching hours of Pluralsight training, taking notes, flash cards, and lots of practice exam rounds. Good luck!


Leave a Reply

15 49.0138 8.38624 1 0 4000 1 300 1