Course Curriculum

Are you a SharePoint Power User or form and workflow creator?  Maybe you are looking to upgrade your skill level to the newest Microsoft technologies?  Microsoft's PowerApps provides the latest cutting edge method for creating solutions ranging from simple custom forms to full applications.  In this four day class, you will obtain the skills necessary for implementing PowerApps, to increase your organization's productivity.  

This is a recording of our live class that we taught in November, 2018.  This course will be available to you for 30 days.


Audience: Office 365 & SharePoint Power Users, InfoPath designers, Access Web App designers, form creators



Module 1: Getting Familiar with PowerApps

In this introductory module, the PowerApps design interface will be demonstrated and explained.  This will familiarize you with the basics of navigating the interface and aid in finding the tools necessary to create successful PowerApps.  Concepts and terminology will also be discussed to lay the foundation for advanced topics.

Module 2: PowerApps Components

The next step for developing PowerApps is the fundamental understanding of the various components.  The components discussed will be screens, controls, galleries and associated properties with each.  The knowledge from this module will allow us to begin shaping the user interface of the PowerApp.  There are different types of PowerApps that will be demonstrated as well, such as a full app versus the quick customization of a SharePoint list form.
Topics: Tabs, property panel, data panel, rules panel, screen panel, naming conventions for controls, and the app checker.

Module 3: Functions

Creating controls such as labels, input boxes, or buttons is necessary for user interaction, however, the functions behind these controls is where we are able to add productivity to our business.  Functions are the pivotal tool that allows your PowerApps to be brought to life.  This module will introduce the fundamental principles of functions.  
Topics: Formulas, enumerations, functions, logic, signals and named operators, and syntax tips.

Module 4: Data sources / Connections

In this module, we will begin by discussing the fundamentals of data connections and the avenues available in PowerApps.  The foundational concepts of viewing the data within PowerApps will also be discussed, as well as several common types of data connections in Office 365.  Specifically, SharePoint, Excel, OneDrive, and Planner. User data, approvals, and email connections are covered in detail and demonstrated.  
Topics: data sources, data connections, and the difference between the two; connecting to data; intro to the Common Data Service

Module 5: Lists and Forms

Now that we have the capability of adding data sources, we will delve into the topics of viewing, filtering, creating, and editing data using galleries, tables, and forms.  This module then advances into methods of passing values (aka: parameters) across controls such as cards, buttons, for advanced form logic upon submission.
Topics: Gallery properties, filtering/searching/sorting galleries, gallery templates, tables versus galleries, form properties, advanced functionality of cards, connecting galleries to forms, and form functions.

Module 6: Dynamic Controls and Variables

For an application to deliver increased efficiency to a user, it must possess the ability to dynamically change based on the user's input.  This module will discuss the advanced use of variables and logic based functions that allows the creation of an efficient and user friendly application.  
Topics: collections, global variables, context variables, deep dive into controls, advanced functions, and using query string URLs for passing parameters.

Module 7: Advanced SharePoint Functionality

Business requirements for solutions often become fairly complex, and form logic/rules becomes a necessity.  This module starts with how to customize SharePoint list forms with PowerApps, then will dive into the depths of understanding SharePoint data as it pertains to PowerApps.  This includes lookups, choice fields, people fields, and their advanced usage when implementing automation.  Advanced data submission, outside of forms (patching), will be covered in detail.  
Topics: customizing list forms, SharePoint data structure, complex fields, parent-child relationships in forms, and collecting and patching data.

Module 8: Curb Appeal

Once we have created the innerworkings of a PowerApp, we are faced with daunting task of visual appeal.  This module will present concepts, tips, and tricks around branding your PowerApp.  Apps that are professional looking and polished will help to increase user adoption.
Topics: visual properties, color selecting, creating a standard menu across screens, animations, charts, and media controls.

Module 9: Publishing

Now that it's ready to go live, how do you deliver it to the intended audience? In this module, you will learn how to present PowerApps to end users in your organization.  We will discuss publishing options, settings, and restrictions. Then, we will cover the central administration of PowerApps, such as managing the owner and user roles.  The topics of analytics and environments will also be discussed.
Topics: App collaboration, sharing with end users, app settings, versioning, analytics, PowerApps admin, and packaging & deploying.

Course details