You’re offline. This is a read only version of the page.
170
I have and issue with number formatting for different users,
Some users see ###,###.##
Some users see ### ###,##
How to manage this?
I try to change users language setting but it didn't work,
Is it Possible to use one type of formatting for all users?
Hi @shnurich ,
Use Context Variables: Set a global formatting pattern at the app's start (e.g.,
Share
Report
All responses (
Answers (
Set(globalNumberFormat, "###,###.##"))and use this variable to format numbers in your controls.
Create Collections: At the app's onset, create a collection to store formatting preferences (e.g.,
Collect(numberFormat, {format: "###,###.##"})) and reference it in controls for consistent formatting.
Leverage Power Automate: Format data using Power Automate before it reaches Power Apps, ensuring uniformity especially with external data.
Scripting: For complex scenarios, use Power Apps’ scripting capabilities for custom formatting
If this solution resolves your issue, please consider marking it as accepted. ✅
Warm regards,
Muhammad Ali
I found out that the language of the browser (chrome) affects the formatting of numbers.
Hello, what centralized formatting settings in Power Apps may I use?
All of this topics nice but do you have some examples?
Hi @shnurich ,
To enforce consistent number formatting across all users in Power Apps, you can use the Text function to specify the desired format. Set the Text function on the Text property of the control displaying the number:
Text(yourNumber, "###,###.00")
This will format the number with a comma as the thousands separator and a period as the decimal separator, regardless of the user's locale settings.
If you need to handle other locales that use spaces or different separators, you would replace the format string accordingly. For example:
Text(yourNumber, "###'###.00", "fr-FR")
This will use the French locale, which typically uses space as a thousands separator and a comma for the decimal point.
Remember to replace yourNumber with your actual data source field or value.
Best Regards,
Hassan Raza
Hi @shnurich ,
To manage number formatting consistently for all users in Power Apps, try these steps:
Centralize Settings: Use centralized formatting settings in Power Apps to enforce a uniform number format across all users.
User Profile Configuration: Ensure all user profiles are set to the same language and regional settings.
Application-Level Settings: Check if Power Apps allows you to set number formatting at the application level, overriding individual user settings.
Scripting Solution: If available, use a scripting solution within Power Apps to format numbers consistently.
Note: The effectiveness of these solutions depends on the specific capabilities of Power Apps. If these steps don't work, consider reaching out to Power Apps support for more tailored advice.
If this solution resolves your issue, please consider marking it as accepted. ✅
Warm regards,
Muhammad Ali
#1
WarrenBelz
146,651
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,997
Most Valuable Professional
