Unanswered

Enable comma or dot as decimal separator

(1) Share

Report

Posted on 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:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

PowerNuggets 360 on at

Like (0)

Report

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,

Was this reply helpful? Yes No
Fedepuszko 4 on at

Like (0)

Report

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!

Was this reply helpful? Yes No
jfranciscose 9 on at

Like (0)

Report

How did you solve it?

Was this reply helpful? Yes No