I have a simple shopping cart collection with itemName and quantity. I would like to combine duplicate entries of an item and add up the number of the quantity. How can I achive this?
Item | Qty |
Laminating Pouches | 1 |
Laminating Pouches | 1 |
Laminating Pouches | 1 |
Laminating Pouches | 1 |
Laminating Pouches | 1 |
to
Item | Qty |
Laminating Pouches | 5 |
Solved! Go to Solution.
I haven't don't much with it but I think this example can get you there.
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-groupby
I haven't don't much with it but I think this example can get you there.
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-groupby
Omg! Shane from BoldZebra!?
I'm so honored! Big fan of your tutorials by the way.
It got it to work by grouping and creating 3 diffrent collections, from wich I did the sum of items on the last collection.
A Button preforms the following from the existing collection "ShoppingCart"
ClearCollect(ItemsByDes, GroupBy(ShoppingCart, "item", "qtys"));ClearCollect(ItemCount, AddColumns(ItemsByDes, "total of item", Sum(qtys, qty)))
Thanks for the reference!
User | Count |
---|---|
183 | |
108 | |
88 | |
44 | |
43 |
User | Count |
---|---|
226 | |
108 | |
105 | |
68 | |
68 |