Master Microsoft Power Apps Table functions

  • Post category:StudyBullet-16
  • Reading time:8 mins read


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

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

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


Get Instant Notification of New Courses on our Telegram channel.


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

English
language

Content

Introduction

Introduction
Course structure and content

PowerApps formula basics

Behavior formula vs non-behavior formula
Using variables to bridge between behavior and non-behavior properties
Working with PowerApps records
Understanding and working with “Context”
Tables and Arrays in PowerApps
Loops in PowerApps – ForAll
Working with PowerApps conditions – “If” and “Switch”
If … beyond just a formula
JSON the black sheep

Table Table Functions – Project 1

This is how it started
Building the UI in PowerApps
Unleash the power of Collect function in PowerApps
Collection or Table variable… which one to use
The right way to calculate subtotal
Understanding “Remove” and “RemoveIf”
Quick fix to “Remove” function – Test your knowledge
Deleting an item from a gallery with confirmation dialog
Creating lists for Project 1
Layers of “Collect” function
Adding one table to another table using “Collect”
Using JSON as our silver bullet to discover complex data formats
Adding Order to SharePoint and capturing newly inserted item in PowerApps
Using collect to insert all order items in one line of code (and some surprises)
How to get internal field name in a SharePoint list?
Be careful… things are not as simple as you may think

Table Table Functions – Project 2

A project with focus on search
Filter, Search and LookUp
Search, Filter and Lookup in action – Part 1
Select, Filter and Lookup in action – Part 2

More essential table functions – Project 3

Using Distinct function to create combo box filters
Adding extra item manually to “Distinct” result
Sorting records like a pro
How to effectively use SortByColumn
Calculating average and sum in a data table

A task management App with Dataverse – Project 4

Counting records is more important than sum and average
Adding task to Dataverse using “Edit form”
Patching and updating Dataverse choice column
Difference between PowerApps count functions (Count, CountA, CountRows, CountIf)
Count vs CountA (Easy yet very important)

Phase 2 of project 3 – Project 5

This is where we need Patch function
Patch can also create a new record, just like collect
Patching complex data types
Patch or UpdateIf?

We have extra budget from project 3 – Project 6

Let’s make data summary better in our app
Understanding GroupBy
Using GroupBy in a “not-so-easy” situation and how to make it easy

Let’s finish this course

Important – Review on what we learned
Get your next course for free
Enroll for Free

💠 Follow this Video to Get Free Courses on Every Needed Topics! 💠

Tags: , ,