Change decimal dot to comma

(1) Share

Report

Posted on by MaiLe

Hi,

I have difficulty in decimal separator as below.

My number income uses decimal dot, but when I submit it to sharepoint, the decimal dot becomes thousand separator .

Ex: 700.23 in power apps, but in sharepoint it shows 70023.

I did change the sharepoint setting to Australia Region which using decimal dot, but the result is still the same. Therefore, I think the problem is that I need to change in the power apps.

Please help me to solve the problem.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Michael E. Gernaey 53,351 Super User 2025 Season 2 on at

Like (1)

Report

Hi

Its not really possible to say 100% because you didn't share your app, the code you use to save the data etc etc.

Was this reply helpful? Yes No
timl 36,383 Super User 2025 Season 2 on at

Like (0)

Report

Can you confirm that you're using a SharePoint number column and not a SharePoint text column?

Was this reply helpful? Yes No
MaiLe 36 on at

Like (0)

Report

FLMike Please see my code below.

The quantity/pallet value is taken from my barcode (776.46), but the system understood the decimal dot to thousand decimal so it become 77646 in my sharepoint when I submit.

The code to save data I used Submit(form).

timl Here is the result after submitting in sharepoint and the column setting.

Was this reply helpful? Yes No
Verified answer

timl 36,383 Super User 2025 Season 2 on at

Like (1)

Report
Hi MaiLe

Thanks for the clarification. If you amend the Update property of your card so that it calls the Value function to convert to a number, that should hopefully resolve the problem. The formula below uses the English locale "en" which uses the dot symbol as the decimal point seperator.

If(!IsBlankOrError(DataCardValue2.Text); Value(Index(Split(DataCardValue2.Text; Char(35));5).Value; "en" ) )

Was this reply helpful? Yes No
MaiLe 36 on at

Like (1)

Report

timl

It works. Thank you very much <3

Was this reply helpful? Yes No