Overview
Building Business Solutions with Power Apps and Power Automate is a 2-day training class designed for people who have already begun working with PowerApps and are ready to move their Power Apps and Power Automate skills to the next level. This class is designed for the "citizen developer" (an individual with subject matter expertise but with little formal IT background) who is developing applications on their own or in coordination with "pro" developers.
Students will learn best practices for building Model-Driven (Dataverse) and canvas apps and flows to update and manage content in Azure SQL, SharePoint Online, Excel workbooks, and OneDrive for Business.
Review of Microsoft Power Platform
What is Microsoft Power Platform?
The business value of Microsoft Power Platform
Data Connectors
Data loss prevention, compliance, privacy, accessibility
Create tables in Dataverse
Introduction to Microsoft Dataverse
Table characteristics
Dual-write vs virtual tables
Dataverse auditing
Exercise: Create a Microsoft Dataverse table
Import data into your Microsoft Dataverse database
Exercise: Create a custom table and import data
Manage tables in Dataverse
Identify tables and table types in Dataverse
Create a custom table
Enable attachments within a table
Licensing requirements for each table type
Lab: Create a new custom table and enable attachments
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
Create a primary name column
Restrictions that apply to the columns in a table
Create a numbering column
Create an alternate key
Exercises
Create a relationship between tables in Dataverse
Relate one or more tables
Relationship types that are available in Microsoft Dataverse
Create a one-to-many relationship between tables
Create a many-to-many relationship between tables
Edit or delete relationships
Exercise - Create two tables and relate them by using a one-to-many relationship
Working with choices in Dataverse
Define a choice column
Standard choices column
Lab: Create a new choice or modify an existing choice
Get started with security roles in Dataverse
Introduction to environment roles
Understand environment roles
Adding or disabling an environment user
Understand security concepts in Dataverse
Understand user security roles and security role defaults
Exercise - Create a custom role
Check the roles that a user belongs to
Configure Dataverse teams for security
Configure Dataverse group teams for security
Get started with model-driven apps in Power Apps
Introducing model-driven apps
Building blocks of model-driven apps
Design model-driven apps
Exercise
Exercise - Control security when sharing model-driven apps
Incorporate business process flows
Exercise - Create a model-driven app
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
Use specialty views
Configure charts overview
Dashboards overview
Use interactive streams and tiles
Get started with Power Automate
Introducing Power Automate
Exercise - Create your first flow
Exercise - Create recurring flows
Exercise - Monitor incoming emails
Exercise - Share flows
Troubleshoot flows
Use Dataverse triggers and actions in Power Automate
Introduction
Dataverse triggers
Use triggers
Work with Dataverse actions
Extend Dataverse with Power Automate
Introduction
Set up a flow and configure its trigger
Email Dataverse record
Add to-do items
Test and run your flow
Introduction to expressions in Power Automate
Introduction to expressions
Get started with expressions
Notes make things easier
Types of functions
Write complex expressions
Exercise - Creating a manual flow and using expressions
Students should already be familiar with Microsoft Excel, Office 365 and SharePoint Online. It is also recommended that students attend the Designing Modern Forms and Workflows with Microsoft PowerApps and Microsoft Flow training before taking this class or have the equivalent hands-on experience with PowerApps and Power Automate.
