Designing Modern Forms and Workflows with Microsoft PowerApps and Microsoft Flow

Audience:End User / Power User, Developer
Duration:2.00 day(s)

Price: £975.00
Accommodation: £220 (UK Midlands only)

About this course

This course will teach students how to design, build and publish modern mobile first and interactive forms using Microsoft PowerApps and how to integrate custom workflows using Microsoft Flow.

Meet your trainer

Choose a date

All Combined Knowledge courses can be delivered privately online or at a site of your choice.
Contact us to arrange private delivery of a course or to find out more.

Book a private delivery of this course

There are currently no dates scheduled for this course, but all of our courses can be delivered privately at a site of your choice.

Our private on-site / online training can provide your business with the following benefits:

  • Substantial savings on travel and expense costs
  • Group learning – ensuring a consistent transfer of knowledge
  • Open discussions focused on specific business requirements
  • Ability to ‘cherry pick’ modules and tailor course content to your specific needs.
  • Multiple delivery and set-up methods

Contact us to arrange private delivery of a course or to find out more.

Course Syllabus

This course will teach students how to design, build and publish modern mobile first and interactive forms using Microsoft PowerApps and how to integrate custom workflows using Microsoft Flow.

  • Overview of PowerApps and Flow
  • Creating PowerApps
  • Building and Customising PowerApps
  • Working with Data
  • Integrating Flexible Workflows with Flow
  • Publishing and Managing PowerApps and Flows

Audience and Prerequisites

The course is targeted at intermediate to advanced users, business analysts and even developers who need an easy and quick way to create interactive forms that may need to initiate a business process or workflow.


Course Overview

Module 1- Overview of PowerApps and Flow  

This module will introduce both PowerApps and Flow. Students will learn about the key features of PowerApps and Flow. The different licencing options will be explained and students will explore several apps to understand the capabilities of the two products.

  • PowerApps Features
  • Flow Features
  • Licensing Options
  • Explore Sample Apps

Module 2- Creating PowerApps

The two environments for building PowerApps will be introduced, PowerApps Studio for Web and PowerApps Studio for Windows. Students will then learn how to create PowerApps in different ways. They will learn how to create a PowerApp from an existing data store such as a SharePoint List, they will create a PowerApp based on existing templates and from scratch.

  • PowerApps Studio for Web
  • PowerApps Studio for Windows
  • Creating PowerApps from a Data Source
  • Creating PowerApps from a Template
  • Creating Custom PowerApps

Module 3- Building and Customising PowerApps  

This module describes how to tailor the PowerApp User Experience. Students will learn how to add screens and how to customise them. They will understand how to work with layouts, data cards and controls when altering screens. Lastly, students will learn how to add navigation and build interactivity into forms and how to use the formula bar.

  • Customising Screens
  • Working with Layouts and Fields
  • Working with Controls and Data Card
  • Working with the Formula Bar
  • Form interactivity and navigation

Module 4- Working with Data  

This module will teach students how to work with various data sources in PowerApps. Students will explore the myriad of cloud data sources available including how to work with data stored on the corporate network. The Common Data Service will be introduced and students will learn what entities are and how to define their own entities for use with PowerApps.

  • Data Sources and Connectors
    • Cloud Based Sources
    • On Premises Sources
    • Custom Sources
  • Delegated Data Sources
  • On Premises Gateways
  • Common Data Service and Entities
    • Custom Entities
    • Entity Fields, Relationships and Field Groups
    • Working with Entity Data

Module 5- Intergrating Flexible Workflows with Flow

Students will be introduced to Flow and will learn how to combine actions, triggers and connectors to build flexible workflows easily. Students will be shown how to build workflows that periodically run on a schedule, in response to an external event or from simply the press of a button in the flow mobile app. Finally, students will learn how to integrate their custom Flows within PowerApps.

  • Building Flows
    • Creating Custom Flows
    • Creating Flows from a Template
  • Flow Components
    • Triggers
    • Conditions, Actions and Loops
    • Connectors
  • Scheduled Flows
  • Push Notifications
  • Flow Mobile App
    • Monitoring and Managing Flows
    • Creating Flows and Button Flows
  • Starting Flows From PowerApps

Module 6- Enabling Productivity and Collaboration

This module will teach students how to share PowerApps and to manage previous PowerApp versions. They will learn how to run a PowerApp using PowerApps Mobile, the web browser and directly from a SharePoint List. Lastly, the students will learn how to partition PowerApps and Flows using environments and how to administer Data Loss Prevention Policies using the Admin Centres.

  • Managing PowerApps
    • Sharing PowerApps
    • PowerApp Versioning
    • Microsoft AppSource
  • Running PowerApps
    • PowerApps Mobile
    • Web Browser
    • SharePoint List
  • PowerApps Admin Centre and Flow Admin Centre
    • Environments
    • Data Loss Prevention Policies

Courses related to Designing Modern Forms and Workflows with Microsoft PowerApps and Microsoft Flow

This fast paced 3-day workshop will teach you how to build powerful SharePoint business solutions without having to engage in any custom development. You will be amazed exactly how far you can take things with Office 365 and SharePoint Online just using the out-of-the-box features and functionality. This course has been specifically designed for the experienced business users who wants to re-engineer parts of their business process in the Office 365 environment. You will complete all lab exercises for this course using the browser, SharePoint Designer 2013, InfoPath 2013 and other no-code tools, such as Microsoft Flow and PowerApps.

The first day of the course introduces you to Office 365 services and revises SharePoint Online functionality, in particular, how to customize lists and documents libraries by creating and adding site columns and contents types, and the use of Document sets. You will end the first day by reviewing the current list of no-code tools, including an introduction into the use of Windows PowerShell.

You will learn how to use InfoPath 2013 and PowerApps to customize the forms to display and manipulate data from SharePoint list and other data sources, as well as introducing you to Microsoft Forms. You will learn about the workflow architecture in SharePoint Online and discover a new sense of power when creating custom workflows with SharePoint Designer 2013 and Microsoft Flow.

You will learn how to visualize your business data on top of services that are included in Office 365 such as Power BI and Excel Services and the course concludes with an examination of the techniques and strategies to expose content on pages you find in Office 365.

View course

Over many years, we have come to understand and love a suite of Microsoft products including products like Outlook and Excel; most of these products have been with us for over ten years and often make the work we do possible.

Office 365 has introduced a range of new products causing much excitement and more than a little confusion. This class will help you to understand two of these newer products, Office 365 Groups and Teams.

We cover the specific details of how to use Groups and Teams, while also looking at the bigger picture to help you understand how you might use them in the real world to improve the way you share files and communicate as a business.

Finally, we discuss the administration process for Groups and Teams, with a review of the management options including security and controlling who can use the tools.

View course

For users with 6 - 12 months' experience with Power BI, this Certification Bootcamp is an advanced 3-day training class designed to prepare students to pass Microsoft certification exam 70-778: Analyzing and Visualizing Data with Microsoft Power BI. During the course, students will gain the real-world skills required to design, deploy, upgrade and monitor reporting and dashboard solutions using the rapidly-evolving Power BI platform. All the essential Power BI concepts and techniques discussed in lectures are reinforced with hands-on lab exercises in which students will move through the actual steps required to build reporting and dashboard solutions and then to distribute those solutions to a wide audience using app workspaces and the Power Bi app model.

View course

This 1-day course is designed for companies looking to make a smooth transition to Office 365. The course explains what Office 365 is and how it will benefit individuals and the company as a whole. The course removes the mystery of Office 365 showing practical uses for all of the Office 365 components from SharePoint Online to Delve. This course is a workshop where students will follow the instructor’s demonstrations.

View course

This course delivers the complete site owner story from start to finish in an engaging and practical way to ensure you have the confidence to plan and create new sites or manage your existing sites in SharePoint Online. Your goal is to learn how to make SharePoint online relevant to your team by using a sites functionality to help you share information and collaborate with your colleagues. During the class, you will also learn best practices and ‘what not to do’ as you watch live, interactive demonstrations and put theory into practice with hands on exercises in SharePoint Online.

View course

This 3-day course provides detailed hands-on experience for companies looking to make the most of their Office 365 licenses and the data they hold. This course looks at the different parts of Office 365, including some that you may not be aware of. It shows how you can utilise all these tools to get the full benefit of 365 as individuals and as a business. We will cover everything from the more familiar Office Apps and collaborate with colleagues to the building of automated processes.

View course