Answered

PowerApps Currency format issue

(0) Share

Report

Posted on by Champ14

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.

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

SebS 4,867 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
@Champ14

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"))
Champ14 89 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @SebS ,
Thanks, tried that it also doesnt work. The end-users have the same result as below
SebS 4,867 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
@Champ14

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" ) ) )
Champ14 89 on at

Like
a
(0)

Report
Copy link

Link copied!

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
SebS 4,867 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

@Champ14

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.
Verified answer

Champ14 89 on at

Like
a
(1)

Report
Copy link

Link copied!

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!