Master Microsoft Power Apps Table functions

سرفصل های دوره

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

1 - Introduction

1 - Introduction

2 - Course structure and content

2 - PowerApps formula basics

3 - Behavior formula vs nonbehavior formula

4 - Using variables to bridge between behavior and nonbehavior properties

5 - Working with PowerApps records

6 - Understanding and working with Context

7 - Tables and Arrays in PowerApps

8 - Loops in PowerApps ForAll

8 - staff-table.zip

9 - Working with PowerApps conditions If and Switch

10 - If beyond just a formula

11 - JSON the black sheep

3 - Table Table Functions Project 1

12 - This is how it started

13 - Building the UI in PowerApps

14 - Unleash the power of Collect function in PowerApps

15 - Collection or Table variable which one to use

16 - The right way to calculate subtotal

17 - Understanding Remove and RemoveIf

18 - Quick fix to Remove function Test your knowledge

19 - Deleting an item from a gallery with confirmation dialog

20 - Creating lists for Project 1

21 - Layers of Collect function

22 - Adding one table to another table using Collect

23 - Using JSON as our silver bullet to discover complex data formats

24 - Adding Order to SharePoint and capturing newly inserted item in PowerApps

24 - how to prepopulate person field in powerapps edit form for new record.zip

25 - Using collect to insert all order items in one line of code and some surprises

26 - How to get internal field name in a SharePoint list

26 - sharepoint online client browser download.zip

27 - Be careful things are not as simple as you may think

4 - Table Table Functions Project 2

28 - A project with focus on search

28 - Financial-Sample.xlsx

29 - Search Filter and Lookup in action Part 1

30 - Select Filter and Lookup in action Part 2

5 - More essential table functions Project 3

31 - Using Distinct function to create combo box filters

32 - Adding extra item manually to Distinct result

33 - Sorting records like a pro

34 - How to effectively use SortByColumn

35 - Calculating average and sum in a data table

6 - A task management App with Dataverse Project 4

36 - Counting records is more important than sum and average

37 - Adding task to Dataverse using Edit form

38 - Patching and updating Dataverse choice column

39 - Difference between PowerApps count functions Count CountA CountRows CountIf

40 - Count vs CountA Easy yet very important

7 - Phase 2 of project 3 Project 5

41 - This is where we need Patch function

42 - Patch can also create a new record just like collect

43 - Patching complex data types

44 - Patch or UpdateIf

44 - patch vs update vs updateif.zip

8 - We have extra budget from project 3 Project 6

45 - Lets make data summary better in our app

46 - Understanding GroupBy

47 - Using GroupBy in a notsoeasy situation and how to make it easy

9 - Lets finish this course

48 - Important Review on what we learned

49 - Get your next course for free

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training