Duration
4 Days
24 CPD hours
This course is intended for
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.
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.
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