Group and Sum a collection

(0) Share

Report

Posted on by wailey1

Ive tried lots of different methods but i cant get any to work.

I have a collection - colProducts1 with the columns below

I have a vertical gallery that picks up the 'Title' (product), the 'Category' and the 'Quantity' of this collection

I am trying to group the products by 'Title' and sum by the 'Quantity'.

My various attempts have managed to group by products, but the quantity wont show as its looking for a 'number'??

Or i can get it to add all the quantities together but not by grouped products.

Ideally id like the results in a new collection so i can display on a different page to the original collection.

Help please!!

Categories:

Building Power Apps

I have the same question (0)

All responses (12)

Answers (1)

Sort by

Gochix 1,937 Moderator on at

Like (0)

Report
Copy link

Link copied!

@wailey1 ,

This is a quick reply, but have you tried to use Distinct() function for the Gallery Items, and the a LookUp function for Quantity label?
_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!

Was this reply helpful? Yes No
VishalJhaveri 1,169 Moderator on at

Like (0)

Report
Copy link

Link copied!

ClearCollect(
GroupedSalesData,
GroupBy(SalesData, "Category", "GroupedItems")
)

ClearCollect(
SummarizedSalesData,
AddColumns(
GroupedSalesData,
"TotalAmount",
Sum(GroupedItems, Amount)
)
)

Try this out. It should work.

Was this reply helpful? Yes No
wailey1 30 on at

Like (0)

Report
Copy link

Link copied!

Hi
Thanks for replying so quickly, no i havent as i have no idea how to use distinct!! Can you guide me through please i am a power app novice!

Was this reply helpful? Yes No
wailey1 30 on at

Like (0)

Report
Copy link

Link copied!

Thanks so much for your reply. I am a power apps novice, so where does this formula go - to a button 'on select' or can i put this into the 'items' for a new gallery? GroupedSalesData is my new collection? SalesData is my original collection 'colProducts1'?

Was this reply helpful? Yes No
Gochix 1,937 Moderator on at

Like (0)

Report
Copy link

Link copied!
@wailey1 ,
You can do all that in the Gallery Items:
AddColumns( GroupBy( colProducts1,Title,Category,'GroupedItems'), 'TotalAmount', Sum(GroupedItems,Quantity) )

_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!

Was this reply helpful? Yes No
wailey1 30 on at

Like (0)

Report
Copy link

Link copied!

Im so sorry, by brain isnt working. Im assuming from setting up a new gallery i cant just put in 'Items' the formula beginning with 'Add Columns'. Ive tried using the formula from VishalJhaveri in the 'Items', but get the red error lines of doom. Im going to be a right pain and ask from scratch and using my naming convention, what the steps are please?

Was this reply helpful? Yes No
VishalJhaveri 1,169 Moderator on at

Like (0)

Report
Copy link

Link copied!

This goes in the Items property of the gallery.

Was this reply helpful? Yes No
Gochix 1,937 Moderator on at

Like (0)

Report
Copy link

Link copied!

@wailey1 ,
That's correct, set a new gallery and put in items the formula I've provided.
_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!

Was this reply helpful? Yes No
wailey1 30 on at

Like (0)

Report
Copy link

Link copied!

Thanks for your time.
Im clearly not doing something right
Do i need to do something in the gallery properties?

Was this reply helpful? Yes No
Gochix 1,937 Moderator on at

Like (0)

Report
Copy link

Link copied!

@wailey1 ,
If you move the mouse on top where red underlines are, it should tell you what's the error.
Can you provide that information, for me to look at it.

I checked the formula at my side, so it's either wrong column names or something else.

_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!

Was this reply helpful? Yes No