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
