cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vffdd
Responsive Resident
Responsive Resident

Updating Number formatted field

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?  

1 ACCEPTED SOLUTION

Accepted Solutions
timl
Super User
Super User

Hi @vffdd 

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

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

 

 

View solution in original post

3 REPLIES 3
RandyHayes
Super User
Super User

@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.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!
timl
Super User
Super User

Hi @vffdd 

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

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

 

 

vffdd
Responsive Resident
Responsive Resident

Thanks @timl  that did the trick 🙂

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PWREduCon768x460.png

Join us at PWR EduCon - A Power Platform Conference

Learn from the top Power BI, Power Apps, Power Automate & Power Virtual Agents experts!

Top Solution Authors
Top Kudoed Authors
Users online (2,413)