Master Microsoft Power Apps Table functions
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 separately
4. Bridge between behavior and non-behavior functions
5. Condition and alternative options to If and Switch
6. Changing table schema to make it fit our solution
7. Bulk insert of record to a table/list instead of processing them one-by-one
8. Working with fields that contain complex data
9. Effect of internal field names and title on the way you use table functions
10. Difference between Search, Filter and Lookup and where to use each one of them
11. Chose between Sort and SortByColumns to effectively reorder records
12. PowerApps aggregate functions
13. Counting rows using Count, CountA, CountIf and CountRows. Which one to use?
14. Grouping records and removing duplicated records
PowerApps formula basics
Table Table Functions - Project 1
-
3
Behavior formula vs non-behavior formula -
4
Using variables to bridge between behavior and non-behavior properties
-
5
Working with PowerApps records
-
6
Understanding and working with "Context"
-
7
Tables and Arrays in PowerApps
-
8
Loops in PowerApps - ForAll
-
9
Working with PowerApps conditions - "If" and "Switch"
-
10
If ... beyond just a formula
-
11
JSON the black sheep
Table Table Functions - Project 2
-
12
This is how it started
-
13
Building the UI in PowerApps
-
14
Unleash the power of Collect function in PowerApps
-
15
Collection or Table variable... which one to use
-
16
The right way to calculate subtotal
-
17
Understanding "Remove" and "RemoveIf"
-
18
Quick fix to "Remove" function - Test your knowledge
-
19
Deleting an item from a gallery with confirmation dialog
-
20
Creating lists for Project 1
-
21
Layers of "Collect" function
-
22
Adding one table to another table using "Collect"
-
23
Using JSON as our silver bullet to discover complex data formats
-
24
Adding Order to SharePoint and capturing newly inserted item in PowerApps
-
25
Using collect to insert all order items in one line of code (and some surprises)
-
26
How to get internal field name in a SharePoint list?
-
27
Be careful... things are not as simple as you may think
More essential table functions - Project 3
A task management App with Dataverse - Project 4
Phase 2 of project 3 - Project 5
We have extra budget from project 3 - Project 6
Edit data in a PowerApps grid - Project 7
