Answered

cant add totals from a gallery to a text label outside the gallery

(0) Share

Report

Posted on by scottmcnitt

241

I have a gallery that each row calculates a total amount. underneath the gallery i have a label that sums the total of all the total amounts in the gallery using allitems but it is not displaying on my end result label.

Trying to have the results in the Net Amount: "$"& Text(Sum(galEditRequestItems.AllItems, lblCPREditItemAmount), "[$-en-US]#,##0.00")

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

scottmcnitt 241 on at

Like (0)

Report
Copy link

Link copied!

I figured out my issue. I made a new text label inside the non nested gallery and it just worked as originally entered. It does not work outside of the gallery.

Was this reply helpful? Yes No
scottmcnitt 241 on at

Like (0)

Report
Copy link

Link copied!

I tried it and still only shows $

Was this reply helpful? Yes No
scottmcnitt 241 on at

Like (0)

Report
Copy link

Link copied!

I tried all 3 of those and no luck

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on at

Like (0)

Report
Copy link

Link copied!
Hi @scottmcnitt,

I think you should refer to the lblCPREditItemAmount.Text, modify your formula as below:

"$"& Text(Sum(galEditRequestItems.AllItems, lblCPREditItemAmount.Text), "[$-en-US]#,##0.00")

You could find that I refer to Title39.Text from my Gallery29.

Was this reply helpful? Yes No
MarcelLehmann 378 on at

Like (0)

Report
Copy link

Link copied!

Try (I don't know which kind of text label this is):

Value(lblCPREditItemAmount)
Or
Value(lblCPREditItemAmount.text)
Or
Value(lblCPREditItemAmount.value)

Was this reply helpful? Yes No