Combine Duplicate items in colum

[EOCF-Pwrapp]

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

[Shanescows · Accepted 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

[EOCF-Pwrapp]

Omg! Shane from BoldZebra!?

I'm so honored! Big fan of your tutorials by the way. 

[EOCF-Pwrapp]

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!