Power Apps and Power Automate (Flow): Level 2: Building Business Solutions with Power Apps and Power Automate


Duration: 3 days

During this three-day boot camp students learn practices for building canvas apps and flows to update and manage content in Azure SQL, SharePoint Online, Excel workbooks and OneDrive for Business.

Once the student learns the foundation for building canvas apps and flows, student then learn how to build business solutions with the Common Data Service for Apps (CDSA0 by creating custom entities and model-driven apps. Examinations of advanced techniques in a needed in real-world PowerApps scenarios such as creating custom connectors and conducting application lifecycle management (ALM) using managed solutions and multiple environments for development, UAT and production.

It is recommended that student have the following prior to taking this boot camp

Knowledge of Microsoft Excel, office 365, and SharePoint online

Designing Modern Forms and Workflows with Microsoft PowerApps and Microsoft Flow

Hands-on experience with PowerApps and Flow


Module 1: Getting Started with the Power Platform

  • Overview of the Power Platform
  • Writing Expressions for Screen and Control Properties
  • Understanding Connectors and Data Binding
  • Building Canvas Apps Targeting Mobile Devices


Module 2: Building Data-Driven Canvas Apps

  • Displaying Data using Galleries and Item Templates
  • Using Table Functions to Filter and Sort Data
  • Understanding How Delegation Works
  • Updating Data using Edit Forms and Data Cards
  • Customizing SharePoint List Forms

Module 3: Building a Canvas App with A Shopping Cart

  • Caching Application State using Variables and Collections
  • Using a Collection to Track Shopping Cart Data
  • Designing the shopping Cart User Browsing Experience
  • Writing Shopping Cart Data to Back to SharePoint
  • Designing Reusable Components

Module 4: Getting Started with Microsoft Flow

  • Building flows using Triggers and Actions
  • Using Control-of-Flow Actions
  • Writing Advanced Flow Expressions
  • Executing a Flow from a Canvas App
  • Handling Flow Execution Errors

Module 5: building Flow to Manage Content and Approvals

  • Reading and Writing SharePoint List content
  • Uploading Documents, Images and Photos
  • Using Flow to Generate Word and PDF Files
  • Using Flow to Automate Approval Processes
  • Managing Approvals using Approvals Center

Module 6: Integrating PowerApps and Flow with Power BI

  • Overview of Power BI Integration Features
  • Embedding Power BI Dashboard Tiles in PowerApps
  • Extending Power BI Reports using Canvas Apps
  • Designing Flows to Update Real-time Dashboards
  • Triggering Flows using Power BI dashboard Alerts

Module 7: Getting Started with the Common Data Service

  • Common Data Service for Apps Overview
  • Importing Data into the CDSA
  • working with Standard Entities
  • Accessing CDSA From a Canvas App
  • Customizing Standard entities
  • Creating a Custom Entity

Module 8: Building Model-Driven Apps

  • Introduction to Model-Driven Apps
  • Building Site Maps for User Navigation
  • Customizing Entity Views and Forms
  • Creating Business Rules
  • Creating Business Process Flows Customizing the Views for an Entity


Module 9: Integrating PowerApps with External Systems

  • Calling External Services using HTTP Actions
  • Executing Child Flows from a Parent Flow
  • Processing Microsoft Forms using HTTP Trigger
  • Creating and Testing Custom Connector
  • Connecting to Data using the On-premises Gateway

Module 10:P PowerApps ALM using Managed Solutions

Understanding Environments and DLP Policies

Single-environment ALM Strategies

Exporting and importing Canvas Apps and Flows

Understanding Publishers and Solutions

Exporting and Importing Solutions

ALM using Managed Solutions