PL-100T00 Microsoft Power Platform App Maker

Skip to Scheduled Dates

Course Overview

NOTE: This course has been retired by Microsoft as of 6/28/24. Replacement courses are:

  • PL-7001 Create and Manage Canvas Apps with Power Apps
  • PL-7002 Create and Manage Automated Processes by using Power Automate
  • PL-7003 Create and Manage Model-Driven Apps with Power Apps and Dataverse

    This course will teach you how to build apps with low-code techniques to simplify, automate, and transform business tasks and processes using Microsoft Power Platform. This course contains a 1-day Applied Workshop. This workshop will allow you to practice your App Maker skills by creating an end-to-end solution to solve a problem for a fictitious company. The solution will include a Microsoft Dataverse database, Power Apps canvas app, and Power Automate flows.

    Who Should Attend

    The App Maker builds solutions to simplify, automate, and transform tasks and processes for themselves and their team where they have deep expertise in the solution business domain. They have basic data modeling, user experience design, requirements analysis, and process analysis skills. The App Maker creates and enforces business processes, structures digital collection of information, improves efficiency of repeatable tasks, and automates business processes. The App Maker uses the Maker tools of Power Platform to solve business problems. They may use advanced features of Microsoft apps and third-party productivity tools. The App Maker is aware of the capabilities and limitations of available tools and understands how to apply them. The App Maker is self-directed, and solution focused. They may not have formal IT training but are comfortable using technology to solve business problems with a personal growth mindset. They understand the operational need and have a vision of the desired outcome. They approach problems with phased and iterative strategies.

    Course Outline

    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

    •  Back to Course Search

    Class Dates & Times

    Class times are listed Central time

    This is a 3-day class

    Class dates not listed.
    Please contact us for available dates and times.