Toll Free - 877-442-3915

Account | Self-Paced Login

Account | Self-Paced Login | 877-442-3915

PowerApps and Flow: Level 2 - Building Business Solutions with PowerApps and Flow Course

PowerApps and Flow: Level 2 - Building Business Solutions with PowerApps and Flow Training Course


Course Description:

Training Dates
(Click on the course name below to view course details and full list of class dates)

PowerApps and Flow: Level 2 - Building Business Solutions with PowerApps and Flow
Locations: Available Nationwide and Online
Class Date(s): 10/12/2020 - 10/14/2020
Course Fee : $1795


PowerApps and Flow: Level 2 - Building Business Solutions with PowerApps and Flow
Locations: Available Nationwide and Online
Class Date(s): 11/9/2020 - 11/11/2020
Course Fee : $1795


PowerApps and Flow: Level 2 - Building Business Solutions with PowerApps and Flow
Locations: Available Nationwide and Online
Class Date(s): 12/7/2020 - 12/9/2020
Course Fee : $1795


PowerApps and Flow: Level 2 - Building Business Solutions with PowerApps and Flow
Locations: Available Nationwide and Online
Class Date(s): 1/4/2021 - 1/6/2021
Course Fee : $1795


PowerApps and Flow: Level 2 - Building Business Solutions with PowerApps and Flow
Locations: Available Nationwide and Online
Class Date(s): 2/1/2021 - 2/3/2021
Course Fee : $1795


PowerApps and Flow: Level 2 - Building Business Solutions with PowerApps and Flow
Locations: Available Nationwide and Online
Class Date(s): 3/1/2021 - 3/3/2021
Course Fee : $1795


PowerApps and Flow: Level 2 - Building Business Solutions with PowerApps and Flow
Locations: Available Nationwide and Online
Class Date(s): 3/29/2021 - 3/31/2021
Course Fee : $1795


PowerApps and Flow: Level 2 - Building Business Solutions with PowerApps and Flow
Locations: Available Nationwide and Online
Class Date(s): 4/26/2021 - 4/28/2021
Course Fee : $1795


Course Syllabus

Section 01: Getting Started with the Power Platform
This section introduces students to the Microsoft Power platform and explains the role of canvas apps, connectors and flows in building business solutions. The section introduces the Common Data Service for Apps (CDSA) and explains how it provides support for creating custom entities and building model-driven apps. Students will create canvas apps with PowerApps Studio and learn to write advanced expressions for screen and control properties. The section examines connectors and data binding and demonstrates using the Start with Data template. Along the way students will learn to build a canvas app for mobile devices that reads and writes customer data to a table inside an Excel workbook in OneDrive for Business.
Topics Covered
•      Overview of the Power Platform
•      Writing Expressions for Screen and Control Properties
•      Understanding Connectors and Data Binding
•      Building Canvas Apps Targeting Mobile Devices

Section 02: Building Data-driven Canvas Apps
This section teaches students the best practices for building data-driven canvas apps using connections, galleries, item templates, forms and data cards. Students will learn best practices for tracking application state using global variables, context variables and collections. The section introduces students to the principles of delegation and explains how to filter, sort and search through a large Azure SQL database tables and a large SharePoint lists without compromising performance. Students will learn how to build a user experience to add and update data using edit forms and data cards. The section concludes with an examination of the PowerApps integration feature with SharePoint Online which makes it possible to customize the SharePoint list forms to provide business users with an enhanced user experience for editing content in a SharePoint Online.
Topics Covered
•      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

Section 03: Building a Canvas App with a Shopping Cart
This section examines building a canvas app which allows users to browse a set of products and to add products into a shopping cart tracked using a local collection. Students will learn how to implement the required data access behavior for writing the shopping cart data out to an Azure SQL database or to a SharePoint list. The section examines techniques required to update data across two tables at once for scenarios where adding an Order record also requires adding multiple OrderDetail records with the primary key of the parent Order record. The section concludes with an examination of using PowerApps Studio to create Reusable Components which can be exported and shared across multiple canvas apps.
Topics Covered
•      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

Section 04: Getting Started with Microsoft Flow
This section introduces the fundamental concepts of Microsoft Flow and gets students started building and testing flows in the Microsoft Flow design editor. Students will learn how to use flow triggers to build flows that can be scheduled, executed in response to external events or run on demand using a button on a mobile device. The section explains how data within a flow is propagated from step to step and discusses how to use control-of-flow actions to author advanced business logic. Students will learn the syntax for writing advanced expressions in Workflow Definition Language (WDL) to retrieve dynamic content, to perform type conversion and to design flows using loops, variables, arrays and custom objects.
Topics Covered
•      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

Section 05: Building Flows to Manage Content and Approvals
This sections focuses on using Microsoft Flow to update, manage and transform content in SharePoint Online and OneDrive for Business. The section demonstrates how to build a scheduled flow to enumerate the items in a SharePoint list to clean up and validate the data entered by business users. Students will learn build flows that upload documents and images to SharePoint Online and OneDrive for Business and to convert document content between common file formats such as JSON, XML, HTML and CSV. The section demonstrates building flows to automate the generation of Word documents and PDF files using the using the Word Online connector. This section examines the support in Microsoft Flow for automating an approval process using the Start an Approval action. Students will learn how to build flows to automate an approval process including document approval in SharePoint Online.
Topics Covered
•      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

Section 06: Integrating PowerApps and Flow with Power BI
This section examines the points of integration between Power BI, PowerApps and Flow. Students will learn how to embed Power BI dashboard content in PowerApps using the Power BI tile control. The section also explains how to embed a canvas app in Power BI reports using the PowerApps custom visual. Students will learn how to pass data from a Power BI report to an embedded canvas app using a design that allows the canvas app to respond to filtering changes in the report. The section examines how to build real-time dashboards in Power BI by designing flows that push rows of data into Power BI automatically triggering updates to dashboard tiles. Students will practice what they learned in the lecture by building a real-time dashboard to monitor Twitter and to display tweets containing specific keywords.
Topics Covered
•      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

Section 07: Getting Started with the Common Data Service
This section introduces the Common Data Service for Apps (CDSA) and explains how it provides a standardized database schema for business data used by PowerApps, Flow and Dynamics 365. Student will learn how to import external data into the CDSA and how to build canvas apps to read and write records for standard entities such as accounts, contacts and activities. The section teaches students how to customize standard entities as well as how to create custom entities to accommodate specific business scenarios.
Topics Covered
•      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

Section 08: Building Model-driven Apps
This section builds on the CDSA fundamentals covered in the previous section to explain the purpose and the techniques used build model-driven apps. Students will learn how to configure a sitemap for a model-driven app to provide read/write access to CDSA entity data such as accounts and contacts. The section demonstrates how to customize the user interface for a model-driven app by customizing the views and forms associated with CDSA entities. The section also explains how to extend a CDSA entity using business rules and business process flows to provide a structured process which enables users to manage content as it moves through the stages of its lifetime.
Topics Covered
•      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

Section 09: Integrating PowerApps with External Systems
This section examines how to integrate data from external systems and on-premises data sources. Student will learn to build flows with the HTTP action to call external web services and to parse JSON from an HTTP response. The section also explains how to build flows with HTTP triggers which can be used to process forms and surveys created using Microsoft Forms. The section explains the purpose of custom connectors and examines real-world scenarios in which they are required. The section introduces students to swagger file definitions and demonstrates using the PowerApps portal to create a custom connector to communicate with a custom web service. The section demonstrates creating custom connectors which can handle OAuth2-style authentication with web services protected by Azure AD such as the Microsoft Graph API and the Power BI Service API. The section concludes with a discussion of how to install and configure an On-premises Data Gateway which makes it possible for canvas apps and flows to read and write data from on-premises data sources such as SQL Server and local SharePoint farms.
Topics Covered
•      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

Section 10: PowerApps ALM using Managed Solutions
The final section examines the challenges and best practices for application lifecycle management (ALM) with PowerApps and the Power platform. Students will first learn the simplest style of ALM which includes publishing, sharing and versioning apps within a single environment. Next, the section demonstrates how to individually export and import canvas apps and flows to move business solutions between environments. The section concludes with an examination of the core PowerApps concepts of publishers and managed solutions and explains the best practices for packaging, distributing and versioning business solutions built on the PowerApps platform.
Topics Covered
•      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

Available Locations

Alabama
Birmingham
Birmingham South
Huntsville
Mobile
Montgomery

Arizona
Mesa
Phoenix
Scottsdale
Tucson

Arkansas
Bentonville
Fayetteville
Little Rock
Little Rock west

California
Bakersfield
El Segundo
Elk Grove
Fresno
Glendale
Irvine
Los Angeles
Los Angeles West
Mission Valley
Orange
Petaluma
Pleasanton
Redwood City
Riverside
Sacramento
San Diego
San Diego downtown
San Francisco
San Jose
Walnut Creek
Woodland Hills

Colorado
Boulder
Centennial
Colorado Springs
Denver
Fort Collins
Grand Junction
Lakewood
Loveland

Connecticut
Cheshire
Danbury
East Granby
Hartford
Rocky Hill
Shelton
Stamford

Delaware
Wilmington DE

Florida
Boca Raton
Brandon
Clearwater
Daytona Beach
Fort Myers
Fort Walton Beach
Ft Lauderdale
Jacksonville
Kissimmee
Lake Mary
Lakeland
Land O Lakes
Melbourne
Miami
Miami Doral
Miramar Beach
Naples
Orange Park
Orlando
Orlando Downtown
Orlando Northeast
Palm Beach Gardens
Pensacola
Plantation
Sarasota
St Petersburg
Tallahassee
Tampa

Georgia
Alpharetta
Atlanta Buckhead
Augusta
Columbus GA
Duluth
Kennesaw
Macon
Savannah

Idaho
Boise
Meridian

Illinois
Chicago
Gurnee
Joliet
Naperville
Northbrook
Oakbrook Terrace
Peoria
Rockford
Schaumburg

Indiana
Carmel
Evansville
Fort Wayne
Indianapolis
Indianapolis downtown
South Bend

Iowa
Cedar Rapids
Des Moines
Quad Cities

Kansas
Lenexa
Topeka
Wichita

Kentucky
Erlanger
Lexington
Louisville

Louisiana
Baton Rouge
Lafayette
New Orleans

Maine
Portland ME

Maryland
Annapolis
Baltimore
Bethesda
Columbia MD
Ellicott City
Frederick
Germantown
Greenbelt
Owings Mills
Rockville
Towson

Massachusetts
Boston
Braintree
Danvers
Mansfield
Newton
North Andover
Norwell
Springfield MA
Westborough
Woburn
Worcester

Michigan
Ann Arbor
Franklin MI
Grand Rapids
Kalamazoo
Lansing
Livonia
Novi
Traverse City
Troy

Minnesota
Bloomington
Maple Grove
Minneapolis
Minneapolis downtown
Rochester MN
Woodbury

Mississippi
Gulfport
Jackson

Missouri
Columbia MO
Kansas City
Lees Summit
O Fallon
Springfield
St Louis
St Louis downtown

Montana
Great Falls

Nebraska
Lincoln
Omaha

Nevada
Henderson
Las Vegas
Reno

New Hampshire
Bedford
Concord
Londonderry
Nashua
Portsmouth

New Jersey
Bridgewater
East Brunswick
East Rutherford
Hamilton
Jersey City
Mahwah
Morristown
Mt Laurel
Paramus
Princeton
Red Bank

New Mexico
Albuquerque

New York
Albany
Bohemia
Brooklyn
Buffalo
Harrison
Melville
Mt Kisco
New York City - Grand Central Station
New York City - Lower Manhattan
New York City - Penn Station
Poughkeepsie
Queens
Rochester
Syracuse
Uniondale

North Carolina
Asheville
Chapel Hill
Charlotte
Charlotte North
Charlotte Uptown
Fayetteville
Greensboro
Hickory
Morrisville
Raleigh
Wilmington

North Dakota
Fargo
Grand Forks

Ohio
Akron
Beachwood
Blue Ash
Cincinnati
Cleveland
Columbus
Columbus Downtown
Dayton
Dublin
Independence OH
Norwood
Toledo
Westlake
Youngstown

Oklahoma
Edmond
Oklahoma City
Tulsa

Oregon
Beaverton
Eugene
Medford
Portland
Salem
Tualatin

Pennsylvania
Allentown
Conshohocken
Erie
Harrisburg
Huntingdon Valley
Lancaster
Malvern
Philadelphia
Pittsburgh
Pittsburgh downtown
State College
University Center
Wexford
York

Rhode Island
Providence
Warwick

South Carolina
Cayce
Greenville
Mount Pleasant

South Dakota
Sioux Falls

Tennessee
Chattanooga
Franklin
Knoxville
Memphis
Nashville

Texas
Addison
Amarillo
Austin
Austin downtown
Bryan
Corpus Christi
Dallas
El Paso
Fort Worth
Grapevine
Houston
Houston North
Irving
Katy
Keller
League City
McAllen
Midland
Plano
Plano Frisco
San Antonio
San Antonio downtown
Sugar Land
The Woodlands
Waco

Utah
Provo
Salt Lake City

Vermont
Shelburne

Virginia
Alexandria
Arlington VA
Charlottesville
Fairfax
Fredericksburg
Glen Allen
Lynchburg
Manassas
McLean
Newport News
Norfolk
Reston
Richmond
Roanoke

Washington
Bellevue
Bellingham
Bothell
Kennewick
Mukilteo
Olympia
Puyallup
Seattle
Spokane
Tacoma

Washington DC
Washington DC
Washington DC - Union Station

West Virginia
Martinsburg

Wisconsin
Brookfield
Glendale WI
Green Bay
Madison
Madison east
Milwaukee

Wyoming
Casper
Cheyenne


Online Self-Paced Training Value Package Only $149

"The Instructor made class truly interesting and put everything into real world terms."
- Meredith T(Jersey City, NJ)


Featured Content

Ultimate Guide to Excel Charts and Graphs

Business Computer Skills BBB Profile