Save on skills. Reach your goals from $11.99

Master Microsoft Power Apps Table functions

Last updated on April 28, 2024 10:51 am
Category:

Description

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

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

Course content

  • Introduction2 lectures • 6min
  • Introduction
  • PowerApps formula basics9 lectures • 1hr 21min
  • PowerApps formula basics
  • Table Table Functions – Project 116 lectures • 2hr 48min
  • Table Table Functions – Project 1
  • Table Table Functions – Project 23 lectures • 47min
  • Table Table Functions – Project 2
  • More essential table functions – Project 35 lectures • 43min
  • More essential table functions – Project 3
  • A task management App with Dataverse – Project 45 lectures • 42min
  • A task management App with Dataverse – Project 4
  • Phase 2 of project 3 – Project 54 lectures • 42min
  • Phase 2 of project 3 – Project 5
  • We have extra budget from project 3 – Project 63 lectures • 28min
  • We have extra budget from project 3 – Project 6
  • Edit data in a PowerApps grid – Project 75 lectures • 46min
  • Edit data in a PowerApps grid – Project 7
  • Let’s finish this course3 lectures • 11min
  • Let’s finish this course

Reviews

There are no reviews yet.

Be the first to review “Master Microsoft Power Apps Table functions”

Your email address will not be published. Required fields are marked *