User number formatting for all users

(0) Share

Report

Posted on by CU09100753-0

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?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

M_Ali_SZ365 1,110 on at

Like (0)

Report
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

Was this reply helpful? Yes No
Hassan_SZ_365 542 on at

Like (0)

Report
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

Was this reply helpful? Yes No
CU09100753-0 170 on at

Like (0)

Report

Hello, what centralized formatting settings in Power Apps may I use?

All of this topics nice but do you have some examples?

Was this reply helpful? Yes No
CU09100753-0 170 on at

Like (0)

Report

I found out that the language of the browser (chrome) affects the formatting of numbers.

Was this reply helpful? Yes No
M_Ali_SZ365 1,110 on at

Like (1)

Report
Hi @shnurich ,
Use Context Variables: Set a global formatting pattern at the app's start (e.g.,
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

Was this reply helpful? Yes No