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
@nicklimcs ,
As long as both the gallery and your sum label are in the same container, it should work.
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?
Please tag me if you want further assistance - the Classic Text Input certainly should work.
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
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
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.
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
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