Study guide for Exam PL-100: Microsoft Power Platform App Maker

Warning

This exam will retire on June 30, 2024, at 11:59 PM Central Standard Time. Learn more.

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 January 19, 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 January 19, 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.
Certification renewal Microsoft associate, expert, and specialty certifications expire annually. You can renew by passing a free online assessment on Microsoft Learn.
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 January 19, 2024

Audience profile

As a candidate for this exam, you envision and create business solutions to simplify and automate tasks and processes for yourself and your team. You understand:

  • The data that you work with.

  • The issues that you need to resolve.

  • The required processes and app experiences.

As a candidate for this exam, you may not have formal IT training but are comfortable using technology to solve business problems.

You're self-directed and focus on solving problems by using Microsoft Power Platform as part of your primary job role. You may connect to and use features of apps including:

  • Microsoft Teams

  • Microsoft 365 apps and services

  • Third-party solutions

You have a desire to understand the capabilities and limitations of available tools and how to apply them.

Skills at a glance

  • Design and manage business solutions (35–40%)

  • Analyze and visualize data (10–15%)

  • Create business solutions (50–55%)

Design and manage business solutions (35–40%)

Identify Microsoft Power Platform components

  • Determine the required Microsoft Power Apps app type for a given business scenario

  • Determine which Microsoft Power Platform components meet a given business scenario

  • Describe business logic in Microsoft Dataverse

  • Describe connectors

  • Describe use cases for cloud flows and desktop flows

  • Describe use cases for AI and Microsoft Copilot in Microsoft Power Platform

  • Describe Microsoft Power Platform environments

  • Describe use cases for Power Automate Process Mining

  • Determine reporting options for given business scenarios including views, Microsoft Power BI visualizations, and dashboards

Configure and manage Microsoft Dataverse

  • Create tables and table columns based on a data model

  • Link tables by using lookups

  • Configure Dataverse business rules

  • Describe how Dataverse uses role-based access control (RBAC)

  • Add table permissions to existing Dataverse security roles

  • Create tables and table columns by using Copilot in Dataverse

  • Import and export data by using Microsoft Excel

  • Determine when to use Microsoft Dataverse for Teams or Microsoft Dataverse

Manage Microsoft Power Platform components during development

  • Create a Dataverse solution

  • Export and import a Dataverse solution

  • Export and import a non-solution canvas app or a non-solution cloud flow

  • Add existing components to a Dataverse solution

Analyze and visualize data (10–15%)

Create and consume Microsoft Power BI dashboards

  • Create a simple report from an existing dataset by using Power BI Service

  • Create Power BI dashboards from existing reports

  • Embed Power BI dashboards and tiles in canvas apps and model-driven apps

  • Share Power BI dashboards

Describe AI Builder models

  • Describe use cases for AI Builder

  • Describe the differences between prebuilt models and custom models

  • Describe the process for training custom models

  • Use a model from within Power Automate or Power Apps

Create business solutions (50–55%)

Create and manage model-driven apps

  • Create and configure model-driven apps

  • Create and configure Dataverse table forms

  • Create and configure Dataverse table views

  • Share model-driven apps with other users and groups

  • Create and configure model-driven app dashboards

  • Create and configure model-driven app charts

Create and manage canvas apps

  • Connect to data sources in canvas apps

  • Interpret app checker results

  • Manage versions of canvas apps

  • Publish canvas apps

  • Share canvas apps with other users and groups

  • Add canvas app assets and components

  • Describe modern controls and themes

Create and manage screens for canvas apps

  • Determine when to use screens, forms, containers, galleries, buttons, labels, input controls, images, charts, and custom controls

  • Configure UI elements

  • Implement Power Fx formulas

  • Implement collections and variables

  • Run a Microsoft Power Automate cloud flow from a canvas app

Create Power Automate cloud flows

  • Describe types of triggers

  • Configure triggers

  • Configure flow steps

  • Test and troubleshoot a cloud flow

  • Implement conditional logic

  • Create approvals and monitor the approval process by using Power Automate and Microsoft Teams

  • Share cloud flows

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 Apps documentation
Microsoft Dataverse
Power BI documentation
Power Automate documentation
Microsoft Power Virtual Agents documentation
Planning a Power Apps project
Canvas apps
Model-driven apps
Ask a question Microsoft Q&A | Microsoft Docs
Get community support Power Apps - Power Platform Community
Microsoft Power Automate - Power Platform Community
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 January 19, 2024 Skill area as of January 19, 2024 Change
Audience profile Minor
Design business solutions Design and manage business solutions Increased % change
Create a high-level design Removed
Identify Microsoft Power Platform components Identify Microsoft Power Platform components Major
Design the user interface (UI) for a business solution Removed
Design reporting and visualizations for business solutions Removed
Configure and manage Microsoft Dataverse Added
Manage Microsoft Power Platform components during development Added
Analyze and visualize data Analyze and visualize data No % change
Create and consume Power BI dashboards Create and consume Microsoft Power BI dashboards No change
Describe AI Builder models Describe AI Builder models No change
Create business solutions Create business solutions Decreased % change
Manage Microsoft Power Platform components during development Removed
Create model-driven apps Create and manage model-driven apps Minor
Create and manage canvas apps Create and manage canvas apps Minor
Create screens for canvas apps Create and manage screens for canvas apps Major
Configure Microsoft Dataverse Removed
Create Power Automate flows Create Power Automate cloud flows Major
Create Power Virtual Agents chatbots in Microsoft Teams Removed

Skills measured prior to January 19, 2024

Audience profile

The candidate envisions and creates business solutions to simplify and automate tasks and processes for themselves and their team. They understand the data that they are working with, the issues that they need to resolve, and the required processes and app experiences. The candidate may not have formal IT training but is comfortable using technology to solve business problems.

The candidate is self-directed and focuses on solving problems that they encounter as part of their primary job role. They may connect to and use features of apps including Microsoft Power Platform, Microsoft Teams, Microsoft 365 apps and services, and third-party solutions. The candidate has a desire to understand the capabilities and limitations of available tools and understand how to apply them.

  • Design business solutions (20–25%)

  • Analyze and visualize data (10–15%)

  • Create business solutions (60–65%)

Design business solutions (20–25%)

Create a high-level design

  • Identify existing data sources needed to support a business solution

  • Describe the expected user experience for targeted devices and describe the differences between Microsoft Power Platform app types

  • Describe the expected logic and steps that a process will execute

  • Create a high-level structure for a new data source

Identify Microsoft Power Platform components

  • Determine the required Microsoft Power Apps app type for a business solution

  • Determine when to use Microsoft Dataverse for Teams

  • Map a problem domain to Microsoft Power Platform tools

  • Identify options for implementing business logic

  • Describe connectors

  • Describe uses cases for cloud flows and desktop flows

  • Describe use cases for chatbots

Design the user interface (UI) for a business solution

  • Identify opportunities for component reuse

  • Select UI elements for canvas apps

  • Identify the model-driven forms and Dataverse views that are needed

Design reporting and visualizations for business solutions

  • Select reporting options for business solutions including views, Microsoft Power BI visualizations, and dashboards

  • Define visualizations for Power BI dashboards

  • Define visualizations for model-driven dashboards

  • Define visualizations for canvas apps

Analyze and visualize data (10–15%)

Create and consume Power BI dashboards

  • Create a simple report from an existing dataset by using Power BI Service

  • Create Power BI dashboards from existing reports

  • Embed Power BI dashboards and tiles in canvas apps and model-driven apps

  • Share Power BI dashboards

Describe AI Builder models

  • Describe use cases for AI Builder

  • Describe differences between prebuilt models and custom models

  • Describe the process for training custom models

  • Use a model from within Microsoft Power Automate or Microsoft Power Apps

Create business solutions (60–65%)

Manage Microsoft Power Platform components during development

  • Create a publisher in Dataverse

  • Create a Dataverse solution

  • Export or import Dataverse solution

  • Export or import a canvas app or a cloud flow

  • Add existing apps and flows to a Dataverse solution

Create model-driven apps

  • Create model-driven apps

  • Create and configure Dataverse table forms

  • Create and configure Dataverse table views

  • Share model-driven apps with other users and groups

  • Create and configure model-driven dashboards

Create and manage canvas apps

  • Connect to data sources in canvas apps

  • Interpret App checker results

  • Manage versions of canvas apps

  • Publish canvas apps

  • Share canvas apps with other users and groups

  • Build canvas apps screens

  • Add canvas app assets and components to screens

Create screens for canvas apps

  • Determine when to use forms, galleries, button, labels, input controls, images, and custom controls

  • Configure UI elements

  • Implement Power Fx formulas

  • Implement collections and variables

  • Run a cloud flow from a canvas app

Configure Microsoft Dataverse

  • Create tables and table columns based on a data model

  • Link tables by using lookups

  • Describe use cases and capabilities of business rules

  • Create Dataverse business rules

  • Describe how Dataverse uses role-based access control (RBAC)

  • Add table permissions to existing Dataverse security roles

Create Power Automate flows

  • Describe types of triggers for cloud flows

  • Create cloud flows

  • Configure triggers for cloud flows

  • Configure flow actions

  • Test a cloud flow and interpret flow checker results

  • Implement conditional logic for a cloud flow

  • Create approvals and monitor the approval process by using Power Automate and Teams

  • Share cloud flows

  • Create a desktop flow for personal use

Create Microsoft Power Virtual Agents chatbots in Microsoft Teams

  • Identify use cases and capabilities for chatbots

  • Create a chatbot that uses topics and trigger phrases

  • Test a chatbot

  • Publish a chatbot