Master Microsoft Power Apps Table functions

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

4.73 (365 reviews)

Udemy

platform

English

language

Other

What you will 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

Why take this course?

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

Reviews

Stephan

October 8, 2023

Good Coverage of Basic Variables, Collections, Tables. Didn't know the intricacies of the Collect Function.

Padmanabh

August 15, 2023

Excellent insights and amazing knowledge on hands on practise by the instructor. Kudos to the way he has designed the course.

Udith

August 1, 2023

This is a very good course follow it covers the all the Table functions that you need to know. now I'm not fear to do MS Power Apps. Thank you Alireza

Muhammad

July 30, 2023

A well written course, Alireza has always been an amazing instructor to learn PowerPlatform tools. A lot of useful nuggets picked along the way.

Kelly

May 19, 2023

Love the content. Really well explained so far. The audio could use a little editing as there is a fair amount of sibilance. Looking forward to the rest of the course.

Justin

February 15, 2023

Really good course for advanced knowledge of power apps, I learned a lot with a simpless explaination. Alireza is a very good instructor.

Subhadeep

January 22, 2023

Absolutely Superb!! Just one point to share: I am a Dynamics CRM developer and mostly work with dataverse. Is there any possibility to include few more examples with dataverse in this course?

Antonios

January 11, 2023

Mr Alireza delivers the subject with an in depth aproach that really helps a student to understand and achieve quality learning.

Juan

January 10, 2023

Excellent So Far!! Alireza is an amazing instructor. I am so glad that I purchased this course. Wow! Amazing, thank you very much for sharing so much.

Bassem

January 2, 2023

Good job, I am very happy to have taken this course and will be waiting for your next work. Thank you a lot.

Игорь

December 16, 2022

The course material is presented in a very accessible and understandable way. I really liked the clever use of real life examples. Thank you very much!

Rinaldo

December 11, 2022

Amazing course! Alireza has a formidable didactics. The course was prepared full of details that we come across on a daily basis during development that are not documented anywhere and that as a rule it takes many hours of internet to be able to find the solution. Easy language, precise examples and many interesting tips. The course is worth every second and every penny invested. I loved it. Congratulations.

Andreas

November 26, 2022

This course was very detailed and organized like the other online courses provided by Alireza (with Udemy and on YouTube). I found it again very effective, usable for my work and I enjoyed it.

Vladimir

November 16, 2022

Maximum useful content; I enjoyed every moment of this course. I recommend it to all beginners as well as advanced users. Thank you so much Alireza!

Victor

November 12, 2022

Excellent pace and examples. Best of all you follow a project and so all makes sense and is related in the end

Charts

Price

Rating

Enrollment distribution

Master Microsoft Power Apps Table functions - Distribution chart