Power Apps courseware and training manuals

We've got the following courseware on Power Apps:

You can see details of how to license our Power Apps courseware (including volume requirements) here.


Power Apps courseware

Here is a list of all of our Power Apps manual chapters (you can download the ones marked):

Chapter Sections Subsections
Power Apps Overview (3 pages) Types of App Examples of Apps
What you Need To Design your Apps ; To Run your Apps
Getting Help The Microsoft Website ; Opening Template Apps
Creating Apps (22 pages) Our Simple Starter App
Working with Apps Creating Apps ; Saving your Apps ; Opening Apps ; Closing Apps
App Settings Changing the Name and Icon ; Setting Screen Size (Tablet Apps Only) ; Changing and Locking Orientation
The Power Apps Screen Adding (and Moving) Screens ; Moving Screens
Adding Controls Changing a Control’s Name ; Changing Control Properties ; Method 1 – Double-Clicking ; Method 2 - Using the Menu ; Method 3 - Using the Properties Window ; Method 4 – Using the Formula Bar
Selecting and Grouping Controls Selecting Controls in the Tree ; Selecting Multiple Controls ; Grouping and Ungrouping Controls ; Using Groups to Make Selection Easier
Working with Controls Multi-line Textboxes ; Padding ; Overflow Property for Scrolling Labels ; Formatting Controls by Context (Disabled, Pressed and Hover) ; Focus Properties ; Tooltips ; Hint Text (Placeholders) ; Displaying a Clear Button
Dealing with Control Errors
Navigating between Screens using Buttons
Testing your App Providing an Exit Button ; Running an App ; The Useful ALT Key
Publishing Apps
Themes and Colours (6 pages)

Download this chapter
Applying a Theme
Colours Setting the Colour using the Standard Palette ; Setting the Colour using the Custom Palette ; Setting Colours using the Formula Bar ; Setting Colours to other Control’s Colours
Lightening or Darkening Colours
Creating Unofficial Themes Step 1 – Adding a Hidden Page ; Step 2 – Adding our Ideal Controls ; Step 3 – Create Template Controls ; Stage 4 – Use Templates to Format Other Controls
Basic Data Apps (6 pages) Our Example
Excel Tables The Definition of a Table ; Creating a Table ; Renaming your Table ; Removing Fancy Formatting ; Listing Tables in a Workbook
Creating Data Sources in your App
Creating Data Tables
Anatomy of an App (3 pages) Creating a Template Data App
Understanding Generated Data Apps How this Works – Browse Screen (Gallery) ; How this Works – Details Screen ; How this Works – Edit Screen
Galleries (10 pages) Creating using Templates Creating a Gallery ; Changing a Gallery’s Layout ; Assigning Fields to the Parts of a Layout
Creating Galleries from Scratch Step 1 – Adding a Title ; Step 2 – Adding a Gallery ; Step 3 – Adding Text Boxes ; Step 4 – Adding a Label ; Step 5 – Adding a Rectangle ; Step 6 – Add Navigation Buttons ; Step 7 – Showing the Selected Item
Processing the Selected Item Creating the Response Screen ; The Main Screen and Control Events ; Handling Item Selection ; Items and Parents ; Highlighting the Selected Item
Filtering and Searching (7 pages) Tables and Rows Changing a Gallery’s Source Table ; The COUNTROWS Function and ALLITEMS Property ; Shuffling Rows
Filtering Data
Delegation The Problem ; Some Possible Solutions ; Increasing the Delegation Rows Limit (Solution 2) ; Importing Static Data (Solution 4)
Searching Creating a Search Facility using the Search Function ; Creating a Search Facility using the Filter Function
Variables (8 pages) The Two Main Types of Variable
Working with Global Variables Our Example ; Setting a Global Variable
Sorting using Variables Initialising Variables on App Start-Up ; Running the App Start-up Action ; Adding a Sort Icon ; Adding Debug ; The Sort and SortByColumns Function ; Getting the Sorting Working
Context Variables Our Example ; Setting the Values of Context Variables ; Passing Context Variable Values between Screens
Viewing Variables Seeing where Variables are Used
Formulae (8 pages) Our Example
Creating Formulae Expanding the Formula Box ; Carriage Returns and Tab Keys ; Comments ; Indentation (Auto-Formatting)
Testing Conditions (IF and SWITCH) Testing Single Conditions ; Testing Multiple Conditions ; The SWITCH Function
Using Conditions in Actions
The Function Wizard
Self and Parent The Self Operator ; The Parent Operator
Ideas for Dynamic Apps (5 pages) Introduction Warning for Developers – Something you Can’t Do
Conditionally Enabling Buttons
Relative Positioning on Screen Using a Variable to Hold the Size of Padding ; Positioning the Logo
On-Screen Validation Messages Using the Match Function to Validate Controls ; Setting Validation Properties ; Delaying the Validation Response (the DelayOutput Property)
Using Specific Controls (8 pages) Controls in this Chapter
Rating
Pen Input
Date Picker
Toggle Buttons
Radio Buttons
Check Boxes
Sliders
Text Controls
The Timer Control (6 pages) Our Case Study
Variables Used Initialising the Variables ; Creating Debug for your Variables
Configuring Properties Starting the Timer when the Form is Used ; Creating the Pop-up Message ; Displaying the Pop-Up Message ; Setting the Text Property of the Timer ; The Reset Button
The Main Properties of a Timer
Dropdowns, Combo boxes and Listboxes (9 pages) Introduction
Drop downs Setting what Rows a Drop Down Displays ; Setting a Blank Top Row ; Reacting to a New Choice of Item ; Resetting a Drop Down ; Formatting Dropdowns
List Boxes
Combo Boxes Combo Box Data and Layouts ; Configuring Search
Cascading Drop downs, List boxes and Combo boxes Data for the Drop Downs ; Disabling the Film List Conditionally ; The Reset Buttons
Forms (14 pages) Creating Template Apps using Forms
Creating and Integrating a Details Form Creating a Gallery ; Adding a Details Form ; Adding Cards to the Details Form ; Adding a Back Button
Working with Cards The Anatomy of a Card ; Unlocking Cards ; Custom Cards ; Creating New Custom Cards
Edit Forms Preparing to Edit ; Creating an Edit Form ; The All-Important Edit Form Mode ; Debug: Displaying the Current Mode ; The Update Property of a Control ; Adding and Editing Items ; The Notify Function ; Inspecting Success or Failure
Deleting Items The RemoveIf Command
Adding Controls to Edit Forms Example: Adding a Toggle Button ; Example: Adding a Dropdown
Validating Forms (6 pages) Avoiding Errors Happening Changing the Control Type ; Changing the Control Formatting ; Setting the Maximum Length ; Using the IsMatch Function for Email Addresses
Understanding Errors The Error and ErrorKind Properties ; What Happens on Form Submission
Understanding Standard Card Controls The Star Label to Show Required Fields ; The Label to Show Error Messages
Required Fields Setting a Field to Required ; Adding a Simple Error Message ; Customising the Default Error Message
More Complex Validation
Adding, editing and deleting records (8 pages) Collections What Collections Are ; Creating or Adding to Collections ; Clearing Collections ; Clearing and Adding to Collections ; Viewing Collections ; Tables and Collections
The Patch Command Adding Items using Patch ; Editing an Item using Patch
Update and UpdateIf Commands The Update Command ; The UpdateIf Command
Removing Rows Remove ; RemoveIf
Responsive Apps (9 pages) Responsive Design
Two Problems you’ll Encounter Testing your Changes ; Losing Changes
App Settings
Screen Dimensions The Main Screen Properties ; Controlling the Screen Dimensions
Responsive Controls Setting Parameters ; The Important Properties ; Case Study: Centring a Title Horizontally ; Case Study: Vertical Distances
Responsive Forms Columns ; Snap to Columns ; The X and Y Properties for Cards in Forms ; The WidthFit Property
Multimedia (9 pages)

Download this chapter
Overview of Multimedia Files Adding and Viewing Multimedia Files ; Limits in Power Apps
Audio and Video Adding Videos ; Adding Audio Files ; Useful Audio and Video Properties ; Audio and Video Actions
Adding Images Useful Image Properties
The Camera Control Adding a Camera Control ; Listing your Camera Devices ; Choosing your Device ; Capturing Photos ; Storing your Photos in a Database ; Streaming
Adding Pictures (File Upload)
Power Apps in Power BI (3 pages) Overview Sharing Data Sources
Embedding an App Step 1 - Create a Power BI Report ; Step 2 – Adding an App Visual ; Step 3 – Creating or Choosing the App to Show
Power BI (3 pages) Overview Sharing Data Sources
Embedding an App Step 1 - Create a Power BI Report ; Step 2 – Adding an App Visual ; Step 3 – Creating or Choosing the App to Show
Power BI in Power Apps (5 pages) Overview
Creating the Power BI Report Setting a Custom Page Size ; Publishing the Page
Creating your Dashboard Pinning a Live Page to a Dashboard ; Hiding the Tile’s Title and Subtitle
Showing the Live Page in Power Apps
Components (8 pages) What are Components?
Simple Components Creating Components ; Adding Components to a Screen
Overview of Custom Properties About Custom Properties ; Types of Custom Property
Case Study: Input Property Creating a Custom Property ; Using Custom Property Values ; Assigning Values to our Input Property
Case Study: Output Property Step 1 - Adding the Dropdown ; Step 2 – Adding the Custom Property ; Step 3 - Linking the Custom Property to the Colour Dropdown ; Step 4 - Setting the Component’s Fill Colour ; Step 5 – Setting each Screen’s Fill Colour
Power Automate (5 pages) Overview Power Automate flows
Case Study: Sending Output Back to Power Apps Step 1 – Creating the Power App ; Step 2 – Creating the Flow ; Step 3 – Adding a Step ; Step 4 – Configure the Step ; Step 5 – Testing your Flow ; Step 6 – Using the Flow Output

Notes:

  1. Since Wise Owl print courseware double-sided to save trees, the number of physical pages in each chapter is roughly half of the number of sides quoted.
  2. Downloads are provided as examples only, and should not be used or distributed in any way or form without the prior written permission of Wise Owl.
This page has 0 threads Add post