So far I feel that currency formatting in PowerApps seems to be a little troublesome. Sure everything would be great if we all sold in $ and our offers were all huge! All of the examples out there are based on this. I needed to represent values at 1 NOK and up. In Norway we don’t use “,” for separating thousands.
I am sure there are simpler ways of doing this, and I am hoping someone can fill me inn:)
For US formatting I found this one:
Text(CurrencyField,"[$-en-US]$###,###")
For UK formatting I found this one:
Text(Value(Parent.Default),"[$-en-US]£#,###.00")
For me I need to format PowerApps currency NOK. I have tried manipulating all of the above with no luck at all. Have no idea what I am doing wrong, but that doesn’t matter. I finally found one that worked for me
NOK PowerApps Currency Formatting:
Text(ThisItem.'Est. Revenue',"[$-nb-NO]## ### kr", "nb-NO")

None of this is really making much sense to me. If you have more information about this, please do share!!:)
I get the same kind of issue here when I’m setup in a French-Canadian environment!
For example if I write the following:
Text(ThisItem.Price;”[$-en-US]$##,###.00″)
I get this: €1 699,99 (notice the space instead of comma and comma instead of period in the decimals)
Sorry guys! not cuz I speak French that I deal in Euros!!
So I have to “repeat” myself and force it to US type of format like this:
Text(ThisItem.Price;”[$-en-US]$##,###.00″;”en-US”)
to get what I wanted as: $1,699.99
LikeLike
Haha. That is amazing🤣🤣
LikeLike