Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Master Microsoft Power Apps Table functions

Name: Master Microsoft Power Apps Table functions
Rating: 4.8 (714 reviews)

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

Created byAlireza Aliabadi

Last updated 3/2024

English

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

Course content

10 sections • 55 lectures • 8h 33m total length

Introduction3:32
Course structure and content2:31

This is how it started5:39
Building the UI in PowerApps12:37
Unleash the power of Collect function in PowerApps11:08
Collection or Table variable... which one to use14:08
The right way to calculate subtotal11:34
Understanding "Remove" and "RemoveIf"14:09
Quick fix to "Remove" function - Test your knowledge3:48
Deleting an item from a gallery with confirmation dialog13:15
Creating lists for Project 17:42
Create and link SharePoint lists for project one orders and order items using a lookup, then group by order. Explore Power Apps table functions for data handling and collect-based insertion.
Layers of "Collect" function11:14
Adding one table to another table using "Collect"6:44
Use collect to append a whole table to another table, like a SharePoint list. Create a contextual table with the table function and map its fields to the target schema.
Using JSON as our silver bullet to discover complex data formats12:43
Adding Order to SharePoint and capturing newly inserted item in PowerApps9:10
Using collect to insert all order items in one line of code (and some surprises)14:55
How to get internal field name in a SharePoint list?11:24
Be careful... things are not as simple as you may think7:33
Clean up your Power Apps demo by validating required fields and data integrity when adding items to SharePoint lists. Explore collect behavior with invalid records for a reliable client demo.

A project with focus on search26:05
The lecture compares search, filter, and lookup, showing that search returns a collection with or logic, filter uses and logic for multiple conditions, and lookup returns a single record.
Filter, Search and LookUp
Search, Filter and Lookup in action - Part 111:55
Create a Power Apps canvas app that lists order items with subtotal over 20, using filter and starts with search, connected to SharePoint orders and items, with related order details.
Select, Filter and Lookup in action - Part 28:43

Counting records is more important than sum and average5:42
Adding task to Dataverse using "Edit form"7:43
Patching and updating Dataverse choice column16:51
Learn how to populate a Dataverse choice field with the Power Apps choices function, set a default active value, and patch updates to my task status using plain text conversions.
Difference between PowerApps count functions (Count, CountA, CountRows, CountIf)7:32
Count vs CountA (Easy yet very important)4:37

The project was very easy... at least in the beginning7:08
Enable auto save on a PowerApps gallery6:55
Enable autosave in a PowerApps gallery using onChange and patch to SharePoint, converting input with value for numeric fields, and assess focus loss, concurrency, and the no-undo trade-offs.
Adding save and undo buttons to every row in PowerApps gallery12:49
Single save button to save all changes in a PowerApps gallery16:01
Highlight the changed rows in a Gallery3:34
Learn to highlight changed rows in a gallery by tracking an isModified flag in a local collection and conditionally color-coding updated items for clear user feedback in Power Apps.

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

Master Microsoft Power Apps Table functions

What you'll learn

Explore related topics

Course content

Introduction2 lectures • 6min

PowerApps formula basics9 lectures • 1hr 21min

Table Table Functions - Project 116 lectures • 2hr 48min

Table Table Functions - Project 23 lectures • 47min

More essential table functions - Project 35 lectures • 43min

A task management App with Dataverse - Project 45 lectures • 42min

Phase 2 of project 3 - Project 54 lectures • 42min

We have extra budget from project 3 - Project 63 lectures • 28min

Edit data in a PowerApps grid - Project 75 lectures • 46min

Let's finish this course3 lectures • 11min

Requirements

Description

Who this course is for: