Power Apps and Power Automate: Building Business Solutions Course Outline

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.

Prerequisites
Students should already be familiar with Microsoft Excel, Office 365 and SharePoint Online. It is also recommended that students attend ONLC's Power Apps: Introduction for End Users before taking this more advanced level class or have the equivalent hands-on experience with PowerApps and Power Automate. For more information on the prerequisite class, go to:
Power Apps: Introduction for End Users


COURSE OUTLINE

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

Module 3: 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

Module 4: 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

View outline in Word

RPABBS

Attend hands-on, instructor-led Power Apps and Power Automate: Building Business Solutions training classes at ONLC's more than 300 locations. Not near one of our locations? Attend these same live classes from your home/office PC via our Remote Classroom Instruction (RCI) technology.

For additional training options, check out our list of Power Apps and Flow Courses and select the one that's right for you.