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:
Solved! Go to Solution.
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:
I have made a test on my side, please take a try to modify your formula as below:
Then check if the issue is solved.
More details about the Text function in PowerApps, please check the following article:
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
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.
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.
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
Learn how to build the business apps that you need.