Skip to main content

Notifications

Community site session details

Community site session details

Session Id : 15MlVKE6HAI6C/EEqGmjCS
Power Apps - Building Power Apps
Answered

PowerApps Currency format issue

Like (0) ShareShare
ReportReport
Posted on 11 Aug 2023 10:02:56 by 89

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

Champ14_2-1691748100788.png

 



But this is what was shown when users in Switzerland enters any value,

Champ14_0-1691747976622.png


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

Champ14_1-1691748071808.png

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.

  • Verified answer
    Champ14 Profile Picture
    89 on 16 Aug 2023 at 02:27:06
    Re: PowerApps Currency format issue

    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!

  • SebS Profile Picture
    4,146 Super User 2025 Season 1 on 15 Aug 2023 at 10:21:26
    Re: PowerApps Currency format issue

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

     

     

  • Champ14 Profile Picture
    89 on 15 Aug 2023 at 10:18:47
    Re: PowerApps Currency format issue

    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 Profile Picture
    4,146 Super User 2025 Season 1 on 15 Aug 2023 at 09:19:49
    Re: PowerApps Currency format issue

    @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 Profile Picture
    89 on 15 Aug 2023 at 06:26:55
    Re: PowerApps Currency format issue

    Hi @SebS ,
    Thanks, tried that it also doesnt work. The end-users have the same result as below

    Champ14_0-1692080808108.png

     





  • SebS Profile Picture
    4,146 Super User 2025 Season 1 on 11 Aug 2023 at 12:14:38
    Re: PowerApps Currency format issue

    @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"))

     

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Building Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 42 Most Valuable Professional

#2
mmbr1606 Profile Picture

mmbr1606 41 Super User 2025 Season 1

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 36

Overall leaderboard