cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ciprianpopovici
Helper II
Helper II

Gallery group similar article and sumif quantities

I have a  a SharePoint list with articles ordered and quantities. In a gallery or other way  I want to display this information like in example bellow, summarized with total quantities per each type of article. For example like Sum if in excel. See bellow for example. How ca i display this information like this.

 

ciprianpopovici_0-1655992571958.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
WarrenBelz
Super User
Super User

Hi @ciprianpopovici ,

I am assuming field names (Articles and Quantity) here, so change to yours

AddColumns(
   GroupBy(
      SPListName,
      "Articles",
      "Data"
   ),
   "Ordered",
   Sum(
      Data,
      Quantity
   )
)

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

 

View solution in original post

3 REPLIES 3
WarrenBelz
Super User
Super User

Hi @ciprianpopovici ,

I am assuming field names (Articles and Quantity) here, so change to yours

AddColumns(
   GroupBy(
      SPListName,
      "Articles",
      "Data"
   ),
   "Ordered",
   Sum(
      Data,
      Quantity
   )
)

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

 

WarrenBelz
Super User
Super User

Hi @ciprianpopovici ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Sorry for my late response. i was in holiday and forget to respond..

 

Thank you very much for help. Your solution it's working.

 

Thanks.

 

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events that are happening this month - don't miss out!

Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Users online (4,517)