Answered

Help with a formula to sum collect values

(0) Share

Report

Posted on by resteve

Hello,

I create a collection from excel Datasource with the formula: ClearCollect(GroupbyConcept; GroupBy(Tabla1; "Concepto"; "total"))

But I don't know how to Sum the prices by concept, por example:

Autopista: 64 €

Dieta: 117,54

Excel DataSource:

Excel

Collection

Collection 2

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (2)

Sort by

Verified answer

Meneghino 6,949 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @resteve, please try this. (Please note that you probably have to use ; instead of ,)

AddColumns(GroupByConcept, "SumByConcept", Sum(total, Precio))
You could even do this
ClearCollect(GroupbyConcept, AddColumns(GroupBy(Tabla1, "Concepto", "total"), "SumByConcept", Sum(total, Precio)))
Please let me know how you get on.

Was this reply helpful? Yes No
resteve 52 on at

Like
a
(0)

Report
Copy link

Link copied!

Perfect, it works!
~~Then I need two formulas and two different buttons?~~
~~ClearCollect(GroupbyConcept; GroupBy(Tabla1; "Concepto"; "total"))~~
~~ClearCollect(GroupbyConcept;AddColumns(GroupBy(Tabla1;"Concepto";"total");"SumByConcept"; Sum(total; Precio)))~~

I add a chart but the legend is the same than chart, Can I change to concepto?. Thank you!

Was this reply helpful? Yes No
resteve 52 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry, first paragraph or question of the previous post is already solved, I can have several actions in one formula with PowerApps chaining operator: ;; (double semi-colon) but only it's necessary the second action. Thank you!

Was this reply helpful? Yes No
Meneghino 6,949 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @resteve
Yes, try changing the labels or series to Concepto, see below...

Was this reply helpful? Yes No
resteve 52 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,
I attach some screenshots because I've changed the labels and series but it doesn't work.

Was this reply helpful? Yes No
Verified answer

Meneghino 6,949 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @resteve
I have found the solution. The key is in your third screenshot. You need to change the Items property from PieChart1.SeriesLabels to GroupByConcept and then the Value to Concepto.
Please let me know how you get on.

Was this reply helpful? Yes No
resteve 52 on at

Like
a
(0)

Report
Copy link

Link copied!

Done . Thank you so much!. This community is very helpful!

Was this reply helpful? Yes No