Number Formatting -- Dollar signs, commas and decimal points

[JC-8]

I am using PowerApps to create the form for a SharePoint list. I have 2 columns that are fomatted as currency in the original list, with a 3rd that's a calculation of the difference. I've seen solutions for text fields used for numbers wherein they use a formula to change the field to start with a dollar sign and end with .00. This won't work for me. Is this being added to PowerApps soon?

This is for a new list; however, I have a number of SP lists in InfoPath that we want to convert to PowerApps and we must have that functionality in order to do that.

[v-yuxima-msft · Accepted solution]

Hi @JC-8 

Could you please try this formula expression?

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

More information:

function-text

Best Regards.

Yumia

[JC-8]

I'm really new to PowerApps -- can you tell me where that formula goes?

[K-A-R-L · Accepted solution]

Hi @JC-8 ,

Have you tried testng @v-yuxima-msft  solution?

On PowerApps are you using a Gallery to display the SharePoint list or a Form?

If you're using a Gallery:
For 2nd Column Just add TextInput or Label and change the Text() Property to: (for first Column)

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

For 2nd Column add another TextInput or Label and change the Text() Property to :(for second Column)

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

If you're using Form:

Find the DataCard InputBox and change the Text() Property to:

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

----------------------------------------------------------------------------
Thanks,
K-A-R-L

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If you thought this post was helpful, please give it a Thumbs Up.