Power Apps and Power Automate: Building Business Solutions

Course Description:

The Power Apps and Power Automate: Building Business Solutions course is a 2-day session designed for students who have already begun working with PowerApps and are ready to move their Power Apps and Power Automate skills to the next level. The course was 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.

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

Module 2: Creating tables in Dataverse
Introduction to Microsoft Dataverse
Table characteristics
Dual-write vs virtual tables
Dataverse auditing
Exercise: Creating a Microsoft Dataverse table
Import data into your Microsoft Dataverse database
Exercise: Creating a custom table and import data

Module 3: Manage tables in Dataverse
Identify tables and table types in Dataverse
Creating a custom table
Enable attachments within a table
Licensing requirements for each table type
Lab: Creating a new custom table and enable attachments

Module 4: Creating and manage columns within a table in Dataverse
Define columns in Microsoft Dataverse
Column types in Microsoft Dataverse
Add a column to a table
Creating a primary name column
Restrictions that apply to the columns in a table
Creating a numbering column
Creating an alternate key
Exercises

Module 5: Creating a relationship between tables in Dataverse
Relate one or more tables
Relationship types that are available in Microsoft Dataverse
Creating a one-to-many relationship between tables
Creating a many-to-many relationship between tables
Edit or delete relationships

Exercise - Creating two tables and relate them by using a one-to-many relationship

Module 6: Working with choices in Dataverse
Define a choice column
Standard choices column
Lab: Creating a new choice or modify an existing choice

Module 7: 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 - Creating a custom role
Check the roles that a User belongs to
Configuring Dataverse teams for security
Configuring Dataverse group teams for security

Module 8: 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 - Creating a model-driven app

Module 9: Configuring forms, charts, and dashboards in model-driven apps
Forms overview
Form elements
Configuring multiple forms
Using specialized form components
Configuring views overview
Configuring grids
Using specialty views
Configuring charts overview
Dashboards overview
Using interactive streams and tiles

Module 10: Get started with Power Automate
Introducing Power Automate

Exercise - Creating your first flow

Exercise - Creating recurring flows

Exercise - Monitor incoming emails

Exercise - Share flows
Troubleshoot flows

Module 11: Using Dataverse triggers and actions in Power Automate
Introduction
Dataverse triggers
Using triggers
Work with Dataverse actions

Module 12: Extend Dataverse with Power Automate
Introduction
Set up a flow and Configuring its trigger
Email Dataverse record
Add to-do items
Test and run your flow

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

We offer live-instructor group training classes for your team.

Upskill your team from the comfort of your office or online.

Benefits of Group Training Include:

• Experienced Professional Instructor Trains Your Team
• Content Focused On Your Team's Needs
• Convenient Scheduling and Class Setup
• Significant Per/Student Cost Savings
• Online, On-Site and Blended Options Available

Get A Free Consultation