Skip to main content
Community site session details

Community site session details

Session Id : hx14HuT+ltDW+U7ATQKSQj
Power Apps - Building Power Apps
Unanswered

Text and Language Function behaving incorrectly

Like (0) ShareShare
ReportReport
Posted on 26 Mar 2020 04:13:37 by 315

Hi,

 

I have a canvas app which uses Value and Text function for calculations for most of the fields across the app. It´s working fine when i share the app with users in USA. I shared the app to few users in Brazil and Spain and the calculation started behaving incorrectly and i can see Decimal values(.) instead of commas(,) in all the calculated values. Is there any way to mitigate the issue or to make the app to force use language set during development(en-US).

 

Appreciate the help.

  • v-yutliu-msft Profile Picture
    on 27 Mar 2020 at 02:51:39
    Re: Text and Language Function behaving incorrectly

    Hi @kbilakanti ,

    Do you mean that the if you set one user's powerapps studio , it will affect all the other users' language?

    I'm afraid it will not.

    Current user's powerapps studio settings will only affect current user's language.

    End users need to set this on their own.

    If end users could edit the app, you just need to ask them log in powerapps studio to change the settings that I mentioned.

    If end users could only run the app, maybe he needs to change his browser's language.

     

    Best regards,

  • kbilakanti Profile Picture
    315 on 26 Mar 2020 at 09:04:14
    Re: Text and Language Function behaving incorrectly
    Will that work for end users, who are trying to access the app in browsers as well. I have users in Spain and Brazil, so if I set the language and region to English and United states, will that effect to users who are in Brazil and Spain to use the same Engish language and region as United States?
  • v-yutliu-msft Profile Picture
    on 26 Mar 2020 at 08:54:52
    Re: Text and Language Function behaving incorrectly

    Hi @kbilakanti ,

    Do you want to avoid the language changing with location?

    You could set the language and location in powerapps studio.

    32600.PNG

     

    Please change the language to English, location to United States.

    326001.PNG

     

    326002.PNG

     

    Then the language will not change with location.

     

     

     

    Best regards,

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 1

Loading complete