cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
juanpeligroso
Frequent Visitor

Grouping Items from Collection In New Gallery

Can anybody help me with a small issue? I have an app that allows users to order products, though I want to aggregate the items at the end by Manufacturer & sum of the price of all the items selected from that manufacturer.

 

I'd like one screen to have a gallery that

 

a) Groups all items from MfrName together

b) sums the total MfrPrice

c) Sorts in alphabetical order for MfrName

 

End result should show a gallery with

 

Ashawa Bay, $199

Boen, $149

Reward, $347

 

grouping.PNG

1 REPLY 1
cherie
Power Apps
Power Apps

Hey,

 

Have you tried the groupby function? (https://powerapps.microsoft.com/en-us/tutorials/function-groupby/)

 

The example looks pretty close to what you want.

 

Thanks

Cherie

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (1,974)