Answered

How do I 'unformat' the value in a text field before it is written to a Dataverse table?

(0) Share

Report

Posted on by futr_vision

831 Moderator

I figured out how to take an integer that is entered into a text field and reformat it and write it back to the text field as a currency value by doing the following:

On OnChange property of the text field

UpdateContext({varCurrency: Text(Value(TXT_Budget.Text), "[$-en-US]$#,##0.00")})

Then I set Default to:

varCurrency

Works great.

The problem is when I go to write this to the Dataverse table on form submission it gets written with the dollar sign, commas and periods. How can I covert this back to an integer before writing to the table?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report
Hi @futr_vision ,

Try this

Value(Substitute(YourTextInput.Text,"$",""))

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
futr_vision 831 Moderator on at

Like (0)

Report

Where would I use this formula and will it handle the comma and decimal? It looks like it might only be addressing the "$". Actually, maybe the comma and decimal don't matter.

Was this reply helpful? Yes No
WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report

@futr_vision ,

Correct - the Value() function converts the comma and decimal correctly. You would use it probably on the Update of the Data Card.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No