Master Microsoft Power Apps Table functions

Focused View

Alireza Aliabadi

7:50:06

113 View

1 - Introduction

1 - Introduction.mp4

03:32

2 - Course structure and content.mp4

02:31

2 - PowerApps formula basics

3 - Behavior formula vs nonbehavior formula.mp4

06:59

4 - Using variables to bridge between behavior and nonbehavior properties.mp4

08:02

5 - Working with PowerApps records.mp4

07:24

6 - Understanding and working with Context.mp4

10:45

7 - Tables and Arrays in PowerApps.mp4

09:42

8 - Loops in PowerApps ForAll.mp4

14:52

8 - staff-table.zip

9 - Working with PowerApps conditions If and Switch.mp4

09:01

10 - If beyond just a formula.mp4

06:21

11 - JSON the black sheep.mp4

07:30

3 - Table Table Functions Project 1

12 - This is how it started.mp4

05:39

13 - Building the UI in PowerApps.mp4

12:37

14 - Unleash the power of Collect function in PowerApps.mp4

11:08

15 - Collection or Table variable which one to use.mp4

14:08

16 - The right way to calculate subtotal.mp4

11:34

17 - Understanding Remove and RemoveIf.mp4

14:09

18 - Quick fix to Remove function Test your knowledge.mp4

03:48

19 - Deleting an item from a gallery with confirmation dialog.mp4

13:15

20 - Creating lists for Project 1.mp4

07:42

21 - Layers of Collect function.mp4

15:43

22 - Adding one table to another table using Collect.mp4

06:44

23 - Using JSON as our silver bullet to discover complex data formats.mp4

12:43

24 - Adding Order to SharePoint and capturing newly inserted item in PowerApps.mp4

09:10

24 - how to prepopulate person field in powerapps edit form for new record.zip

25 - Using collect to insert all order items in one line of code and some surprises.mp4

14:55

26 - How to get internal field name in a SharePoint list.mp4

11:24

26 - sharepoint online client browser download.zip

27 - Be careful things are not as simple as you may think.mp4

07:33

4 - Table Table Functions Project 2

28 - A project with focus on search.mp4

26:05

28 - Financial-Sample.xlsx

29 - Search Filter and Lookup in action Part 1.mp4

11:55

30 - Select Filter and Lookup in action Part 2.mp4

08:43

5 - More essential table functions Project 3

31 - Using Distinct function to create combo box filters.mp4

07:37

32 - Adding extra item manually to Distinct result.mp4

08:47

33 - Sorting records like a pro.mp4

07:23

34 - How to effectively use SortByColumn.mp4

08:20

35 - Calculating average and sum in a data table.mp4

11:15

6 - A task management App with Dataverse Project 4

36 - Counting records is more important than sum and average.mp4

05:42

37 - Adding task to Dataverse using Edit form.mp4

07:43

38 - Patching and updating Dataverse choice column.mp4

16:51

39 - Difference between PowerApps count functions Count CountA CountRows CountIf.mp4

07:32

40 - Count vs CountA Easy yet very important.mp4

04:37

7 - Phase 2 of project 3 Project 5

41 - This is where we need Patch function.mp4

11:17

42 - Patch can also create a new record just like collect.mp4

07:35

43 - Patching complex data types.mp4

14:20

44 - Patch or UpdateIf.mp4

08:18

44 - patch vs update vs updateif.zip

8 - We have extra budget from project 3 Project 6

45 - Lets make data summary better in our app.mp4

05:04

46 - Understanding GroupBy.mp4

08:37

47 - Using GroupBy in a notsoeasy situation and how to make it easy.mp4

14:10

9 - Lets finish this course

48 - Important Review on what we learned.mp4

04:49

49 - Get your next course for free.mp4

04:35

Description

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

Who is this 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

More details

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 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

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

User Reviews

Rating

average 0

Total votes0

Focused display

Microsoft Power Apps

Alireza Aliabadi

Instructor's Courses

Alireza is a Solutions Architect and a Microsoft Certified Trainer with years of experience delivering technology courses to corporate clients as well as academic environments. With 18 years of experience as developer, architect and system integrator mainly on Microsoft platform; demonstrates outstanding expertise in .NET technologies, SharePoint, BizTalk, Logic Apps and Microsoft Flow.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.