In my sharepoint list i have the following items:
Title - Number
Test A - 4
Test A - 2
Test B - 3
Test C - 2
I want to put that information in a gallery but remove duplicates and add them together, so in reality, the gallery on PowerApps should be showing this:
Test A - 8
Test B - 6
I can remove duplicates, but not sum.
Using sum will give a random number that i do not want
Can somebody help?
Go to Solution.
This is a classic Collections problem called "How can I GROUPBY a column and SUM the values". Here's the solution
AddColumns(myGroupedExpenses,"Sum of Value",Sum(GroupedItems,Value)),
---Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
View solution in original post
Check out new user group experience and if you are a leader please create your group
Check out how to claim yours today!
Test your skills now with the Cloud Skill Challenge.