Microsoft Power Platform App Maker (PL-100T00) (AA-MPL-100T00)

Module 1: Get started with Microsoft Power Platform for app makers

• How to identify which Microsoft Power Platform component to use based on a specific scenario.
• How to determine what type of app you should create based on your needs.
• Dataverse and directions on when and how to apply it.
• Environments and how makers use them.
• Copilot and why it matters to you as a maker.

Module 2: Create tables in Dataverse

• Create tables with Dataverse
• Import data into a Dataverse database

Module 3: Create and manage columns within a table in Dataverse

• What a column is in Dataverse.
• The types of columns that are available in Dataverse.
• How to add a column to a table.
• What a primary name column is in Dataverse.
• How to identify restrictions that are associated with columns.
• How to create an auto-numbering column.
• How to create an alternate key.

Module 4: Load/export data and create data views in Dataverse

• View data within a table.
• Create or edit views of data in a table.
• Load data into a table.
• Export data from a table.
• Add, update, or delete data in a table by using Excel.
• Import data using Power Query in Maker Portal
• Generate a new dataflow from an Excel Template
• Learn about dataflows

Module 5: Export data from Dataverse and use Microsoft Excel to edit records

• Learn how to export data from Dataverse into Excel files.
• Discover the different exported file types.
• Learn about the security concepts for the exported data.

Module 6: Get started with Microsoft Dataverse for Teams

• Learn how to build apps, workflows, chatbots, and dashboards.
• Learn how to provision Dataverse for Teams and then create a table for your data.

Module 7: Build your first app with Power Apps and Dataverse for Teams

• Create an app by using the hero template.
• Customize and publish your app.
• Install templates.

Module 8: Build your first workflow with Power Automate and Dataverse for Teams

• Build a flow to respond to changes in Teams.
• Extend an app in Microsoft Power Apps to trigger a flow.
• Schedule a flow to complete routine tasks.

Module 9: Create reports with Power BI and Dataverse for Teams

• Import a Microsoft Dataverse dataset into Power BI.
• Create a new Power BI report based on the dataset.
• Edit a report.
• Share a report with others in Teams channels, chats, or meetings.

Module 10: Get started building with Power BI

• How Power BI services and applications work together.
• Explore how Power BI can make your business more efficient.
• How to create compelling visuals and reports.

Module 11: Explore what Power BI can do for you

• Understand basic concepts and terminology of the Power BI service.
• Find your content in dashboards, reports, and apps.
• View and export data from dashboards and reports.
• View filters that are used in a report.
• Explain the relationship between dashboards and reports, visualizations, and tiles.
• Display action menus for tiles and details for report visualizations.
• Collapse and expand the nav pane and the filters and bookmarks panes.
• Subscribe to a dashboard and report.
• Set a data alert.
• Collaborate by using dashboard commenting.

Module 12: Manage workspaces and datasets in Power BI

• Create and manage workspaces in Power BI
• Manage semantic models in Power BI
• Create dashboards in Power BI
• Implement row-level security

Module 13: Create dashboards in Power BI

• Set a mobile view.
• Add a theme to the visuals in your dashboard.
• Add real-time semantic model visuals to your dashboards.
• Pin a live report page to a dashboard.

Module 14: Secure, publish, and share data in Power BI

• Share reports in Power BI.
• Create scorecards with goals in Power BI.
• Configure row-level security for a Power BI report.
• Publish a Power BI data model to a workspace.
• Control access to a workspace.
• Create comments and personal bookmarks in a report.
• Use endorsements to certify or promote datasets.
• Protect data with Microsoft Purview Information Protection.
• Apply refresh and alert schedules for a Power BI report.

Module 15: Embed Power BI content

• Programmatically embed all types of Power BI content.
• Optimize the embedding experience.

Module 16: How to build your first model-driven app with Dataverse

• Discover the value and key features of Dataverse.
• Learn about the value and key features of model-driven apps.
• Explore sample model-driven template apps.

Module 17: Get started with model-driven apps in Power Apps

• Model-driven app design
• Creating a model-driven app

Module 18: Configure forms, charts, and dashboards in model-driven apps

• Use form elements and controls
• Configure forms
• Use specialized form components
• Use editable grids
• Identify views and use public views
• Learn how to configure charts
• Learn how to configure dashboards

Module 19: Manage Dynamics 365 model-driven app settings and security

• Manage role-based security
• Explore customization functionality and customize themes

Module 20: Use specialized components in a model-driven form

• Learn about other components in a model-driven form.
• Create a business process flow.
• Embed a canvas app in a model-driven form.
• Add a timeline in a model-driven form.
• Create a report in a model-driven form.

Module 21: Create a canvas app in Power Apps

• Get started with Power Apps canvas apps
• Customize a canvas app in Power Apps
• How to build the User Interface in a canvas app in Power Apps
• Navigation in a canvas app in Power Apps
• Manage apps in Power Apps
• Build a mobile-optimized app from Power Apps

Module 22: Use and understand Controls in a canvas app in Power Apps

• Understand how to use controls in a canvas app
• Use the different types of controls
• Understand how Galleries and Forms relate to controls

Module 23: Create formulas to change properties in a Power Apps canvas app

• Understand the basics of how to use formulas in a canvas app
• Change the format of a date control
• Use a formula to do simple math calculations
• Change the position of an icon using a formula
• Understand how to implement conditional formatting in canvas apps using a formula

Module 24: Use imperative development techniques for canvas apps in Power Apps

• Understand imperative vs. declarative development.
• Understand the variables in Power Apps.
• Understand when to utilize each of the three different types of variables.

Module 25: Manage apps in Power Apps

• Learn how to view and restore app versions.
• Explore how to share an app, including permissions and notifications.
• Learn about what environments are, how to create them, and how to manage security.
• Find more information about Power Apps.

Module 26: Use basic formulas to make better Power Apps canvas apps

• Create formulas to change properties in a Power Apps canvas app
• Create formulas to change behaviors in a Power Apps canvas app
• Author a basic formula that uses tables and records in a Power Apps canvas app

Module 27: Build a canvas app for a real estate solution with Copilot in Power Apps

• Create a canvas app by using Copilot in Power Apps.
• Customize the Dataverse table data that Copilot generates.
• Add more data to the table.

Module 28: Automate a business process using Power Automate

• Get started with Power Automate
• Build approval flows with Power Automate
• Build flows to manage user information
• Power Automate's deep integration across multiple data sources
• Use the Admin center to manage environments and data policies in Power Automate
• Use AI Builder in Power Automate
• Optimize your business process with process advisor

Module 29: Optimize your business process with process advisor

• Create your first recording.
• Edit recordings and group actions.
• Analyze recordings and interpret results.

Module 30: Build flows for a real estate solution using Copilot in Power Automate

• Features and capabilities of Copilot in Power Automate.
• How to create and manage flows with Copilot in Power Automate.

Module 31: Use Dataverse triggers and actions in Power Automate

• Dataverse triggers and actions in Power Automate.
• Other available inputs.

Module 32: Validate your app maker skills

• Create tables in Dataverse
• Create and manage columns within a table in Dataverse
• Get started with Power Apps canvas apps
• How to build the User Interface in a canvas app in Power Apps
• Get started with Power Automate
• Challenge Project - Build a booking requests app with Power Apps and Power Automate

You will learn to :

• Get started with Microsoft Power Platform for app makers
• Create tables in Dataverse
• Create and manage columns within a table in Dataverse
• Load/export data and create data views in Dataverse
• Export data from Dataverse and use Microsoft Excel to edit records
• Get started with Microsoft Dataverse for Teams
• Build your first app with Power Apps and Dataverse for Teams
• Build your first workflow with Power Automate and Dataverse for Teams
• Create reports with Power BI and Dataverse for Teams
• Get started building with Power BI
• Explore what Power BI can do for you
• Manage workspaces and datasets in Power BI
• Create dashboards in Power BI
• Secure, publish, and share data in Power BI
• Embed Power BI content
• How to build your first model-driven app with Dataverse
• Get started with model-driven apps in Power Apps
• Configure forms, charts, and dashboards in model-driven apps
• Manage Dynamics 365 model-driven app settings and security
• Use specialized components in a model-driven form
• Create a canvas app in Power Apps
• Use and understand Controls in a canvas app in Power Apps
• Create formulas to change properties in a Power Apps canvas app
• Use imperative development techniques for canvas apps in Power Apps
• Manage apps in Power Apps
• Use basic formulas to make better Power Apps canvas apps
• Build a canvas app for a real estate solution with Copilot in Power Apps
• Automate a business process using Power Automate
• Optimize your business process with process advisor
• Build flows for a real estate solution using Copilot in Power Automate
• Use Dataverse triggers and actions in Power Automate
• Validate your app maker skills

• Basic data modeling, user experience design, requirements analysis, and process analysis skills.
• A personal growth mindset and are comfortable using technology to solve business problems.
• An understanding of the operational need and have a vision of the desired outcome. They approach problems with phased and iterative strategies.