Answered

Sum() Collection within Gallery

(0) Share

Report

Posted on by nicklimcs

Hi all, can someone please point me to the right direction. I have a txtLabel outside of the gallery where I use it to sum the total number input within the gallery.

Below is the txtLabel Text property. The output I am expecting is 9 instead of 10.

Sum(galTasks.AllItems, numInputPartner.Value)

Another example, the output should be 1 instead of 2

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (2)

Sort by

v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @nicklimcs ,

Do you want to sum all items with "Meeting with clients" + "Draft"?

Please try this.

Sum(AddColumns(Gallery.AllItems,"sum",Value(TextInput1.Text)+Value(TextInput2.Text)),sum)

Best reards,

Rimmon

Was this reply helpful? Yes No
WarrenBelz 155,399 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @nicklimcs ,

Firstly try

Sum( galTasks.AllItems, Value(numInputPartner.Value) )

If that does not work, but in a Classic Text Input and use

Sum( galTasks.AllItems, Value(TextInputName.Text) )

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
nicklimcs 77 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-mengmli-msft

In my case, there's only ONE txtInput within the gallery. The reason you're seeing two is because the Collection has two rows of record.

Was this reply helpful? Yes No
nicklimcs 77 on at

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz

No luck with any of it, still having the same problem unfortunately.

Was this reply helpful? Yes No
JamesYumnam on at

Like (0)

Report
Copy link

Link copied!

Hi @nicklimcs , as previously suggested by @WarrenBelz, the below Sum() works in my case.

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.
Explore my blog James Yumnam

Was this reply helpful? Yes No
v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @nicklimcs ,

It's wired, your original formula should be work. Are there other formulas on the TextInput?

Maybe you can try this first.

Sum(AddColumns(galTasks.AllItems,"Input",numInputPartner.Value),Input)

Best regards,

Rimmon

Was this reply helpful? Yes No
WarrenBelz 155,399 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@JamesYumnam ,

Please tag me if you want further assistance - the Classic Text Input certainly should work.

Was this reply helpful? Yes No
Verified answer

nicklimcs 77 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz @v-mengmli-msft

So it turns out that it won't sum properly if the text input control is within a Container sitting in a Gallery.

In another post, they suggested to create a txt label directly in the Gallery and reference to the txt input within the Container. Then sum the txt label to get the result which is working for me.

Is this a bug or is there another way to change the formula for it to work?

Was this reply helpful? Yes No
Verified answer

WarrenBelz 155,399 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@nicklimcs ,
As long as both the gallery and your sum label are in the same container, it should work.

Was this reply helpful? Yes No