This page has 0 threads | Add post

Courseware

Introduction to Power Apps course manual

Here are the chapters included in this course manual (we use exactly the same manuals for our classroom and online Power Apps courses).

Click here to download a sample of the first two chapters of this Introduction to Power Apps manual, or review how to license our courseware.

Chapter 1 - GETTING STARTED▼

Section	Title	Subsections	Page
1.1	Getting Started	The 3 Types of App Some Examples of Canvas Apps Getting Started Choosing your Environment	8
1.2	Getting Help	The Microsoft Website Opening Template Apps	11

Chapter 2 - CREATING APPS▼

Section	Title	Subsections	Page
2.1	Our Simple Starter App		12
2.2	Working with Apps	Creating Apps Saving Apps Opening Apps Closing Apps	13
2.3	App Settings	Changing the Name and Icon Setting Screen Size (Tablet Apps Only) Changing and Locking Orientation	15
2.4	The Power Apps Screen		17
2.5	Working with Screens	Adding (and Moving) Screens Moving Screens	18

Chapter 3 - CONTROLS▼

Section	Title	Subsections	Page
3.1	Introduction to Controls	Adding Controls Changing a Control’s Name Changing a Control’s Properties Method 1 – Double-Clicking Method 2 - Using the Menu Method 3 - Using the Properties Window Method 4 – Using the Formula Bar	19
3.2	Selecting Controls	Selecting Controls in the Tree Selecting Multiple Controls	23
3.3	Grouping and Ungrouping Controls	Using Groups to Make Selection Easier	24
3.4	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	25
3.5	Dealing with Control Errors		29
3.6	Viewing Code	Viewing a Control’s Code Viewing Code for All a Screen’s Controls	30

Chapter 4 - FINISHING APPS▼

Section	Title	Subsections	Page
4.1	Completing your App		31
4.2	Navigating between Screens using Buttons		32
4.3	Setting the Start Screen (Correctly)	The OnStart Action – a Legacy Note	33
4.4	Testing your App	Providing an Exit Button Running an App Choosing an App Size The Useful ALT Key	34
4.5	Publishing Apps		36
4.6	Sharing Apps		37

Chapter 5 - THEMES AND COLOURS▼

Section	Title	Subsections	Page
5.1	Applying a Theme		38
5.2	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	39
5.3	Lightening or Darkening Colours		41
5.4	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	42

Chapter 6 - BASIC DATA APPS▼

Section	Title	Subsections	Page
6.1	Our Example		44
6.2	Excel Tables	The Definition of a Table Creating a Table Renaming your Table Removing Fancy Formatting Listing Tables in a Workbook	45
6.3	Creating Data Sources in your App		48
6.4	Creating Data Tables		49

Chapter 7 - ANATOMY OF AN APP▼

Section	Title	Subsections	Page
7.1	Creating a Template Data App	Showing Rows	50
7.2	Understanding Generated Data Apps	How this Works – Browse Screen (Gallery) How this Works – Details Screen How this Works – Edit Screen	52

Chapter 8 - GALLERIES▼

Section	Title	Subsections	Page
8.1	Creating using Templates	Creating a Gallery Changing a Gallery’s Layout Assigning Fields to the Parts of a Layout	54
8.2	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	57
8.3	Processing the Selected Item	Creating the Response Screen The Main Screen and Control Events Handling Item Selection Items and Parents Highlighting the Selected Item	62

Chapter 9 - FILTERING AND SEARCHING▼

Section	Title	Subsections	Page
9.1	Tables and Rows	Changing a Gallery’s Source Table The COUNTROWS Function and ALLITEMS Property Shuffling Rows	65
9.2	Filtering Data	Syntax of the Filter Function Examples of Filtering	67
9.3	Delegation	The Problem Some Possible Solutions Increasing the Delegation Rows Limit (Solution 2) Importing Static Data (Solution 4)	69
9.4	Searching	Creating a Search Facility using the Search Function Creating a Search Facility using the Filter Function	71

Chapter 10 - VARIABLES▼

Section	Title	Subsections	Page
10.1	Overview	The Two Main Types of Variable Viewing Variables	73
10.2	Working with Global Variables	Our Example Getting the Example to Work	74
10.3	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	76
10.4	Context Variables	Our Example Setting the Values of Context Variables Passing Context Variable Values between Screens	78

Chapter 11 - FORMULAE▼

Section	Title	Subsections	Page
11.1	Our Example	Creating the DatePicker	80
11.2	Creating Formulae	Expanding the Formula Box Explaining Formulae using Copilot Carriage Returns and Tab Keys Comments Indentation (Auto-Formatting)	82
11.3	Testing Conditions (IF and SWITCH)	Testing Single Conditions Testing Multiple Conditions The SWITCH Function	85
11.4	Using Conditions in Actions		87
11.5	Self and Parent	The Self Operator The Parent Operator	88

Chapter 12 - IDEAS FOR DYNAMIC APPS▼

Section	Title	Subsections	Page
12.1	Introduction	Warning for Developers – Something you Can’t Do	89
12.2	Conditionally Enabling Buttons		90
12.3	Relative Positioning on Screen	Using a Variable to Hold the Size of Padding Positioning the Logo	91
12.4	On-Screen Validation Messages	Using the Match Function to Validate Controls Setting Validation Properties Delaying the Validation Response (the DelayOutput Property)	92

Chapter 13 - USING SPECIFIC CONTROLS▼

Section	Title	Page
13.1	Controls in this Chapter	94
13.2	Rating	94
13.3	Pen Input	95
13.4	Date Picker	96
13.5	Toggle Buttons	96
13.6	Radio Buttons	98
13.7	Check Boxes	98
13.8	Sliders	100
13.9	Text Controls	101

Chapter 14 - CHARTS▼

Section	Title	Subsections	Page
14.1	Overview of Charts		102
14.2	Creating a Chart	Connecting to a Data Source Adding a Chart The Three Parts of a Chart Setting the Chart Data Setting the Chart’s Title Setting the Chart’s Legend	103
14.3	Formatting Charts	Formatting Labels	107

Chapter 15 - THE TIMER CONTROL▼

Section	Title	Subsections	Page
15.1	Our Case Study		109
15.2	Variables Used	Initialising the Variables Creating Debug for your Variables	110
15.3	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	111
15.4	The Main Properties of a Timer		114

Chapter 16 - DROP DOWNS, COMBO BOXES AND LIST BOXES▼

Section	Title	Subsections	Page
16.1	Introduction		115
16.2	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	116
16.3	List Boxes		119
16.4	Combo Boxes	Combo Box Data and Layouts Configuring Search	120
16.5	Cascading Drop Downs	Configuring the Parent Dropdown Configuring the Child Dropdown Disabling the Film List Conditionally An Alternative: Populating the Child Dropdown if No Parent Chosen The Reset Buttons	122

Chapter 17 - FORMS▼

Section	Title	Subsections	Page
17.1	Creating Template Apps using Forms		125
17.2	Creating and Integrating a Details Form	Creating your Gallery Adding a Details Form Adding Cards to the Details Form Changing Card Orientation and Columns Adding a Back Button	126
17.3	Working with Cards	The Anatomy of a Card Unlocking Cards Custom Cards Creating New Custom Cards	129
17.4	Edit Forms	Preparing to Edit 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	131
17.5	Deleting Items	The RemoveIf Command	136
17.6	Adding Controls to Edit Forms	Example: Adding a Toggle Button Example: Adding a Dropdown	137

Chapter 18 - VALIDATING FORMS▼

Section	Title	Subsections	Page
18.1	Avoiding Errors Happening	Changing the Control Type Changing the Control Formatting Setting the Maximum Length Using the IsMatch Function for Email Addresses	139
18.2	Understanding Errors	The Error and ErrorKind Properties What Happens on Form Submission	141
18.3	Understanding Standard Card Controls	The Star Label to Show Required Fields The Label to Show Error Messages	142
18.4	Required Fields	Setting a Field to Required Adding a Simple Error Message Customising the Default Error Message	143
18.5	More Complex Validation		144

Chapter 19 - ADDING, EDITING AND DELETING RECORDS▼

Section	Title	Subsections	Page
19.1	Collections	What Collections Are Creating or Adding to Collections Clearing Collections Clearing and Adding to Collections Viewing Collections Tables and Collections	145
19.2	The Patch Command	Adding Items using Patch Editing an Item using Patch	148
19.3	Update and UpdateIf Commands	The Update Command The UpdateIf Command	150
19.4	Removing Rows	Remove RemoveIf	152

Chapter 20 - RESPONSIVE APPS▼

Section	Title	Subsections	Page
20.1	Responsive Design		153
20.2	Two Problems you’ll Encounter	Testing your Changes Losing Changes	154
20.3	App Settings		155
20.4	Screen Dimensions	The Main Screen Properties Controlling the Screen Dimensions	156
20.5	Responsive Controls	Setting Parameters The Important Properties Case Study: Centring a Title Horizontally Case Study: Vertical Distances	157
20.6	Responsive Forms	Columns Snap to Columns The X and Y Properties for Cards in Forms The WidthFit Property	159
20.7	Horizontal and Vertical Containers	Our Example Adding Containers Our Vertical Container Properties Our Horizontal Container Properties Individual Button Properties	162

Chapter 21 - MULTIMEDIA▼

Section	Title	Subsections	Page
21.1	Overview of Multimedia Files	Adding and Viewing Multimedia Files Limits in Power Apps	165
21.2	Audio and Video	Adding Videos Adding Audio Files Useful Audio and Video Properties Audio and Video Actions	166
21.3	Adding Images	Useful Image Properties	168
21.4	The Camera Control	Adding a Camera Control Listing your Camera Devices Choosing your Device Capturing Photos Storing your Photos in a Database Streaming	169
21.5	Adding Pictures (File Upload)		173

Chapter 22 - COMPONENTS▼

Section	Title	Subsections	Page
22.1	What are Components?		174
22.2	Simple Components	Creating Components Populating Components Adding Components to a Screen	175
22.3	Overview of Custom Properties	About Custom Properties Types of Custom Property	177
22.4	Case Study: Input Property	Creating a Custom Property Using Custom Property Values Assigning Values to our Input Property	178
22.5	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	180

Chapter 23 - POWER AUTOMATE▼

Section	Title	Subsections	Page
23.1	Overview	Power Automate flows	183
23.2	Case Study: Sending Output Back to Power Apps	Step 1 – Creating the Power App Step 2 – Create the Flow Step 3 – Renaming your Flow Step 4 – Adding a Step Step 5 – Configuring the Step Step 6 – Getting the Flow Output Step 7 – Showing the Flow Output	184

Chapter 24 - POWER APPS IN POWER BI▼

Section	Title	Subsections	Page
24.1	Overview	Sharing Data Sources	188
24.2	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	189

Chapter 25 - POWER BI IN POWER APPS▼

Section	Title	Subsections	Page
25.1	Overview		191
25.2	Creating the Power BI Report	Setting a Custom Page Size Publishing the Page	192
25.3	Creating your Dashboard	Pinning a Live Page to a Dashboard Hiding the Tile’s Title and Subtitle	193
25.4	Showing the Live Page in Power Apps		195

If you book a place on one of our courses you will automatically get access to the relevant courseware manual online, and also have the option to receive a paper copy of it.

This page has 0 threads

Add a new post

Choose software

Power Apps course manuals