Currency showing as £ instead of $ ?

(0) Share

Report

Posted on by Daved1

166

In a label Text property i use:

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

yet the label displays

£12,000.00

This is painful

Dave

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@Daved1

Something in your computer/device is giving the wrong region.

Change your label Text property to :

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

This specifies the region language to use.

I hope this is helpful for you.

Was this reply helpful? Yes No
Daved1 166 on at

Like (1)

Report

@RandyHayes
Thank You !!

Although it appears that Power Apps thinks I am in UK. I will see if i can figure out why...

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (1)

Report

@Daved1

Yes, check the region settings in your computer and browser as that is where PowerApps gets its region info from.

You can see directly what it thinks in PowerApps with a label that has a Text property of : Language()

It will then tell you what it has determined.

Was this reply helpful? Yes No
Daved1 166 on at

Like (2)

Report

Thanks again. I had english (UK) above english Canada in browser settings (language) which is why PowerApps thought I was in UK. I changed the order, now i get $12,000 when i use Text(12000,"[$-en-US]$#,###.00")

This makes me think that this is not a good "feature" that PowerApps uses the Browser language selection to determine which region you are in. If I have a colleague that is set up with English UK as his primary language browser, then my Power App will show £12,000.00, which will be completely incorrect, as this is not even a converted currency. Also, if someone is in the UK they may want to display $.
I guess i am not understanding why anyone would want Text(12000,"[$-en-US]$#,###.00") to display in different currencies, depending on your language selected, since the currency is not even converted, so will display misleading information.

I will be sure to always use the full format that you provided.
Text(12000,"[$-en-US]$#,###.00", "en-US")

Regards
Dave

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@Daved1

Yes, this is a downfall when it comes to currency as it will format in another currency, but not convert to actual values (can't even imagine it having that kind of logic to find current exchange rates and such).

This is something to keep in mind for using the Text function for currency. Always use the Language tag for the currency you want. That way if a user in another country sees the amount - it will be in US dollars.

To really do the conversion, you would need to look at the language of the current user and then have some logic to convert based on exchange rate...that would be a tall order!

Was this reply helpful? Yes No
steveleroux 2 on at

Like (0)

Report

Hi All

I had the same issue. I checked all pc settings, share point, power app settings and they were correct.
I then discovered my browser was being proper and using the Queens English.
Annoying but I'm glad its resolved.

Steve

Was this reply helpful? Yes No