Decimal Separator (Comma) - Global Apps (Languages)

[abhishekgawde]

Hello Power People!

I have a SharePoint List with a column (Purchase Amount (Specify Units)) of data type Number. The regional settings (locale) of this particular site is German (Germany).

I am using a form in the PowerApps to enter/ update the value in this field with a SubmitForm function.

The formulas for the data card (DataPurchaseAmount) as follows:

Update: Value(DataPurchaseAmount.Text, Language())

Default: Value(ThisItem.'Purchase Amount (Specify Units)',Language())

The default formula for the Text Input of the card is as follow:

Text(Value(Parent.Default,Language()),"[$-en]0,00", Language())

Now, if i use the application in a browser with the language as English everything works fine. 

1. if i enter 1.50 -->1.50 is saved
2. if i enter 1,500 --> 1500 is saved

However, if i use the application in a browser with the language as German,

1. 1.5 is saved as 15 (this is correct)
2. 1,5 is also saved as 15 (ideally would expect it to store 1.5)
   1. more examples... 1,65 is saved as 165

I have tried various combinations of the formulas, but nothing seem to work.

Can anyone please help me here.

More Power to All!

Abhishek

[v-jefferni · Accepted solution]

Hi @abhishekgawde ,

As per you mentioned, I made a test for you:

My computer is set to Germany. 

SharePoint site language is Germany:

App running in English, browser of Chrome:

App running in Germany, browser of Edge:

App settings:

Purchase Amount (Specify Units)_DataCard1:

Default: ThisItem.'Purchase Amount (Specify Units)'

Update: Value(DataCardValue2.Text,Language())

TextInput of Purchase Amount:

Format: Text

Default: Value(Parent.Default,Language())

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

[abhishekgawde]

Hello @v-jefferni ,

I was able to reproduce the scenario you mentioned above.

But when i try to save in the German Language browser, "1,5" is converted to "15".

also, i create a new record with "1,5" as the value, it is converted to "15"...."1,55" is converted to "155"

Have attached a gif for reference.

[v-jefferni]

Hi @abhishekgawde ,

I just change language of Chrome to Germany:

And now the App running in Chrome:

When I change back to English:

The App became:

Have you published the App?

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

[abhishekgawde]

Hi @v-jefferni ,

Yes, I have published the app. I have been testing the app myself, no success.

Maybe I am missing some setting at the PowerApps level?

Best,

Abhishek

[v-jefferni]

@abhishekgawde ,

Don't think so. I have not changed any settings in Power Apps except those formulas and controls level modification in my first reply.

Please refer to the screens in my last reply and make sure you have changed language of your browsers properly.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

[v-jefferni · Accepted solution]

Hi @abhishekgawde ,

Have you resolved the issue? 

If above post helps, then please consider Accept it as the solution to help the other members find it.

Best regards,
Community Support Team _ Jeffer Ni

[jlke-as]

Hi... I have a more or less similar issue...

I'm from Denmark, so I would like to use comma to separete a fraction number... I would assume that there was a setting somewhere in Power Apps to make Power Apps calculate in "my way..." - but I cannot find this kind of setting any where... Can you help me?

In a table I have some numbers (hours) - and I would like to the user to split the hours into groups. In this process the user should see:

1) see the total figure to be split (in this case 7 hours)

2) insert a figure to dedicate to a group (as a default it should show the remaining hours, that needs to be dedicated to a group) 

3) see the amount of hours that have been split so far...

As you can see, I have managed to all figures shown with comma as separator - but the "15,00" and "25,00" has actually been add as "1,5" and "2,5" (as we do fractions in Denmark)... But Power Apps understands it as "15" and "25" and therefore sums it up to "40" instead of "4" (so now Power Apps thinks that have split 33 hours more than needed)...

My language in Chrome is Danish - and I assume that both Denmark and Germany uses comma as separator... But it doesn't work for mig...

How can I get Power App to do calculations with comma as separator?

wkr Jørgen

[Kujo_DK]

Hi.  did you find the solution?

[jlke-as]

Hi

There is (or was) a bug in Power Apps...

I had a correspondance with some support guys, but after a longer period I changed my sources to be Sharepoint Lists in stead one drive...