Skip to main content

Notifications

Deep Dive | Friday Functions Series - CountRows, CountIf, & Sum

Audrie101 Profile Picture Posted by Audrie101

Learn how to use mathematical functions to add a bit of summary reporting to your apps. In this demo, she'll show how to use CountRows(), CountIf(), and Sum() to add a quick summary roll-up of all change order requests this month (the list is archived monthly)! Have fun and get creative in how you might use these functions!

FYI: There are 2 change requests in my list that are neither Schedule or Cost (which is why the count is 13 rather than 11).

 

References:
https://docs.microsoft.com/en-us/powerapps/functions/function-table-counts
https://docs.microsoft.com/en-us/powerapps/functions/function-aggregates
https://docs.microsoft.com/en-us/powerapps/delegation-list

Happy PowerApping!

Categories:

Comments