Microsoft Power Platform Fundamentals Certification Study Guide

The Microsoft Power Platform Fundamentals Certification enables you to learn all the core concepts and fundamentals you need to get started on Power Platform. By getting this certification, you will learn how to improve productivity by automating business processes, analyze data to produce business insights, and act more effectively by creating simple app experiences.

In this study guide, I will share with you some of the useful resources you can use to guide you during your learning path to get this certification.

Certification Path

Exam Name Link
PL-900: Microsoft Power Platform Fundamentals Exam Details

PL-900 - Microsoft Power Platform Fundamentals

The PL-900 has a length of one hour. There are 36 questions and you need 700 points min of 1000 to pass the exam.

First place to go is the Microsoft Learn platform where a dedicated learning path is available, for free. Also, you should have a look to the Resources section in this study guide where you have useful resources to help you consolidate the knowledge that will help you get the exam and certification. If you prefer to watch videos, instead of read, explaining these core concepts and showing how to get started using Power Platform, then I invite you to have a look to the Power Platform fundamentals certification path, available on Pluralsight, and my course explaining how to get started on Power Platform.

Skills measured

Note: The content of this exam will be updated on July 13, 2020. For more information you can always reference to the Exam Details Page. The study guide below is the updated guide as of July 13, 2020. For more info, please reference this link.

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

Describe the business value of Power Platform services

  • analyze data by using Power BI
  • act with Power Apps
  • build solutions that use Common Data Service
  • create flows by using Power Automate
  • use connectors to access services and data
  • create powerful chatbots by using a guided, no-code graphical interface

Describe the business value of extending business solutions by using Power Platform

  • describe how Dynamics 365 apps can accelerate delivery of Power Platform business solutions
  • describe how Power Platform business solutions can be used by Microsoft 365 apps including Microsoft Teams
  • describe how Power Platform business solutions can consume Microsoft 365 services
  • describe how Power Platform business solutions can consume Microsoft Azure services
  • describe how Power Platform business solutions can consume third-party apps and services

Describe Power Platform administration and security

  • describe how Power Platform implements security including awareness of Common Data Service security roles, Azure Identity Services
  • describe how to manage apps and users
  • describe environments
  • describe where to perform specific administrative tasks including Power Platform Admin center, Microsoft 365 admin center
  • describe Data Loss Prevention (DLP) policies
  • describe how the platform supports privacy and accessibility guidelines
Identify the Core Components of Power Platform (15-20%)

Describe Common Data Service

  • describe the Power Apps user experience
  • describe entities, fields, and relationships
  • describe use cases for solutions
  • describe use cases and limitations of business rules
  • describe the Common Data Model (CDM)
  • describe how to use common standard entities to describe people, places, and things

Describe Connectors

  • describe triggers including trigger types and where triggers are used
  • describe actions
  • 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
  • describe models including business card reader, detection model, form processing model, and prediction model
  • describe how the Power Apps and Power Automate can consume AI Builder data
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
  • describe types of filters
  • describe the Power BI Desktop Reports, Data, and Model tabs
  • describe uses for custom visuals including charts or controls
  • compare and contrast Power BI Desktop and Power BI Service

Connect to and consume data

  • combine multiple data sources
  • clean and transform data
  • describe and implement aggregate functions
  • identify available types of data sources including Microsoft Excel
  • describe use cases for shared datasets and template apps and how to consume each

Build a basic dashboard using Power BI

  • design a Power BI dashboard
  • design data layout and mapping
  • publish and share reports and dashboards
Demonstrate the capabilities of Power Apps (15-20%)

Identify common Power Apps components

  • describe differences between canvas apps and model-driven apps
  • describe portal apps
  • identify and describe types of reusable components including canvas component libraries and Power Apps Component Framework (PCF) components
  • describe use cases for formulas

Build a basic canvas app

  • describe types of data sources
  • connect to data by using connectors
  • combine multiple data sources
  • use controls to design the user experience
  • describe the customer journey
  • publish and share an app

Describe Power Apps portals

  • create a portal by using a template
  • describe common portal customizations
  • identify differences in portal behavior based on whether a user is authenticated
  • apply a theme to a portal

Build a basic model-driven app

  • add entities to app navigation
  • modify forms and views
  • publish and share an app
Demonstrate the capabilities of Power Automate (15-20%)

Identify common Power Automate components

  • identify flow types
  • describe use cases for and available templates
  • describe how Power Automate uses connectors
  • describe loops and conditions including switch, do until, and apply to each
  • describe expressions
  • describe approvals

Build a basic flow

  • create a flow by using the button, automated, or scheduled flow template
  • modify a flow
  • use flow controls to perform data operations
  • run a flow
  • modify a flow
Demonstrate the capabilities of Power Virtual Agents (10-15%)

Describe Power Virtual Agents capabilities

  • describe use cases for Power Virtual Agents
  • describe where you can publish chatbots
  • describe topics, entities and actions

Build and publish a basic chatbot

  • create a chatbot
  • create a topic
  • call an action
  • test a chatbot
  • publish a chatbot
  • monitor chatbot usage
  • monitor chatbot performance


Microsoft Learning Path - Microsoft Power Platform Fundamentals
Microsoft Certification Page - Microsoft Power Platform Fundamentals
Microsoft Power Platform Fundamentals (PL-900) Pluralsight Certification Path
Power Platform: Getting Started Pluralsight Course
Power Apps
Power Automate
Power BI
Power Virtual Agents
Connectors Documentation