Answered

Updating Number formatted field

(0) Share

Report

Posted on by vffdd

1,257 Super User 2024 Season 1

I have a text field on form that is formatted for currency using the variable method. i.e on change function for the field is

Set(VarNumberFormat,Text(Value(DCVAmountRequired.Text),"€#,##0.00"))

and the default value for the field is VarNumberFormat so that all works well and I have a lovely currency field !

Howvever..

When I submit the form it's not updating the sharepoint list.

I've tried the update function for the data card to be the following

Value(DCVamountRequired.Text)

VarNumberFormat

and various versions of the above ! I've also tried adding in label to pick up the value and using that for the update but nothing I do gets the field to update on the shareoint list..

any suggestions?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@vffdd

It is the euro symbol in your text that is causing the issue.

You need to apply a language tag to you Value function to convert properly.

ex: Value(DCVamountRequired.Text, "nl-NL")

Not sure of your region, but just replace with the appropriate language code.

I hope this is helpful for you.

Was this reply helpful? Yes No
Verified answer

timl 36,780 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi @vffdd

You could also try stripping the Euro symbol in your call to Update

Value( Substitute(DCVamountRequired.Text,"€","") )

Was this reply helpful? Yes No
vffdd 1,257 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Thanks @timl that did the trick 🙂

Was this reply helpful? Yes No