Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Lisa White]

I have a Power App form. Data source is a SharePoint list, with a column in the list named DollarValue. In the form, the user must enter a number representing currency (US).

After searching and then watching one of Shane Young’s videos, I came up with this:

Text(Value(Parent.Default),”[$-en-US]$ #,##0.00″)

This is in BOTH Data > Default and Design > Format.

When a new form opens, the field is correctly formatted:

However, as soon as I enter numbers and move off the field, the currency format is gone:

I’m guessing this has something to do with the Text function converting number to text. But how do I get it back as a formatted number?

Thanks.

——————————
Lisa White
Senior IT Specialist
Herndon VA
703-709-7172
——————————

[Mustafa Hussain Mohsin]

Hi

I have made a test on my side, please take a try with the following steps:

• Unlock the DataCard where you want to format the field to currency.
• Within the DataCard, select the TextInput control.
• Within right panel, set Default property to following formula:

  Text(Parent.Default,"[$-en-US]$#,###.00")?

or

Text(Parent.Default,"[$-en-US]$#.00")

Image Reference

——————————
Mustafa Hussain Mohsin
Associate Data Analyst
——————————
——————————————-

[Lisa White]

Thanks, . This worked great on the form when it’s in Edit mode. For some reason, it doesn’t work when the form is in New mode, using the same code in the DataCardValue on the form.

What am I missing?
?

——————————
Lisa White
Senior IT Specialist
Herndon VA
703-709-7172
——————————
——————————————-

[Mustafa Hussain Mohsin]

Hi

I am glad that it worked for you. However??, PowerApps currently doesn’t have that functionality, But if you still want to have that kind of thing there is a workaround you have to include a text control for showing the Dollar Sign ($) in the dollar filed text control.

If you want to test that, I can tell you about that. But as far as I understand showing Dollar sign is not necessary in the Input form for the New Form as you have already mentioned above Enter Dollar value and when you save it will show you the amount with Dollar sign.

Hope it helps

——————————
Mustafa Hussain Mohsin
Associate Data Analyst
——————————
——————————————-