Hi,
Would like to seek you expertise as I have issues on currency formatting. I develop a Payment App, it works perfectly fine in Asia but has issues with our users in Switzerland.
When users in asia type in any amount, it reflects as
But this is what was shown when users in Switzerland enters any value,
I would like to retain the formatting as 20,000.00 instead of 20 000,00.
For that Text Input field, this is the formula I set
Appreciate any assistance! Thank you!
----UPDATE----
I am not sure why, I tried to force format the Text Input to use
Text(Value(TextInput1.Text),"#,###.00")
it works well when users are in Asia but still converted to Switzerland currency format once the app was run from any users in our Switzerland Office.
Thanks Sab!
Manage to find the issue, it seems this issue is from Chrome, I tried to use Edge and it is working fine. Seems Chrome pushed the local settings and PowerApps cannot overide it no matter what.
Advised the users to use Edge for the time being, while checking possible solution for Chrome.
Thank you!
Sorry to hear that, I hope someone with more experience around multi region will join and provide some more advice as I'm run out of ideas what may be the cause of this.
Hi @SebS ,
Thanks so much for your time, but it also does not work, I also tried to change the code to
Set( varCurrency2, Text( RoundUp(Value(AmountSet_1.Text), 2), If( AppLanguage = "en-US", "#,###.00", "[$-de-CH]#,###.00" ) ) )
as I am having issues with Application.Language, also it says de-CH language not supported
Long shot but have a look if this will work:
Set(
varCurrency2,
Text(
RoundUp(Value(AmountSet_1.Text), 2),
If(
Application.Language = "en-US",
"#,#0.00",
"[$-de-CH]#,###.00"
)
)
)
It's hard for me to check if this will work as I do not have a way to check who it will show in other regions.
droop region format and use this "#,#0.00" should be more consistent but I can't check it out if it work for sure
Set(varCurrency2, Text(RoundUp(Value(AmountSet_1.Text), 2), "#,#0.00"))
WarrenBelz
42
Most Valuable Professional
mmbr1606
41
Super User 2025 Season 1
MS.Ragavendar
36