Answered

Format Floating Point Number as Currency

(0) Share

Report

Posted on by iwonder

1,142

Thank you for taking the time to read my question.

I really don't know why this is not working, any help is greatly appreciated.

Text(Parent.Default,"[$-en-US] ###,##0.00") gives me 1.00

Text(Parent.Default,"###,##0.00","$-en-US") is incorrect

Text(Parent.Default,"$###,##0.00","en-US") gives me nothing

Text(Parent.Default,"$###,##0.00") gives me the Pound symbol instead of the dollar sign.

thoughts?

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

TheRobRush 11,128 Moderator on at

Like (0)

Report
Copy link

Link copied!
I changed my text input to number only and altered my two label formulas to work with a number only textbox instead, both worked, here is code I placed in the labels.

Text(RoundUp(TextInput3,2),"$###,##0.00","en-US")

or

Concatenate("$",Text(RoundUp(TextInput3,2),"###,##0.00","en-US"))

you could then put a label next to the text input with a value of "$" and have its visibility set to

IsBlank(TextInput3)=false

which will make a dollar sign show up next to your number input area when they have typed in it.

Was this reply helpful? Yes No
Verified answer

iwonder 1,142 on at

Like (0)

Report
Copy link

Link copied!

Hi @TheRobRush

...ok... I feel ashamed....

Text(Parent.Default,"$###,##0.00","en-US") works. I had my Text Input format = Number instead of Text.

I did that so that users could not enter text into this field...

So a bit of a conundrum.... do I not show the currency symbol and risk users entering text or change the Text Input format to Number and not show the currency symbol.

It's a shame we have to choose.

Thanks very much for your help!

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like (0)

Report
Copy link

Link copied!
thats odd, worked for me, but you could always try leaving the $ out and try it like

Concatenate("$",Text(Round(Value(Parent.Default),2),"###,##0.00","en-US"))

Was this reply helpful? Yes No
iwonder 1,142 on at

Like (0)

Report
Copy link

Link copied!

Hi @TheRobRush
Thank you very much for your reply.

I have: Text(Round(Value(Parent.Default),2),"$###,##0.00","en-US") now and my TextInput in my data card is blank

If I take out the "$" then I get my value back (the cost for this test record is 0.00).

IsNumeric(Parent.Default) returns true

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like (0)

Report
Copy link

Link copied!
I have it working on my end using the following

Text(RoundUp(Value(TextInput3.Text),2),"$###,##0.00","en-US")

Added in the roundup(value( to be sure whatever it is converting is being seen by it as a number.

Hope that helps, hard for me to give an exact solution without seeing the source in your parent.default

Was this reply helpful? Yes No