Master Microsoft 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
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 separately4. Bridge between behavior and non-behavior functions5. Condition and alternative options to If and Switch6. Changing table schema to make it fit our solution7. Bulk insert of record to a table/list instead of processing them one-by-one8. Working with fields that contain complex data9. Effect of internal field names and title on the way you use table functions10. Difference between Search, Filter and Lookup and where to use each one of them11. Chose between Sort and SortByColumns to effectively reorder records12. PowerApps aggregate functions13. Counting rows using Count, CountA, CountIf and CountRows. Which one to use?14. Grouping records and removing duplicated records
Overview
Section 1: Introduction
Lecture 1 Introduction
Lecture 2 Course structure and content
Section 2: PowerApps formula basics
Lecture 3 Behavior formula vs non-behavior formula
Lecture 4 Using variables to bridge between behavior and non-behavior properties
Lecture 5 Working with PowerApps records
Lecture 6 Understanding and working with “Context”
Lecture 7 Tables and Arrays in PowerApps
Lecture 8 Loops in PowerApps – ForAll
Lecture 9 Working with PowerApps conditions – “If” and “Switch”
Lecture 10 If … beyond just a formula
Lecture 11 JSON the black sheep
Section 3: Table Table Functions – Project 1
Lecture 12 This is how it started
Lecture 13 Building the UI in PowerApps
Lecture 14 Unleash the power of Collect function in PowerApps
Lecture 15 Collection or Table variable… which one to use
Lecture 16 The right way to calculate subtotal
Lecture 17 Understanding “Remove” and “RemoveIf”
Lecture 18 Quick fix to “Remove” function – Test your knowledge
Lecture 19 Deleting an item from a gallery with confirmation dialog
Lecture 20 Creating lists for Project 1
Lecture 21 Layers of “Collect” function
Lecture 22 Adding one table to another table using “Collect”
Lecture 23 Using JSON as our silver bullet to discover complex data formats
Lecture 24 Adding Order to SharePoint and capturing newly inserted item in PowerApps
Lecture 25 Using collect to insert all order items in one line of code (and some surprises)
Lecture 26 How to get internal field name in a SharePoint list?
Lecture 27 Be careful… things are not as simple as you may think
Section 4: Table Table Functions – Project 2
Lecture 28 A project with focus on search
Lecture 29 Search, Filter and Lookup in action – Part 1
Lecture 30 Select, Filter and Lookup in action – Part 2
Section 5: More essential table functions – Project 3
Lecture 31 Using Distinct function to create combo box filters
Lecture 32 Adding extra item manually to “Distinct” result
Lecture 33 Sorting records like a pro
Lecture 34 How to effectively use SortByColumn
Lecture 35 Calculating average and sum in a data table
Section 6: A task management App with Dataverse – Project 4
Lecture 36 Counting records is more important than sum and average
Lecture 37 Adding task to Dataverse using “Edit form”
Lecture 38 Patching and updating Dataverse choice column
Lecture 39 Difference between PowerApps count functions (Count, CountA, CountRows, CountIf)
Lecture 40 Count vs CountA (Easy yet very important)
Section 7: Phase 2 of project 3 – Project 5
Lecture 41 This is where we need Patch function
Lecture 42 Patch can also create a new record, just like collect
Lecture 43 Patching complex data types
Lecture 44 Patch or UpdateIf?
Section 8: We have extra budget from project 3 – Project 6
Lecture 45 Let’s make data summary better in our app
Lecture 46 Understanding GroupBy
Lecture 47 Using GroupBy in a “not-so-easy” situation and how to make it easy
Section 9: Let’s finish this course
Lecture 48 Important – Review on what we learned
Lecture 49 The elephant in the room – The biggest missing part in this course
Lecture 50 Get your next course for free
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 Information:
Udemy | English | 7h 48m | 3.53 GB
Created by: Alireza Aliabadi
You Can See More Courses in the IT & Software >> Greetings from CourseDown.com