Study guide for Exam PL-900: Microsoft Power Platform Fundamentals

Purpose of this document

This study guide should help you understand what to expect on the exam and includes a summary of the topics the exam might cover and links to additional resources. The information and materials in this document should help you focus your studies as you prepare for the exam.

Useful links Description
Review the skills measured as of June 21, 2024 This list represents the skills measured AFTER the date provided. Study this list if you plan to take the exam AFTER that date.
Review the skills measured prior to June 21, 2024 Study this list of skills if you take your exam PRIOR to the date provided.
Change log You can go directly to the change log if you want to see the changes that will be made on the date provided.
How to earn the certification Some certifications only require passing one exam, while others require passing multiple exams.
Your Microsoft Learn profile Connecting your certification profile to Microsoft Learn allows you to schedule and renew exams and share and print certificates.
Exam scoring and score reports A score of 700 or greater is required to pass.
Exam sandbox You can explore the exam environment by visiting our exam sandbox.
Request accommodations If you use assistive devices, require extra time, or need modification to any part of the exam experience, you can request an accommodation.
Take a free Practice Assessment Test your skills with practice questions to help you prepare for the exam.

Updates to the exam

Our exams are updated periodically to reflect skills that are required to perform a role. We have included two versions of the Skills Measured objectives depending on when you are taking the exam.

We always update the English language version of the exam first. Some exams are localized into other languages, and those are updated approximately eight weeks after the English version is updated. While Microsoft makes every effort to update localized versions as noted, there may be times when the localized versions of an exam are not updated on this schedule. Other available languages are listed in the Schedule Exam section of the Exam Details webpage. If the exam isn't available in your preferred language, you can request an additional 30 minutes to complete the exam.

Note

The bullets that follow each of the skills measured are intended to illustrate how we are assessing that skill. Related topics may be covered in the exam.

Note

Most questions cover features that are general availability (GA). The exam may contain questions on Preview features if those features are commonly used.

Skills measured as of June 21, 2024

Audience profile

As a candidate for this exam, you aspire to understand how Microsoft Power Platform technologies can be used to:

  • Develop tailored business solutions.

  • Identify how Microsoft Dataverse supports the interoperability of Microsoft Power Platform.

  • Accelerate business outcomes by using Microsoft Power Apps for low code/no code solutions.

  • Improve processes by using Microsoft Power Automate and Process mining.

  • Identify use cases for Microsoft Power Pages.

  • Help make data-driven technology decisions by using Microsoft Power BI.

  • Evaluate how Copilot can assist with each of these.

The exam is intended for you if you’re seeking to start your journey building solutions with Microsoft Power Platform.

You can use this exam to prepare for role-based or specialty certifications, but it’s not a prerequisite for any of them.

Skills at a glance

  • Describe the business value of Microsoft Power Platform (20–25%)

  • Identify foundational components of Microsoft Power Platform (10–15%)

  • Demonstrate the capabilities of Power BI (10–15%)

  • Demonstrate the capabilities of Power Apps (20–25%)

  • Demonstrate the capabilities of Power Automate (10–15%)

  • Demonstrate the capabilities of Power Pages (1–5%)

  • Describe the AI authoring experience in Microsoft Power Platform (10–15%)

Describe the business value of Microsoft Power Platform (20–25%)

Describe the business value of Microsoft Power Platform services

  • Describe the value of Microsoft Power Apps to build applications

  • Describe the value of Microsoft Power Automate to automate processes

  • Describe the value of Microsoft Power BI to gain insights into data

  • Describe the value of Microsoft Power Pages to build websites

  • Describe the value of connectors to integrate services and data

  • Describe the value of Microsoft Dataverse to organize business data

  • Describe the value of Copilots and generative AI features in Microsoft Power Platform

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

  • Describe how Microsoft Power Platform apps work together with Microsoft Dynamics 365 apps

  • Describe how Microsoft Power Platform business solutions work together with Microsoft 365 apps and services

  • Describe how Microsoft Power Platform services work together

  • Describe how Microsoft Power Platform works with Microsoft Teams

Describe Microsoft Power Platform administration and governance

  • Describe the Microsoft Power Platform security model

  • Describe environments

  • Describe the different Microsoft Power Platform admin centers and portals

  • Describe how Microsoft Power Platform supports data privacy and accessibility guidelines

Identify foundational components of Microsoft Power Platform (10–15%)

Describe Microsoft Dataverse

  • Describe differences between traditional databases and Dataverse

  • Describe tables, columns, and relationships in Dataverse

  • Describe business logic in Dataverse

Describe connectors

  • Describe the components of a connector

  • Describe standard, premium, and custom connectors

Demonstrate the capabilities of Power BI (10–15%)

Identify basic Power BI components

  • Describe Power BI Desktop and the Power BI service

  • Compare and contrast dashboards, workspaces, reports, and paginated reports

  • Describe how AI Insights helps identify anomalies and trends in data

Build a basic dashboard by using Power BI

  • Create a Power BI report by adding visualizations

  • Create a Power BI dashboard

  • Add visualizations to dashboards by using Q&A

  • Consume Power BI reports and dashboards

Demonstrate the capabilities of Power Apps (20–25%)

Identify basic Power Apps capabilities

  • Describe the differences between canvas apps and model-driven apps

  • Describe use cases for and capabilities of canvas apps

  • Describe use cases for and capabilities of model-driven apps

Build a basic canvas app

  • Connect to data sources by using connectors

  • Create an app from data

  • Add controls to canvas app screens

  • Build responsive pages by dragging and dropping containers

Build a basic model-driven app

  • Create a model-driven app from tables

  • Modify forms

  • Create and modify views

Demonstrate the capabilities of Power Automate (10–15%)

Identify basic Power Automate components

  • Describe use cases for cloud and desktop flows

  • Describe use cases for cloud flow templates

  • Describe how Power Automate cloud flows use connector triggers and actions

  • Describe Power Automate use cases for approvals, Microsoft Teams, Outlook, SharePoint, and Forms

  • Describe the Power Automate apps including Power Automate for Desktop, Power Automate mobile, and the Power Automate portal

  • Describe actions for Power Automate desktop flows

  • Describe document processing in Power Automate

  • Describe Process Mining and Task Mining

Build a basic Power Automate flow

  • Create a cloud flow by using an instant, automated, or scheduled flow template

  • Describe how to create cloud flows by using Copilot in Power Automate

  • Modify a cloud flow

  • Add flow steps to perform data operations

  • Run a cloud flow

  • Build a basic desktop flow by recording tasks

Demonstrate the capabilities of Power Pages (1–5%)

Describe the capabilities of Power Pages

  • Describe use cases for Power Pages

  • Describe use cases for templates

  • Describe how to share data externally

  • Describe uses cases for creating sites by using Copilot in Power Pages

Describe the AI authoring experience in Microsoft Power Platform (10–15%)

Describe Copilot Studio

  • Describe use cases for Copilot Studio

  • Describe the purpose of topics, entities, and actions

  • Create a topic by using Copilot Studio

  • Describe the process of building bots by using Copilot Studio

Describe the capabilities of AI Builder

  • Describe the business value of AI Builder

  • Describe use cases for AI Builder

  • Describe the lifecycle to create an AI Builder model

Study resources

We recommend that you train and get hands-on experience before you take the exam. We offer self-study options and classroom training as well as links to documentation, community sites, and videos.

Study resources Links to learning and documentation
Get trained Choose from self-paced learning paths and modules or take an instructor-led course
Find documentation Microsoft Power Platform documentation
Power BI documentation
Microsoft Power Apps documentation
Power Automate documentation
Microsoft Power Virtual Agents documentation
Ask a question Microsoft Q&A | Microsoft Docs
Get community support Power Platform Community (microsoft.com)
Follow Microsoft Learn Microsoft Learn - Microsoft Tech Community
Find a video #LessCodeMorePower | Shows
Browse other Microsoft Learn shows

Change log

Key to understanding the table: The topic groups (also known as functional groups) are in bold typeface followed by the objectives within each group. The table is a comparison between the two versions of the exam skills measured and the third column describes the extent of the changes.

Skill area prior to June 21, 2024 Skill area as of June 21, 2024 Change
Audience profile No change
Describe the business value of Microsoft Power Platform Describe the business value of Microsoft Power Platform No % change
Describe the business value of Microsoft Power Platform services Describe the business value of Microsoft Power Platform services No change
Describe the business value of extending business solutions by using Microsoft Power Platform Describe the business value of extending business solutions by using Microsoft Power Platform Minor
Describe Microsoft Power Platform administration and governance Describe Microsoft Power Platform administration and governance No change
Identify foundational components of Microsoft Power Platform Identify foundational components of Microsoft Power Platform No % change
Describe Microsoft Dataverse Describe Microsoft Dataverse No change
Describe connectors Describe connectors No change
Demonstrate the capabilities of Power BI Demonstrate the capabilities of Power BI No % change
Identify basic Power BI components Identify basic Power BI components No change
Build a basic dashboard by using Power BI Build a basic dashboard by using Power BI No change
Demonstrate the capabilities of Power Apps Demonstrate the capabilities of Power Apps No % change
Identify basic Power Apps capabilities Identify basic Power Apps capabilities No change
Build a basic canvas app Build a basic canvas app No change
Build a basic model-driven app Build a basic model-driven app No change
Demonstrate the capabilities of Power Automate Demonstrate the capabilities of Power Automate No % change
Identify basic Power Automate components Identify basic Power Automate components No change
Build a basic Power Automate flow Build a basic Power Automate flow No change
Demonstrate the capabilities of Power Pages Demonstrate the capabilities of Power Pages No % change
Describe the capabilities of Power Pages Describe the capabilities of Power Pages No change
Describe the AI authoring experience in Microsoft Power Platform Describe the AI authoring experience in Microsoft Power Platform No % change
Describe Copilot Studio Describe Copilot Studio No change
Describe the capabilities of AI Builder Describe the capabilities of AI Builder No change

Skills measured prior to June 21, 2024

Audience profile

As a candidate for this exam, you aspire to understand how Microsoft Power Platform technologies can be used to:

  • Develop tailored business solutions.

  • Identify how Microsoft Dataverse supports the interoperability of Microsoft Power Platform.

  • Accelerate business outcomes by using Microsoft Power Apps for low code/no code solutions.

  • Improve processes by using Microsoft Power Automate and Process mining.

  • Identify use cases for Microsoft Power Pages.

  • Help make data-driven technology decisions by using Microsoft Power BI.

  • Evaluate how Copilot can assist with each of these.

The exam is intended for you if you’re seeking to start your journey building solutions with Microsoft Power Platform.

You can use this exam to prepare for role-based or specialty certifications, but it’s not a prerequisite for any of them.

Skills at a glance

  • Describe the business value of Microsoft Power Platform (20–25%)

  • Identify foundational components of Microsoft Power Platform (10–15%)

  • Demonstrate the capabilities of Power BI (5–10%)

  • Demonstrate the capabilities of Power Apps (20–25%)

  • Demonstrate the capabilities of Power Automate (10–15%)

  • Demonstrate the capabilities of Power Pages (1–5%)

  • Describe the AI authoring experience in Microsoft Power Platform (10–15%)

Describe the business value of Microsoft Power Platform (20–25%)

Describe the business value of Microsoft Power Platform services

  • Describe the value of Microsoft Power Apps to build applications

  • Describe the value of Microsoft Power Automate to automate processes

  • Describe the value of Microsoft Power BI to gain insights into data

  • Describe the value of Microsoft Power Pages to build websites

  • Describe the value of connectors to integrate services and data

  • Describe the value of Microsoft Dataverse to organize business data

  • Describe the value of Copilots and generative AI features in Microsoft Power Platform

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

  • Describe how Microsoft Power Platform apps work together with Microsoft Dynamics 365 apps

  • Describe how Microsoft Power Platform business solutions work together with Microsoft 365 apps and services

  • Describe how Microsoft Power Platform apps work together

  • Describe how Microsoft Power Platform works with Microsoft Teams

Describe Microsoft Power Platform administration and governance

  • Describe the Microsoft Power Platform security model

  • Describe environments

  • Describe the different Microsoft Power Platform admin centers and portals

  • Describe how Microsoft Power Platform supports data privacy and accessibility guidelines

Identify foundational components of Microsoft Power Platform (10–15%)

Describe Microsoft Dataverse

  • Describe differences between traditional databases and Dataverse

  • Describe tables, columns, and relationships in Dataverse

  • Describe business logic in Dataverse

Describe connectors

  • Describe the components of a connector

  • Describe standard, premium, and custom connectors

Demonstrate the capabilities of Power BI (10–15%)

Identify basic Power BI components

  • Describe Power BI Desktop and the Power BI service

  • Compare and contrast dashboards, workspaces, reports, and paginated reports

  • Describe how AI Insights helps identify anomalies and trends in data

Build a basic dashboard by using Power BI

  • Create a Power BI report by adding visualizations

  • Create a Power BI dashboard

  • Add visualizations to dashboards by using Q&A

  • Consume Power BI reports and dashboards

Demonstrate the capabilities of Power Apps (20–25%)

Identify basic Power Apps capabilities

  • Describe the differences between canvas apps and model-driven apps

  • Describe use cases for and capabilities of canvas apps

  • Describe use cases for and capabilities of model-driven apps

Build a basic canvas app

  • Connect to data sources by using connectors

  • Create an app from data

  • Add controls to canvas app screens

  • Build responsive pages by dragging and dropping containers

Build a basic model-driven app

  • Create a model-driven app from tables

  • Modify forms

  • Create and modify views

Demonstrate the capabilities of Power Automate (10–15%)

Identify basic Power Automate components

  • Describe use cases for cloud and desktop flows

  • Describe use cases for cloud flow templates

  • Describe how Power Automate cloud flows use connector triggers and actions

  • Describe Power Automate use cases for approvals, Microsoft Teams, Outlook, SharePoint, and Forms

  • Describe the Power Automate apps including Power Automate for Desktop, Power Automate mobile, and the Power Automate portal

  • Describe actions for Power Automate desktop flows

  • Describe document processing in Power Automate

  • Describe Process Mining and Task Mining

Build a basic Power Automate flow

  • Create a cloud flow by using an instant, automated, or scheduled flow template

  • Describe how to create cloud flows by using Copilot in Power Automate

  • Modify a cloud flow

  • Add flow steps to perform data operations

  • Run a cloud flow

  • Build a basic desktop flow by recording tasks

Demonstrate the capabilities of Power Pages (1–5%)

Describe the capabilities of Power Pages

  • Describe use cases for Power Pages

  • Describe use cases for templates

  • Describe how to share data externally

  • Describe uses cases for creating sites by using Copilot in Power Pages

Describe the AI authoring experience in Microsoft Power Platform (10–15%)

Describe Copilot Studio

  • Describe use cases for Copilot Studio

  • Describe the purpose of topics, entities, and actions

  • Create a topic by using Copilot Studio

    Describe the process of building bots by using Copilot Studio

Describe the capabilities of AI Builder

  • Describe the business value of AI Builder

  • Describe use cases for AI Builder

  • Describe the lifecycle to create an AI Builder model