decimal seperator change from NL (,) to EN (.)

[wilberttouw]

Hi,

hopefully someone can help me out:

In powerapps i made a form conneted to a CDS entity

In the CDS entity i made aquantity field (decimal number). I see from the data it shows 2.00 (decimal seperator is .)

If i show the language in my app it shows nl-NL

if fill the quantity field with 1,5 (i have to use the , a . is not allowed).

in the CDS entity it shows 15

probably this is caused by the decimal seperator in NL it is , but in US it is .

I tried to maipulate it with the functions Value and Text, on different properties (datafield, default,update) on the field. but so far no result:

default:

ThisItem.crfb3_quantity
//Value(ThisItem.crfb3_quantity;"en-US)")

[v-xida-msft]

Hi @wilberttouw,

I think your thought is correct. The Decimal separator character is dependent on language. some regions of the world use "." as a decimal separator while others use ",".

More details about the Decimal separator in PowerApps, please check the following article:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/operators

I have made a test on my side, please take a try to modify your formula as below:

Text(ThisItem.crfb3_quantity,"[$-en-US]#.0","en-US")

Then check if the issue is solved.

More details about the Text function in PowerApps, please check the following article:

Text function

Best regards,

Kris

[wilberttouw]

Hi @v-xida-msft Kris

DataCardValue6.Text = 1,23

I tried it in a seprate label. When i fill the Text Property with:

Text( DataCardValue6.Text; "[$-nl-NL]#.#,###"; "en-US" ) => 1,23  =>wrong

Text( Value(DataCardValue6.Text); "[$-nl-NL]#.#,###"; "en-US" ) => 1.23  => right

Now i tried to make this work in the form (connection is CDS Table, see the attached picture) where i fill the quantity (DataCardValue6.Text). I tried the property update (default is Value(DataCardValue6.Text)).

i tried Text(Value(DataCardValue6.Text); "[$-nl-NL]#,#"; "en-US") => CDS show 123

i tried Value(Text(Value(DataCardValue6.Text); "[$-nl-NL]#,#"; "en-US")) => CDS show 123

Is the syntax wrong, or should i put it in a different trigger (default, )?

When i put chrome in english, if can fill 1.23 in the quantity field and i see 1.23 in the CDS table, without modifing the Update trigger

[CarlosFigueira]

This seems to be a bug in the CDS / CRM connectors that is ignoring the decimal separator in numeric input for languages where the separator is the ','. This should be fixed by next week, I'll update this thread with more information.

[arwuntak]

Hello Carlos,

Is there any update on this? 

Thanks,

Archana

[CarlosFigueira]

Hi Archana, sorry for the delayed response, I was out without Internet for a week. I just tried with the latest bits, and it seems to be fixed now. Please let us know if this is not the case.

[wilberttouw · Accepted solution]

Hi Carlos,

i checked my solution and now it works.

Thank You

[KayFax]

Hello @CarlosFigueira 

I found this thread to be solved, but I got the exact same problem in PowerApps still when working with Sharepoint Lists as data behind it. Ironically, it does work when opened on any browser, but not when added as an app to Teams, or as an App on a Sharepoint Site.

I posted that problem already a while ago, but no response yet.

Could someone at Microsoft please look into this, because it is very puzzling - Thanks!

https://powerusers.microsoft.com/t5/Building-Power-Apps/PowerApp-quot-removing-quot-delimiters-from-...

[Yuri_Porto90]

You can do just this too

Substitute(YourNumber; ","; "."). The inverse also works