Answered

make calculating label static !

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a label that calculates a total :

Text(Sum(LblCurrentValue.Text)-Sum(GalleryNewOrders.AllItems,TxtOrderValueNew.Text),"[$-en-US]€ #,##")

works great and calculates correctly. However when I have finished entering date I want the final calculation to be patched back to a sharepoint list.

My patch command works fine but it patches back the value from the first part of the sum (lblCurrentValue.text) which is a static field (and which is the same figure before any calculations are done) in other words it doesn't take the final calculated figure?

I've tried adding another label and using its default as the calculatinglabel.text and patching that back but that doesn't work either still it takes the old figure..

How Can I take my final calculated figure and make it static so that it will patch back correctly?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

iAm_ManCat 18,256 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi - have you tried patching that directly? In your patch formula, use that formula for that column instead of referencing the label text?

Could you please provide the code you are currently using for your patch - that will help diagnose,

Thanks,

Sancho

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Thanks @iAm_ManCat I thought of that but don't really want to do that because it's too much overhead in the patch and there is a lot of other stuff going in in the select of the button besides that patch ! The patch itself is easy and as I said works fine with static info such as below 123 it even works if I point it to the value of the label but as I mentioned it takes the current value of the label (before calculation)
Patch( Live, LookUp( Live, LiveStatus = true ), {RemainingOnPO: 123}

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

I got it. I set the on change function of the field that is calculating to a variable, I tried using the variable in the patch that was the same so then I just threw in another label and put the variable as it's default and then referecned that label in the patch ! Just in case anyone else having same issues 🙂

Was this reply helpful? Yes No
iAm_ManCat 18,256 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Thanks for coming back and sharing the answer once you found it!

Was this reply helpful? Yes No