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

Who this course is for:
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