PL-100T00 Microsoft Power Platform App Maker

Introduction:

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.

Objectives:

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

Enroll in this course

$2,500.00

Need Help Finding The Right Training Solution?

Our training advisors are here for you.

USD United States (US) dollar