Master Microsoft Power Apps Table Functions

Learn how to solve real life problems using Power Apps table functions

What you'll learn
Basic table and database concepts in Power Apps (Record, Table, Arrays, Collection and variables)
Mass insert, delete and update and detailed analysis about available functions in Power Apps and how to use the efficiently
Working with Loops and Sequence to process the table items separately
Bridge between behavior and non-behavior functions
Condition and alternative options to If and Switch
Changing table schema to make it fit our solution
Bulk insert of record to a table/list instead of processing them one-by-one
Working with fields that contain complex data
Effect of internal field names and title on the way you use table functions
Difference between Search, Filter and Lookup and where to use each one of them
Chose between Sort and SortByColumns to effectively reorder records
PowerApps aggregate functions
Counting rows using Count, CountA, CountIf and CountRows. Which one to use?
Grouping records and removing duplicated records
Requirements
Familiarity with Microsoft PowerApps
Understanding the basics of PowerApps development, enough to build a simple App and run it
Familiarity with PowerApps basic controls
Description
The course is structured in multiple projects, starting from requirements gathering to solutioning and effectively using the right formula to build an app that fits the scenario. Obviously you can find all these functions in Microsoft PowerApps documentations. This course is a connection between the knowledge and practical field problem. In this course you will learn:1. Basic table and database concepts in Power Apps (Record, Table, Arrays, Collection and variables)2. Mass insert, delete and update and detailed analysis about available functions in Power Apps and how to use the efficiantly.3. Working with Loops and Sequence to process the table items separately4. Bridge between behavior and non-behavior functions5. Condition and alternative options to If and Switch6. Changing table schema to make it fit our solution7. Bulk insert of record to a table/list instead of processing them one-by-one8. Working with fields that contain complex data9. Effect of internal field names and title on the way you use table functions10. Difference between Search, Filter and Lookup and where to use each one of them11. Chose between Sort and SortByColumns to effectively reorder records12. PowerApps aggregate functions13. Counting rows using Count, CountA, CountIf and CountRows. Which one to use?14. Grouping records and removing duplicated records

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 Course structure and content

Section 2: PowerApps formula basics

Lecture 3 Behavior formula vs non-behavior formula

Lecture 4 Using variables to bridge between behavior and non-behavior properties

Lecture 5 Working with PowerApps records

Lecture 6 Understanding and working with "Context"

Lecture 7 Tables and Arrays in PowerApps

Lecture 8 Loops in PowerApps - ForAll

Lecture 9 Working with PowerApps conditions - "If" and "Switch"

Lecture 10 If … beyond just a formula

Lecture 11 JSON the black sheep

Section 3: Table Table Functions - Project 1

Lecture 12 This is how it started

Lecture 13 Building the UI in PowerApps

Lecture 14 Unleash the power of Collect function in PowerApps

Lecture 15 Collection or Table variable… which one to use

Lecture 16 The right way to calculate subtotal

Lecture 17 Understanding "Remove" and "RemoveIf"

Lecture 18 Quick fix to "Remove" function - Test your knowledge

Lecture 19 Deleting an item from a gallery with confirmation dialog

Lecture 20 Creating lists for Project 1

Lecture 21 Layers of "Collect" function

Lecture 22 Adding one table to another table using "Collect"

Lecture 23 Using JSON as our silver bullet to discover complex data formats

Lecture 24 Adding Order to SharePoint and capturing newly inserted item in PowerApps

Lecture 25 Using collect to insert all order items in one line of code (and some surprises)

Lecture 26 How to get internal field name in a SharePoint list?

Lecture 27 Be careful… things are not as simple as you may think

Section 4: Table Table Functions - Project 2

Lecture 28 A project with focus on search

Lecture 29 Search, Filter and Lookup in action - Part 1

Lecture 30 Select, Filter and Lookup in action - Part 2

Section 5: More essential table functions - Project 3

Lecture 31 Using Distinct function to create combo box filters

Lecture 32 Adding extra item manually to "Distinct" result

Lecture 33 Sorting records like a pro

Lecture 34 How to effectively use SortByColumn

Lecture 35 Calculating average and sum in a data table

Section 6: A task management App with Dataverse - Project 4

Lecture 36 Counting records is more important than sum and average

Lecture 37 Adding task to Dataverse using "Edit form"

Lecture 38 Patching and updating Dataverse choice column

Lecture 39 Difference between PowerApps count functions (Count, CountA, CountRows, CountIf)

Lecture 40 Count vs CountA (Easy yet very important)

Section 7: Phase 2 of project 3 - Project 5

Lecture 41 This is where we need Patch function

Lecture 42 Patch can also create a new record, just like collect

Lecture 43 Patching complex data types

Lecture 44 Patch or UpdateIf?

Section 8: We have extra budget from project 3 - Project 6

Lecture 45 Let's make data summary better in our app

Lecture 46 Understanding GroupBy

Lecture 47 Using GroupBy in a "not-so-easy" situation and how to make it easy

Section 9: Let's finish this course

Lecture 48 Important - Review on what we learned

Lecture 49 Get your next course for free

PowerApps developers that would like to work with complex table function,Citizen developers who would like to understand app development cycles that involves working with data,People who have learned the basics of PowerApps and want to utilize data tables in their app