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 April 8, 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 April 8, 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 April 8, 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
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 April 8, 2024 | Skill area as of April 8, 2024 | Change |
|---|---|---|
| Audience profile | Major | |
| 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 | Major |
| 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 | Minor |
| Identify foundational components of Microsoft Power Platform | Identify foundational components of Microsoft Power Platform | No % change |
| Describe Microsoft Dataverse | Describe Microsoft Dataverse | Minor |
| Describe connectors | Describe connectors | Minor |
| Demonstrate the capabilities of Power BI | Demonstrate the capabilities of Power BI | No % change |
| Identify basic Power BI components | Identify basic Power BI components | Minor |
| 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 | Minor |
| 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 | % of exam decreased |
| Identify basic Power Automate components | Identify basic Power Automate components | Minor |
| Build a basic Power Automate flow | Build a basic Power Automate flow | Minor |
| Describe complementary Microsoft Power Platform solutions | Demonstrate the capabilities of Power Pages | % of exam decreased |
| Describe the capabilities of Power Virtual Agents | Removed | |
| Describe the capabilities of Power Pages | Describe the capabilities of Power Pages | Minor |
| Describe the capabilities of AI Builder | Removed | |
| Describe the AI authoring experience in Microsoft Power Platform | New | |
| Describe Copilot Studio | Added | |
| Describe the capabilities of AI Builder | Added |
Skills measured prior to April 8, 2024
Audience profile
As a candidate for this exam, you aspire to understand how Microsoft Power Platform technologies can be used to:
Improve processes.
Help drive business outcomes.
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 (15–20%)
Describe complementary Microsoft Power Platform solutions (15–20%)
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 Microsoft Power Virtual Agents to create chatbots
Describe the value of connectors to integrate services and data
Describe the value of Microsoft Dataverse to organize business data
Describe the value of AI Builder to enhance apps and flows
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 how Microsoft Power Platform business solutions can consume Microsoft Azure services
Describe Microsoft Power Platform administration and governance
Describe the Microsoft Power Platform security model
Describe environments
Describe where to perform specific administrative tasks including Microsoft Power Platform admin center and Microsoft 365 admin center
Describe how Microsoft Power Platform supports 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 dataflows for Dataverse
Describe connectors
Describe the components of a connector
Describe standard and premium connectors
Identify use cases for 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 to clean and transform data by using Power Query
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 a basic model-driven app
Create a model-driven app from tables
Modify forms
Create and modify views
Demonstrate the capabilities of Power Automate (15–20%)
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
Build a basic Power Automate flow
Create a cloud flow by using an instant, automated, or scheduled flow template
Modify a cloud flow
Add flow steps to perform data operations
Run a cloud flow
Build a basic desktop flow by recording tasks
Describe complementary Microsoft Power Platform solutions (15–20%)
Describe the capabilities of Power Virtual Agents
Describe use cases for Power Virtual Agents
Describe the purpose of topics, entities, and actions
Create topics from existing FAQs by using Suggest topics
Describe the capabilities of Power Pages
Describe use cases for Power Pages
Describe use cases for templates
Describe how to share data externally
Describe the capabilities of AI Builder
Describe use cases for AI Builder, including Sentiment Analysis and receipt processing
Describe the lifecycle to create an AI Builder model