PL-100T00 Microsoft Power Platform App Maker

1 – Get started with Microsoft Power Platform for app makers

• Identify components
• Create apps
• Get started with Microsoft Dataverse
• Work with Copilot in Microsoft Power Platform

2 – Create tables in Dataverse

• Table characteristics
• Table relationships
• Dataverse logic and security
• Dataverse auditing
• Dual-write vs. virtual tables

3 – Create and manage columns within a table in Dataverse

• Define columns in Microsoft Dataverse
• Column types in Microsoft Dataverse
• Add a column to a table
• Primary name column
• Restrictions that apply to columns in a table
• Create an auto numbering column
• Create an alternate key

4 – Load/export data and create data views in Dataverse

• View data in a table
• Create or edit views of data in a table
• Dataverse data import options
• Load data into a table
• Dataverse data export options
• Export
• Add, update, or delete data in a table by using Excel
• Import data using Power Query

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

• Export data to Excel
• Edit and update data in Excel

6 – Get started with Microsoft Dataverse for Teams

• Dataverse for Teams vs Dataverse
• Provision your first Dataverse environment
• Create your first table to store data

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

• Create your first app with the hero template
• Customize your app with Power Apps Studio
• Publish your app
• Install template apps

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

• Types of workflows that Power Automate can build in Dataverse
• Schedule a flow

9 – Create reports with Power BI and Dataverse for Teams

• Connect to and transform Dataverse for Teams data from Power BI
• Create a Power BI report
• Publish the report
• Share the data

10 – Get started building with Power BI

• Use Power BI
• Building blocks of Power BI
• Tour and use the Power BI service

11 – Explore what Power BI can do for you

• What can I do with the Power BI service as a consumer?
• View content in the Power BI service
• Collaborate and share in Power BI
• Find and view dashboards and reports

12 – Create and manage workspaces in Power BI

• Distribute a report or dashboard
• Monitor usage and performance
• Recommend a development life cycle strategy
• Troubleshoot data by viewing its lineage
• Configure data protection

13 – Manage semantic models in Power BI

• Use a Power BI gateway to connect to on-premises data sources
• Configure a semantic model scheduled refresh
• Configure incremental refresh settings
• Manage and promote semantic models
• Troubleshoot service connectivity
• Boost performance with query caching (Premium)

14 – Create dashboards in Power BI

• Configure data alerts
• Explore data by asking questions
• Review Quick insights
• Add a dashboard theme
• Pin a live report page to a dashboard
• Configure a real-time dashboard
• Set mobile view

15 – Implement row-level security

• Configure row-level security with the static method
• Configure row-level security with the dynamic method

16 – Create dashboards in Power BI

• Configure data alerts
• Explore data by asking questions
• Review Quick insights
• Add a dashboard theme
• Pin a live report page to a dashboard
• Configure a real-time dashboard
• Set mobile view

17 – Secure, publish, and share data in Power BI

• Share and use reports in Power BI
• Row-level security
• Publish a report to a Power BI workspace
• Share reports and user experience
• Protect data in Power BI
• Data refresh and alerts

18 – Embed Power BI content

• Embed Power BI reports
• Embed other Power BI content types
• Optimize the embedding experience

19 – How to build your first model-driven app with Dataverse

• Model-driven apps, powered by Microsoft Dataverse
• Explore sample apps

20 – Get started with model-driven apps in Power Apps

• Introducing model-driven apps
• Components of model-driven apps
• Design model-driven apps
• Incorporate business process flows

21 – Configure forms, charts, and dashboards in model-driven apps

• Forms overview
• Form elements
• Configure multiple forms
• Use specialized form components
• Configure views overview
• Configure grids
• Create and edit views
• Configure charts overview
• Dashboards overview
• Use interactive streams and tiles

22 – Manage Dynamics 365 model-driven app settings and security

• Configure role-based security
• Manage teams and business units
• Explore settings and customizations

23 – Use specialized components in a model-driven form

• Create business process flows
• 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

24 – Get started with Power Apps canvas apps

• Start Power Apps
• Power Apps data sources
• Use Power Apps with Power Automate and Power BI
• Designing a Power Apps app

25 – Customize a canvas app in Power Apps

• Improve your app by making basic customizations
• Explore controls and screens in canvas apps

26 – How to build the User Interface in a canvas app in Power Apps

• Use themes to quickly change the appearance of your app
• Brand a control
• Icons
• Images
• Personalization
• Build for phones or tablets

27 – Navigation in a canvas app in Power Apps

• Understanding navigation
• The Navigate and Back functions
• More ways to use the Navigate function

28 – Manage apps in Power Apps

• Power Apps review

29 – Build a mobile-optimized app from Power Apps

• Learn about mobile-optimized apps
• Identify components to make a canvas app mobile-optimized
• Create a mobile-optimized app that uses responsive designs
• Identify performance considerations for a mobile-optimized canvas app

30 – Use and understand Controls in a canvas app in Power Apps

• Core properties of controls
• Entering and displaying data with text controls
• Additional controls for enhancing your app’s usability
• Media
• Modern controls
• Work with component libraries

31 – Create formulas to change properties in a Power Apps canvas app

• Formulas overview
• Use a formula to modify the format of controls
• Use formulas to perform calculations
• Use a control to modify the property of other controls
• Conditional formatting
• Functions for validating data

32 – Use imperative development techniques for canvas apps in Power Apps

• Imperative versus declarative development
• The three types of variables in Power Apps
• Global variables
• Contextual variables
• Collections
• Additional variable concepts

33 – Manage apps in Power Apps

• Power Apps review

34 – Create formulas to change properties in a Power Apps canvas app

• Formulas overview
• Use a formula to modify the format of controls
• Use formulas to perform calculations
• Use a control to modify the property of other controls
• Conditional formatting
• Functions for validating data

35 – Create formulas to change behaviors in a Power Apps canvas app

• Formulas and functionality
• Understanding true and false
• Understanding control behaviors and actions
• Performing multiple actions in a formula
• Control the display mode through a formula
• Use controls and functions to create a dynamic formula

36 – Author a basic formula that uses tables and records in a Power Apps canvas app

• Records and tables
• Using the Table function
• Store a table
• Filter your table
• Use the lookup function to return a record
• Additional table functions

37 – Build a canvas app for a real estate solution with Copilot in Power Apps

38 – Get started with Power Automate

• Introducing Power Automate
• Create your first flow
• Troubleshoot flows

39 – Build approval flows with Power Automate

• Provide solutions to real-world scenarios.

40 – Build flows to manage user information

41 – Power Automate’s deep integration across multiple data sources

42 – Use the Admin center to manage environments and data policies in Power Automate

• Administer flows
• Export and import flows
• Learn how to distribute button flows

43 – Use AI Builder in Power Automate

• AI Builder in Power Automate saves time
• Advanced usage of AI Builder in Power Automate

44 – Optimize your business process with process advisor

• Get familiar with process advisor
• Create your first recording
• Edit recordings and group actions
• Analyze recordings and interpret results
• Automation recommendations

45 – Optimize your business process with process advisor

• Get familiar with process advisor
• Create your first recording
• Edit recordings and group actions
• Analyze recordings and interpret results
• Automation recommendations

46 – Build flows for a real estate solution using Copilot in Power Automate

• When to use Copilot in Power Automate

47 – Use Dataverse triggers and actions in Power Automate

• Dataverse triggers
• Query data
• Create, update, delete, and relate actions

48 – Create tables in Dataverse

• Table characteristics
• Table relationships
• Dataverse logic and security
• Dataverse auditing
• Dual-write vs. virtual tables

49 – Create and manage columns within a table in Dataverse

• Define columns in Microsoft Dataverse
• Column types in Microsoft Dataverse
• Add a column to a table
• Primary name column
• Restrictions that apply to columns in a table
• Create an auto numbering column
• Create an alternate key

50 – Get started with Power Apps canvas apps

• Start Power Apps
• Power Apps data sources
• Use Power Apps with Power Automate and Power BI
• Designing a Power Apps app

51 – How to build the User Interface in a canvas app in Power Apps

• Use themes to quickly change the appearance of your app
• Brand a control
• Icons
• Images
• Personalization
• Build for phones or tablets

52 – Get started with Power Automate

• Introducing Power Automate
• Create your first flow
• Troubleshoot flows

53 – Challenge Project – Build a booking requests app with Power Apps and Power Automate

• Prepare