cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
wilberttouw
Level: Powered On

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

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)")

 

1 ACCEPTED SOLUTION

Accepted Solutions
wilberttouw
Level: Powered On

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

Hi Carlos,

 

i checked my solution and now it works.

 

Thank You

6 REPLIES 6
Community Support Team
Community Support Team

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

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

 

 

 

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
wilberttouw
Level: Powered On

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

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

 

PowerApps Staff CarlosFigueira
PowerApps Staff

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

 

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
Level: Powered On

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

Hello Carlos,

 

Is there any update on this? 

 

Thanks,

Archana

PowerApps Staff CarlosFigueira
PowerApps Staff

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

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
Level: Powered On

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

Hi Carlos,

 

i checked my solution and now it works.

 

Thank You

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

SecondImage

PowerApps Monthly Community Call

Next Wednesday, August 21st at 8am PDT

Top Community Contributors for July 2019

Top Community Contributors for July 2019

Let's thank our top community contributors

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

FifthImage

Dynamics 365 and Power Platform April 2019 Release notes

Features releasing from April 2019 through September 2019!

SixthImage

Power Summit Australia 2019

August 20-23rd 2019

Users Online
Currently online: 30 members 3,631 guests
Recent signins:
Please welcome our newest community members: