Summing Values in a Gallery with New (Responsive) Modern Text

(0) Share

Report

Posted on by NPrice99

1,302

I am having problems with New Modern Text input values in a Gallery.

The sequence is as follows :-

Read items from a Table in CDS into a Gallery.

Sum items from a column in the Gallery. Get answer. Sum(galleryRows.AllItems,Value(TextColumn.Value))

Amend an item from the above column in the Gallery.

Press button to Sum up the (changed) column in the Gallery. Sum(galleryRows.AllItems,Value(TextColumn.Value))

But although the value in a column has changed, the Sum stays the same !

All I am trying to do is emulate SUM(.....) in Excel.

What am I missing ?

Thanks

Nigel

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (2)

JayMagness 1,663 on at

Like (0)

Report
Copy link

Link copied!

HI,
try putting a Refresh( Dataset); Refresh(Gallery) before the text you have

Was this reply helpful? Yes No
Verified answer

developerAJ 4,763 on at

Like (1)

Report
Copy link

Link copied!

Amend an item from the above column in the Gallery. if you are updating the datasource with changes than Refresh( Dataset) when you update item.

if you are not updating the datasource just making changes locally in powerapp. Than change your formula.
Sum(galleryRows.AllItems,Value(TextColumn.Value)) . instead of Value(TextColumn.Value) give the control name where your value change is reflected Sum(galleryRows.AllItems,Value(textcontrol.text))

Was this reply helpful? Yes No
NPrice99 1,302 on at

Like (0)

Report
Copy link

Link copied!

Hi @developerAJ

So moving on (Apologies to Matthew Devaney) I have now introduced containers and the modern TextInput controls:-

I now want to Sum the Quantity column again. But Sum(gal_EditableTable.AllItems,TextInputQuantity.Value) gives me 156 (first value * number of Rows).

So how do I now SumUp the values in the column "Quality" with the Responsive Container between gal_EditableTable and the Text values in the Row ?

Thanks

Nigel

Was this reply helpful? Yes No
Verified answer

developerAJ 4,763 on at

Like (1)

Report
Copy link

Link copied!

if you use container, you won't be able to get it.
gallery will get only top-level control because you are storing the text control inside container it will not able to detect.

workaround add a label outside container in gallery .Text : urmoderntext. you can hide this label.
for sum use this label

Was this reply helpful? Yes No
NPrice99 1,302 on at

Like (0)

Report
Copy link

Link copied!

Thanks @developerAJ That was the conclusion I came to as well. Thanks for confirming my fears.

Was this reply helpful? Yes No