Welcome to ONLC Training Centers
  1. Home
  2. Courses
  3. Power Apps and Flow
  4. Power Apps and Power Automate: Building Business Solutions

Power Apps and Power Automate: Building Business Solutions Course

Class Dates
(click date for class times)
(click Enroll for locations)
4/9-4/10
Class Dates and Times
04/09/2025Wednesday10:00-4:45 EDT
  9:00-3:45 CDT
  8:00-2:45 MDT
  7:00-1:45 PDT
04/10/2025Thursday 10:00-4:45 EDT
  9:00-3:45 CDT
  8:00-2:45 MDT
  7:00-1:45 PDT

Ready to Run Class
A Ready to Run date will not cancel due to low enrollments. Seats are still available but filling fast - Register soon!

  

Register Soon!
Registrations on or after Thursday 4/3 incur a late registration charge to cover book shipping and provisioning costs.
Before 4/3$995
On/After 4/3$1,095
Last Reg Date4/4
 
5/8-5/9
Class Dates and Times
05/08/2025Thursday 10:00-4:45 EDT
  9:00-3:45 CDT
  8:00-2:45 MDT
  7:00-1:45 PDT
05/09/2025Friday 10:00-4:45 EDT
  9:00-3:45 CDT
  8:00-2:45 MDT
  7:00-1:45 PDT
 
6/5-6/6
Class Dates and Times
06/05/2025Thursday 10:00-4:45 EDT
  9:00-3:45 CDT
  8:00-2:45 MDT
  7:00-1:45 PDT
06/06/2025Friday 10:00-4:45 EDT
  9:00-3:45 CDT
  8:00-2:45 MDT
  7:00-1:45 PDT

Early Notice Class
Early Notice classes have enrollments that suggest that the class will run as scheduled.
 
7/2-7/3
Class Dates and Times
07/02/2025Wednesday10:00-4:45 EDT
  9:00-3:45 CDT
  8:00-2:45 MDT
  7:00-1:45 PDT
07/03/2025Thursday 10:00-4:45 EDT
  9:00-3:45 CDT
  8:00-2:45 MDT
  7:00-1:45 PDT
 
7/31-8/1
Class Dates and Times
07/31/2025Thursday 10:00-4:45 EDT
  9:00-3:45 CDT
  8:00-2:45 MDT
  7:00-1:45 PDT
08/01/2025Friday 10:00-4:45 EDT
  9:00-3:45 CDT
  8:00-2:45 MDT
  7:00-1:45 PDT
 
Fee:  $995

Savings options:

 Learning Credits
Need a price quote?

Follow the link to our self-service price quote form to generate an email with a price quote.

Need a class for a group?

We can deliver this class for your group. Follow the link to request more information.

Email Alert

Receive an email when this class is available as "Ready to Run" or "Early Notice" status.

Train from your home or office

If you have high-speed internet and a computer you can likely take this class from your home or office.


  1. Home
  2. Courses
  3. Power Apps and Flow
  4. Power Apps and Power Automate: Building Business Solutions

Power Apps and Power Automate: Building Business Solutions Course

 

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 nationwide 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.

GENERAL INFO

Class Format
Class Policies
Student Reviews

HAVE QUESTIONS?
First Name

Last Name

Company

Phone

Email

Location

Question/Comment


ONLC TRAINING CENTERS
800-288-8221
www.onlc.com
Our Classes
Why Register with ONLC
Other Information
For Companies
For Professionals
For Government
Live Classes from Home or Office
About ONLC
Other Details
Connect