Master Microsoft Power Apps Table functions
- Description
- Curriculum
- FAQ
- Reviews
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
-
3Behavior formula vs non-behavior formulaVideo lesson
-
4Using variables to bridge between behavior and non-behavior propertiesVideo lesson
-
5Working with PowerApps recordsVideo lesson
-
6Understanding and working with "Context"Video lesson
-
7Tables and Arrays in PowerAppsVideo lesson
-
8Loops in PowerApps - ForAllVideo lesson
-
9Working with PowerApps conditions - "If" and "Switch"Video lesson
-
10If ... beyond just a formulaVideo lesson
-
11JSON the black sheepVideo lesson
-
12This is how it startedVideo lesson
-
13Building the UI in PowerAppsVideo lesson
-
14Unleash the power of Collect function in PowerAppsVideo lesson
-
15Collection or Table variable... which one to useVideo lesson
-
16The right way to calculate subtotalVideo lesson
-
17Understanding "Remove" and "RemoveIf"Video lesson
-
18Quick fix to "Remove" function - Test your knowledgeVideo lesson
-
19Deleting an item from a gallery with confirmation dialogVideo lesson
-
20Creating lists for Project 1Video lesson
-
21Layers of "Collect" functionVideo lesson
-
22Adding one table to another table using "Collect"Video lesson
-
23Using JSON as our silver bullet to discover complex data formatsVideo lesson
-
24Adding Order to SharePoint and capturing newly inserted item in PowerAppsVideo lesson
-
25Using collect to insert all order items in one line of code (and some surprises)Video lesson
-
26How to get internal field name in a SharePoint list?Video lesson
-
27Be careful... things are not as simple as you may thinkVideo lesson
-
37Counting records is more important than sum and averageVideo lesson
-
38Adding task to Dataverse using "Edit form"Video lesson
-
39Patching and updating Dataverse choice columnVideo lesson
-
40Difference between PowerApps count functions (Count, CountA, CountRows, CountIf)Video lesson
-
41Count vs CountA (Easy yet very important)Video lesson
-
49The project was very easy... at least in the beginningVideo lesson
-
50Enable auto save on a PowerApps galleryVideo lesson
-
51Adding save and undo buttons to every row in PowerApps galleryVideo lesson
-
52Single save button to save all changes in a PowerApps galleryVideo lesson
-
53Highlight the changed rows in a GalleryVideo lesson
