Microsoft Power Apps Essentials

The following prerequisites are recommended before attending:

• A basic understanding of Windows 7 or later versions
• Experience using Internet Explorer or equivalent browser
• A general knowledge of using Office 365
• A basic knowledge of using functions in Excel or a similar program
• Some basic programming knowledge is useful but not essential

Dual monitor setup is required for when attending this course via the QA Attend from Anywhere delivery method.

Instructors will demonstrate features throughout the event. Optional Lab exercises are available for students to complete within a delegate created free trial tenancy. Microsoft may require a valid credit card to create 30 day free tenancies which must be cancelled within 30 days to avoid incurring charges. QA have no control over the Microsoft 365 trial tenancy signup or billing process.

After attending this course, delegates will be able to:

• Understand the function of Power Apps and understand how it fits with the Power Platform
• Create Apps from scratch, from templates or from existing data
• Save and publish apps
• Work with versions
• Work with: Screens, Controls and set properties
• Understand navigation between screens
• Understand and use variables
• Work with data sources
• Work with tables and galleries
• Use functions and formulas
• Work with data forms for viewing and editing data

Overview of Power Apps

This module introduces Power Apps, what you can do with Power Apps and how Power Apps fits with the rest of the Power Platform. It also contains and exercise that will prepare the student environment for working with and creating Power Apps.

The Power Apps Studio

This module starts with an explanation on how to launch and use the Power Apps studio for creating, editing and running apps. There is also a section on the other ways that apps can be run by users. The module will also look at how apps can be saved, published and shared with other users as well as investigating the versioning system of Power Apps. The three main ways of creating apps are introduced and there is an exercise where students will create, save and publish an app from a template.

Screens, controls and navigation

In this module students will examine the core building blocks of Power Apps, namely Screens and Controls. As part of this the naming of these objects and a discussion on naming conventions will be covered. This module will also look at setting properties including the use of relative and linked properties. There will also be an examination of the properties that can be used to invoke change.

Variables and functions

The module will introduce students to the use of functions in Power Apps and will focus on commonly used functions including Navigate, Text and Value as well as exploring how multiple functions can be used together. Variables and the functions used to manipulate them are also introduced. There is an exercise to bring together all the skills introduced so far in the course.

Working with data – galleries

In this module, students will be introduced to data and tables including data sources and records. The main ways of displaying multiple records are introduced, namely the table and gallery controls. The use of searching and the sum function within data tables is also introduced and there is an exercise to practice theses skills.

Working with data - forms

The final module of this course looks at using forms to view and edit individual records from the data sources. The module also introduces data cards, the sub-components of forms and shows their importance when creating apps. Finally, the functions used with forms to create and update records are introduced. This module has two exercises, the first to cement learning from the module, the second to investigate publishing and versions which was not possible earlier in the course due to lack of data.