PowerApps Currency Formatting examples

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!!:)

3 thoughts on “PowerApps Currency Formatting examples

  1. 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

    Like

Leave a Reply to Thomas Sandsør Cancel reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s