'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Power Apps Number Conversion Error with Colombian Regional Settings
Question details
The user experiences formula failures in Power Apps when converting numerical data entered using Colombian regional formats.
- Product
- Microsoft Power Apps
- Device & OS
- not provided
- Scenario
- Entering numerical data into a Power Apps application using Colombian regional settings.
- Observed behavior
- Formulas expecting an en-US number format fail or return incorrect values because the Colombian locale uses different decimal and thousands separators.
Identify the exact Power Apps formula causing the error and take note of the specific input string that is failing to convert.
Use Explicit Locale Parameters in Power Apps Formulas
Specify the expected language and regional format directly within your Power Apps formula to bypass system default mismatches.
Power Apps often defaults to en-US for number parsing unless explicitly configured otherwise. By declaring the locale within your conversion functions, you ensure that Colombian formats (which use commas for decimals and periods for thousands) are correctly understood, regardless of the underlying operating system settings.
Open your Power Apps editor and find the text-to-number conversion formula that is causing the error, typically utilizing the Value() function.
Modify the formula to include the Colombian language tag. For example, change Value(TextInput1.Text) to Value(TextInput1.Text, "es-CO").
Run the application and input a number using the Colombian format (e.g., 1.234,56) to verify that the conversion error is resolved.
Manage Your Data Easily with WPS Office
If you are dealing with complex data management and regional formatting issues, WPS Office offers a highly compatible and user-friendly spreadsheet environment. It perfectly supports global regional settings without the hassle of coding custom app formulas.
- 1. Download WPS Office: Visit the official WPS Office website and download the free installation package for your device.
- 2. Install and Launch: Run the installer, open WPS Spreadsheets, and create or open your existing data files.
- 3. Adjust Regional Formats: Navigate to the cell formatting options to easily set your preferred decimal and thousands separators for your specific region.
Frequently Asked Questions
Why do Colombian number formats cause errors in Power Apps?
Colombia uses a comma as a decimal separator and a period for thousands, whereas the default en-US format uses the exact opposite. If a formula strictly expects en-US, it will fail to parse Colombian numerical inputs.
Can I change the regional settings for my Microsoft account to fix this?
Relying solely on Windows or Microsoft account regional settings is often insufficient for Power Apps. It is highly recommended to use Power Apps-specific locale handling directly within your app formulas.
What is the correct locale tag for Colombia in Power Apps?
The standard language and region tag for Colombia used in Power Apps formatting and conversion functions is "es-CO".
