PowerApps and Power Automate (Flow): Building Business Solutions with PowerApps and Power Automate
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.
After providing a foundation for building canvas apps and flows, this course teaches students how to build business solutions with the Common Data Service for Apps (CDSA) by creating custom entities and model-driven apps. The class also examines advanced techniques required in real-word PowerApps scenarios such as creating custom connectors and conducting application lifecycle management (ALM) using managed solutions and multiple environments for development, UAT and production.
Retail Price: $1,195.00
Next Date: 07/02/2025
Course Days: 2
Enroll in Next Date
Request Custom Course
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.
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
