Enable comma or dot as decimal separator

Like (1) Share

Report

Posted on 14 Jul 2023 18:41:02 by Fedepuszko

Hi guys, hope you are doing well.

I'm having some issues with an app where the client sometimes puts commas and dots to define decimals but when it puts a dot, the number multiplies or something like that.
I've searched several forums and solutions but none of them worked for me.

In my specific case, I need that the field on the table can take commas and dots as decimals whenever the user puts there.

I can't modify the data type or do anything else(or at least it escapes my knowledge).

I've also tried the text() function without success.

To demonstrate the issue, on the first case with comma it works well, but on the second when I put 100.5, the field is completed with 10.050,00. We need that it works the same as a comma.

Do you have any idea if this is possible in this instance?
Thanks in advance.

Categories:

Mobile App

All responses (3)

Answers (0)

jfranciscose 9 on 24 Jun 2024 at 23:45:24

Like (0)

Report

Re: Enable comma or dot as decimal separator

How did you solve it?
Fedepuszko 4 on 17 Jul 2023 at 12:41:00

Like (0)

Report

Re: Enable comma or dot as decimal separator

Hi @PowerNuggets
THanks for your response. I forget to mention that both option, dots and commas must be usable.

I'll keep trying alternatives. Thanks!
PowerNuggets 360 on 15 Jul 2023 at 05:45:52

Like (0)

Report

Re: Enable comma or dot as decimal separator

Hi @Fedepuszko

I believe the Decimal separator character is dependent on language. some regions of the world use "." as a decimal separator while others use ","

You can try Text to change the format

or

Substitute(Number; ","; ".")

more on the subject from this article
https://learn.microsoft.com/en-us/power-platform/power-fx/reference/operators

_____________________________________________________________________________________
Like my answer? - Hit that Thumbs Up. Resolved the Issue? - Hit Accept as Solution.

KR,