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	What are Apps?		9
1.2	Starting Power Apps	Choosing your Environment	10
1.3	Getting Help	The Microsoft Website Using AI	11

Chapter 2 - CREATING APPS▼

Section	Title	Subsections	Page
2.1	Our Simple Starter App		12
2.2	Creating Apps		13
2.3	Configuring your App’s Settings	Changing the Name and Icon Setting a Fixed Screen Size Changing and Locking Orientation	14
2.4	Working with Apps	Saving Apps Opening Apps Closing Apps Renaming Apps Deleting Apps	16
2.5	The Power Apps Screen		18
2.6	Working with Screens	Adding (and Moving) Screens Moving Screens	19

Chapter 3 - INTRODUCTION TO CONTROLS▼

Section	Title	Subsections	Page
3.1	What are Controls?		20
3.2	Classic or Modern?	Classic versus Modern Controls Classic versus Modern Themes Which Should you Learn?	21
3.3	Working with 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	23
3.4	Selecting Controls	Selecting Controls in the Tree Selecting Multiple Controls	27
3.5	Grouping and Ungrouping Controls	Using Groups to Make Selection Easier	28
3.6	Concepts for Formatting Controls	Padding Tooltips	29
3.7	Dealing with Control Errors		30
3.8	Viewing Code	Viewing a Control’s Code Viewing Code for All a Screen’s Controls	31

Chapter 4 - NOTES ON SPECIFIC CONTROLS▼

Section	Title	Subsections	Page
4.1	Using the Basic Modern Controls	Multi-line Textboxes Modern Buttons Placeholder Text (Not) Displaying a Clear Button	32
4.2	Using the Basic Classic Controls	Multi-line Textboxes Formatting Controls by Context (Disabled, Pressed and Hover) Focus Properties Hint Text (Placeholders) Displaying a Clear Button	35

Chapter 5 - FINISHING APPS▼

Section	Title	Subsections	Page
5.1	Completing your App		38
5.2	Navigating between Screens using Buttons		39
5.3	Setting the Start Screen (Correctly)	The OnStart Action – a Legacy Note	40
5.4	Testing your App	Providing an Exit Button Running an App Choosing an App Size The Useful ALT Key	41
5.5	Publishing Apps		43
5.6	Sharing Apps		44

Chapter 6 - THEMES AND COLOURS▼

Section	Title	Subsections	Page
6.1	Applying Themes	Adding and Applying a Theme using Modern Controls Applying a Theme using Classic Controls	45
6.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	47
6.3	Lightening or Darkening Colours		50
6.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	51

Chapter 7 - BASIC DATA APPS▼

Section	Title	Subsections	Page
7.1	Our Example		53
7.2	Excel Tables	The Definition of a Table Creating a Table Renaming your Table Removing Fancy Formatting Listing Tables in a Workbook	54
7.3	Creating Data Sources in your App	Adding a Data Source Choosing a Specific File	57
7.4	Two Ways to Show your Data	Creating a Data Grid (Modern Controls) Creating Data Tables (Classic Controls)	58

Chapter 8 - GALLERIES▼

Section	Title	Subsections	Page
8.1	Creating using Templates	Creating a Gallery Setting a Data Source for your Gallery Changing a Gallery’s Layout Assigning Fields to the Parts of a Layout	60
8.2	Creating Galleries from Scratch	Step 1 – Adding a Title Step 2 – Adding a Gallery Step 3 – Adding Fields Step 4 – Adding Labels Step 5 – Adding a Rectangle Step 6 – Add Navigation Buttons Step 7 – Showing the Selected Item	63
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	68

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	71
9.2	Filtering Data	Syntax of the Filter Function Examples of Filtering	73
9.3	Delegation	The Problem Some Possible Solutions Increasing the Delegation Rows Limit (Solution 2) Importing Static Data (Solution 4)	75
9.4	Searching	Creating a Search Facility using the Search Function Creating a Search Facility using the Filter Function	77

Chapter 10 - VARIABLES▼

Section	Title	Subsections	Page
10.1	Overview	The Two Main Types of Variable Viewing Variables	79
10.2	Working with Global Variables	Our Example Getting the Example to Work	80
10.3	Sorting using Variables	Initialising Variables on App Start-Up Adding a Sort Icon Adding Debug The Sort and SortByColumns Function Getting the Sorting Working	82
10.4	Context Variables	Our Example Setting the Values of Context Variables Passing Context Variable Values between Screens	84

Chapter 11 - FORMULAE▼

Section	Title	Subsections	Page
11.1	Our Example		86
11.2	Creating a DatePicker	Adding a Modern DatePicker Control Setting the Date Format	87
11.3	Creating Formulae	Auto-Formatting Formulae Expanding the Formula Box Carriage Returns and Tab Keys Explaining Formulae using Copilot Comments	88
11.4	Testing Conditions (IF and SWITCH)	Testing Single Conditions Testing Multiple Conditions The SWITCH Function	91
11.5	Using Conditions in Actions		93
11.6	Self and Parent	The Self Operator The Parent Operator	94

Chapter 12 - IDEAS FOR DYNAMIC APPS▼

Section	Title	Subsections	Page
12.1	Introduction	Warning for Developers – Something you Can’t Do	95
12.2	Conditionally Enabling Buttons		96
12.3	Relative Positioning on Screen	Using a Variable to Hold the Size of Padding Positioning the Logo	97
12.4	On-Screen Validation Messages	Using the Match Function to Validate Controls Setting Validation Properties Delaying the Validation Response Setting Validation States	99

Chapter 13 - USING SPECIFIC CONTROLS▼

Section	Title	Subsections	Page
13.1	Controls in this Chapter		103
13.2	Rating		103
13.3	Pen Input		105
13.4	Date Picker	Modern versus Classic Date Picker Control Useful Properties for the Date Picker Control	106
13.5	Toggle Buttons		107
13.6	Radio Buttons	Setting the Radio Options Other Radio Control Properties	109
13.7	Check Boxes		110
13.8	Sliders		112
13.9	Text Controls		113
13.10	Tab List Controls	Creating a Tab List Control Getting the Tabs to Work	114

Chapter 14 - CHARTS▼

Section	Title	Subsections	Page
14.1	Overview of Charts		116
14.2	Creating a Chart	Connecting to a Data Source Applying a Theme Adding a Chart The Three Parts of a Chart Setting the Chart Data Setting the Chart’s Title Setting the Chart’s Legend	117
14.3	Formatting Charts	Formatting Labels	121

Chapter 15 - THE TIMER CONTROL▼

Section	Title	Subsections	Page
15.1	Our Case Study		123
15.2	Variables Used	Initialising the Variables Creating Debug for your Variables	124
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	125
15.4	The Main Properties of a Timer		128

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

Section	Title	Subsections	Page
16.1	The Three Controls Compared		129
16.2	Dropdown Controls	Adding Dropdowns Sorting the Dropdown Values Setting a Default Value Storing Formulae Reacting to a New Choice of Item Resetting a Drop Down	130
16.3	Combo Boxes	Showing the Values Chosen Configuring Comboboxes Resetting a Combobox Setting the Default Rows	133
16.4	List Boxes	The Main Properties Picking up on the Selected Items	136
16.5	Cascading Drop Downs	Configuring the Parent Dropdown Configuring the Child Dropdown	137

Chapter 17 - FORMS – CREATING OUR EXAMPLE APP▼

Section	Title	Subsections	Page
17.1	Our Example App	Flow through the App The Screens Required	138
17.2	Starting the App	Creating the App and Screens Creating the Vertical Gallery	140
17.3	Adding the Details Form	Adding the Form Setting what Data the Form Displays Adding Fields to the Form Adding Buttons Customising some Form Properties	141
17.4	Adding the Add/Edit Form		143

Chapter 18 - FORMS – WORKING WITH CARDS▼

Section	Title	Subsections	Page
18.1	About Cards	Changing Card Layout The Anatomy of a Card	145
18.2	Custom Cards	Unlocking Cards Custom Cards Creating New Custom Cards	146

Chapter 19 - FORMS – ENABLING EDITING▼

Section	Title	Subsections	Page
19.1	The Edit Form Mode	Debug: Displaying the Current Mode	148
19.2	Update Issues	How Updating Works Problems with Excel	149
19.3	Getting Adding and Editing Working	What Should Happen The Buttons for Starting to Add or Edit Setting the Unique Key’s Update Property Saving Changes Cancelling Adding or Editing	150
19.4	Deleting Items	The RemoveIf Command	153
19.5	Adding Controls to Edit Forms	Example: Adding a Toggle Button Example: Adding a Dropdown	154

Chapter 20 - FORMS - VALIDATING▼

Section	Title	Subsections	Page
20.1	Contents of Chapter		156
20.2	Reacting to Errors	The Notify Function Reacting to Success or Failure	157
20.3	Avoiding Errors Happening	Changing the Control Type Changing the Control Formatting Setting Maximum Field Length Using the IsMatch Function for Email Addresses	159
20.4	Understanding Standard Card Controls	Using the Star Label to Show Required Fields The Label to Show Error Messages	161
20.5	Making a Field Compulsory	Deleting the Default Error Controls Setting a Field to Required Adding an Error Message	162
20.6	More Complex Validation		163

Chapter 21 - ADDING, EDITING AND DELETING RECORDS▼

Section	Title	Subsections	Page
21.1	Introducing Collections	Creating or Adding to Collections Clearing Collections Clearing and Adding to Collections Viewing Collections Tables and Collections	164
21.2	The Patch Command	Adding Items using Patch Editing an Item using Patch	167
21.3	Update and UpdateIf Commands	The Update Command The UpdateIf Command	169
21.4	Removing Rows	Remove RemoveIf	171

Chapter 22 - CONTAINERS▼

Section	Title	Subsections	Page

Chapter 23 - MEDIA CONTROLS▼

Section	Title	Subsections	Page
23.1	Overview of Media Controls	Uploading Media Files Adding Media Controls Limits in Power Apps	174
23.2	Audio and Video	Adding Videos Adding Audio Files Useful Audio and Video Properties Audio and Video Actions	176
23.3	Adding Images	Useful Image Properties	178
23.4	The Camera Control	Adding a Camera Control Listing your Camera Devices Choosing your Device Capturing Photos Storing your Photos in a Database Streaming	179
23.5	Adding Pictures (File Upload)		183

Chapter 24 - COMPONENTS▼

Section	Title	Subsections	Page
24.1	What are Components?		184
24.2	Simple Components	Creating Components Adding Controls to Components Adding Components to a Screen	185
24.3	Overview of Custom Properties	About Custom Properties Types of Custom Property	187
24.4	Case Study: Input Property	Creating a Custom Property Using Custom Property Values Assigning Values to our Input Property	188
24.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	190
24.6	Other Component Property Types	Enabling Enhanced Component Properties Choosing a Custom Property Type Using the Different Property Types An Example – Calling an Event	193

Chapter 25 - POWER AUTOMATE▼

Section	Title	Subsections	Page
25.1	Overview	What are Power Automate flows?	195
25.2	Creating a Flow	Step 1 – Creating the Power App Step 2 – Create the Flow Step 3 – Renaming your Flow Step 4 – Adding an Input Step 5 – Adding the Email Step Step 6 – Creating the Response Step Step 7 – Adding an Output to the Response Step 8 - Saving your Flow Step 9 – Viewing and Editing your Flow	196
25.3	Calling your Flow		202

Chapter 26 - POWER APPS IN POWER BI▼

Section	Title	Subsections	Page
26.1	Overview		203
26.2	Creating an App in Power BI	Step 1 – Creating the Report and Publishing It Step 2 – Editing your Report Step 3 – Add a Power Apps Visual Step 4 – Adding Data Fields Step 5 – Creating a New App Step 6 – Creating a Landing Screen Step 7 – Assigning Data Step 8 – Saving, Publishing and Sharing Step 9 – Waiting	204
26.3	Embedding an Existing App		208

Chapter 27 - POWER BI IN POWER APPS▼

Section	Title	Subsections	Page
27.1	Overview		209
27.2	Creating the Power BI Report	Setting a Custom Page Size Publishing the Page	210
27.3	Creating your Dashboard	Pinning a Live Page to a Dashboard Hiding the Tile’s Title and Subtitle	211
27.4	Showing the Live Page in Power Apps		213

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