Master Microsoft Power Apps Table functions

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

Created by: Alireza Aliabadi
Microsoft Solutions Architect

What Will I 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

Target audience

• 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