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)

Sort by

Michael E. Gernaey 53,963 Moderator on at

Like (1)

Report
Copy link

Link copied!

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 37,199 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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 37,199 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
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
Copy link

Link copied!

timl

It works. Thank you very much <3

Was this reply helpful? Yes No