You’re offline. This is a read only version of the page.
In a label Text property i use:
Text(12000,"[$-en-US]$#,###.00")
yet the label displays
£12,000.00
?
This is painful
Dave
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
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!
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
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.
Thank You !!
Although it appears that Power Apps thinks I am in UK. I will see if i can figure out why...
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.
#1
WarrenBelz
146,660
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,004
Most Valuable Professional
Share
Report
All responses (
Answers (