Error with using comas instead of points in numbers with powerapps in spanish android

[juanbizzz]

I dont know if anyone resolve this issue.  I have an application that have some textbox to write numbers.  My primary language is Spanish Latam, use point for separate decimals (for example 1,200.34) .  everything works well but when i deploy in android or iOS change the puntuactions and only accept when i write the number like 1.200,34.  This is the Europe notation.  Already view the language in severals mobiles and always the only way to works fine is change the mobile language to US English.  

Anyone know how to fix this? its a big problem for deploy apps in Spanish Latam because change the decimal separators to coma (,) instead of using point (.)

Thanks for any comments or information

Juan Alvarado

[AndyPennell]

You can display your numbers exactly as you wish using the third argument of the Text function: setting that to "en-us" will get the value is displayed in your desired format.

If you do not specify a language then the locale of the device will be used. It soundslike the locale of your devices is different to the locale of your PC.

You can always tell the default locale that a Power runs in using the Language() function.

[juanbizzz]

The problem is that in android the only options that have is Spanish (Spain) and Spanish (US) but both return the locale es-es, that give the problem.  But i dont know if PowerApps have any function or setting to running the app under a specify locale or languaje no matter what the OS said.

If i change the android to English US , works well but we can't change the language of mobiles of all employees of the corporation.

Thanks for any information about it

[AndyPennell]

Ah I see. Currently PA does not have the ability to "force" an app to run in a specific locale, so changing the formula where numbers are displayed, per my previous reply, is the best that can be done right now.

[juanbizzz]

but the main issue is when the user input the number and apply the submitform function, dont save well the number.  For example if the user input 1234.12 , save in the CDS entity the number 123412 and this is unnaceptable for the app.  Any functions or idea how we can resolve this issue? .. if the user input the number 1234,12 works well, but in latam we dont use , as a decimal separator we use . 

[Marek]

hi juanbizzz

sorry I have similiar issue that formatting is not currently support for all languages

so if you cant change device, either powerapps we could use function and customize powerapp:

Like when value is 123.456 (123 (decimal) 456)

1.

Text(123,456;"[$-en]")&"."&Text(Mod(123,456;1)*1000;"[$-en]")

Show just all (left nondecimal) numbers.....

then use concatenate on string (&)

Like Mod(Number;1) .. return all 0.456  just modulo

This is for singleValue for me.

2.If in "table" view or something, powerapps has capabilty of "calculated column" https://powerapps.microsoft.com/en-us/tutorials/function-table-shaping/

and show in datatable (or gallery or ... dunno) not original Number column but insted this "new formated column"

3x even further ... if there is realy multilanguages users, i see options in like If(Language() or Language().Code? sorry cant remember ... Screen1, its property OnStart/OnVisible it can use Navigate function

(for me ask customers/consultants .. more easy is to force all users to "custom formating" ... if customers want multilanguage, so do some "If" function stuff

[juanbizzz]

wow, good workaround .. i will going to try it in the app.  Powerapp need to support some way to force some force to use one language if is necesary.  I saw that android have bad behaviors with locales and spanish language but in the case of powerapps this difficult the implementation in our region.

Thanks for the idea , i will try it.

[Marek · Accepted solution]

oka 🙂

hm maybe just generated app cannot handle it yet

just parse data from textbox somehow and send it to datasource manualy using

Patch function in powerapps can send data to datasource like Patch(Entity1;{NumberColumn:TextInput1.Text})

https://powerapps.microsoft.com/en-us/tutorials/function-patch/

and on that button , like Button1 and set its propety OnSelect ... and there put some functions (note: in function box, right is "arrow down" icon for more display more rows .. and via "SHIFT+ENTER" you can put multiple row into 1 call and call multi functions (for my language "operator" is ;; .... like Set(Variable1;123);;Set(Variable2;456)

Value function enable parse from Text to number https://powerapps.microsoft.com/en-us/tutorials/function-value/

Left / Right function enable substrings https://powerapps.microsoft.com/en-us/tutorials/function-left-mid-right/

If switch enables to branches by user language https://powerapps.microsoft.com/en-us/tutorials/function-value/

But just a scratch prototype (just logic no syntax in powerapps)

1. detect language via if/switch languages

2. do parse and set number variable value left right ... (and some function for searching character, in other programming languages like index, find ... and + .. or *.... like VariableThounsands*1000+VariableInteger

3. set whole record to datasource via patch

for me it is very good to ask customer / inform about technical possiblities (because customer is not selected from what is want .. but what is currently available and what his resources and priorities are ... often in programmin and customization customer has multiple usage of technical same thing (just to defend you, if you learn and prototype this functionality by a lot of time ..  it has high probability customer has MULTIPLE usage of this language/formatting  viewing / adding data)