Distinct and sum 2 columns

(0) Share

Report

Posted on by Field

339

Hello,

In my sharepoint list i have the following items:

Title - Number

Test A - 4

Test A - 2

Test B - 3

Test C - 2

Test B - 3

I want to put that information in a gallery but remove duplicates and add them together, so in reality, the gallery on PowerApps should be showing this:

Test A - 8

Test B - 6

Test C - 2

I can remove duplicates, but not sum.

Using sum will give a random number that i do not want

Can somebody help?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

mdevaney 29,991 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
@Field

This is a classic Collections problem called "How can I GROUPBY a column and SUM the values". Here's the solution

ClearCollect( myGroupedCollection, GroupBy(your_datasource_name,"Title","GroupedItems") ); ClearCollect( mySolution, DropColumns( AddColumns(myGroupedExpenses,"Sum of Value",Sum(GroupedItems,Value)), "GroupedItems" ) );

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
Mana 171 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @Field @mdevaney ,
Thanks for sharing. I am dealing with the same problem. having:

ProductName ProductAmount
A 6
B 2
C 3
A 2
A 5

But I want to have:
ProductName ProductAmount
A 13
B 2
C 3

I can't see how to use your solution regarding my fields. would you please help me

Was this reply helpful? Yes No
Mana 171 on at

Like
a
(0)

Report
Copy link

Link copied!

By the way the name of my first collection is colProduct wich has duplicates

Was this reply helpful? Yes No