Group By And Find The SUM
Group By And Find The SUM Input collection: myTravelExpenses6 Date Item Value 1/1/2020 Hotel 1050 1/1/2020 Food 30 1/2/2020 Food 75 1/3/2020 Hotel 1300 1/3/2...
- Published
- Reading time
- 1 min read
Before you start
Is this guide for you?
- Best entry point
- Power Apps
- Time investment
- 1 min read
Imported reference from Matthew Devaney's blog for learning purposes. Original: https://www.matthewdevaney.com/powerapps-collections-cookbook/group-by-and-find-the-sum/. Author: Matthew Devaney.
Group By And Find The SUM Input collection: myTravelExpenses6 Date Item Value 1/1/2020 Hotel 1050 1/1/2020 Food 30 1/2/2020 Food 75 1/3/2020 Hotel 1300 1/3/2020 Food 50 1/4/2020 Flight 800 Output collection: mySolution6 Item Sum Of Value Hotel 2350 Food 155 Flight 800 Solution code: //Create a collection
ClearCollect(myTravelExpenses6, { Date : Date ( 2020 , 1 , 1 ), Item : "Hotel" , Value : 1050 }, { Date : Date ( 2020 , 1 , 1 ), Item : "Food" , Value : 30 }, { Date : Date ( 2020 , 1 , 2 ), Item : "Food" , Value : 75 }, { Date : Date ( 2020 , 1 , 3 ), Item : "Hotel" , Value : 1300 }, { Date : Date ( 2020 , 1 , 3 ), Item : "Food" , Value : 50 }, { Date : Date ( 2020 , 1 , 4 ), Item : "Flight" , Value : 800 } ); //Group by and sum column code
ClearCollect( mySolution6, DropColumns( AddColumns( GroupBy(myTravelExpenses6, "Item" , "GroupedItems" ),
"Sum of Value" ,Sum(GroupedItems,Value) ), "GroupedItems" ) ); Code language: JavaScript ( javascript )
Tagged
Power Apps
Have a Microsoft 365 topic idea?
Share article suggestions, community session ideas, corrections, or real-world scenarios for future nxtM365 learning notes.
Keep learning Microsoft 365
Explore more practical guides for SharePoint, Power Platform, Copilot Studio, migration, automation, governance, and security.
Continue learning
Related tutorials
Related questions
Related comparisons
Next action