PowerApps reading incorrect large numbers from Sharepoint List

(1) Share

Report

Posted on by CJ-28080137-0

Hi, I have a gallery of text fields with a Sharepoint List connected as the data source. The text fields read correctly except for some large numbers (particularly when it comes to numbers in the millions). For some large numbers, the app reads the large numbers and changes them by a minuscule amount (by a matter of .00000001). This is problematic as I have data validation coded into the text fields to show an error when the numbers have more than 2 decimal places. I have tried changing the numbers from Sharepoint and also changing the number on the text field itself and patching to Sharepoint, however it reverts itself to the incorrect value.

Number as displayed in PowerApps:

Number as displayed in Sharepoint List:

How do I ensure PowerApps doesn't change the number from Sharepoint?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

narayan225 2,547 Super User 2025 Season 2 on at

Like (1)

Report

Because the decimal place is set to 2. It rounds up the value to .30 and because the last 0 doesn't matter, it ignores it.

I think this is an expected behaviour.

Was this reply helpful? Yes No
CJ-28080137-0 6 on at

Like (1)

Report

No, the original data reads 152710342.3, whereas PowerApps is reading from Sharepoint however somehow adding 0.00000001 to the original value. Apologies if the original post was not worded well.

Was this reply helpful? Yes No
Suggested answer

narayan225 2,547 Super User 2025 Season 2 on at

Like (1)

Report

If it is a calculated column, it is a known issue.

Check the following article: http://powerappsguide.com/blog/post/sharepoint-beware-of-calculated-columns

Was this reply helpful? Yes No
CJ-28080137-0 6 on at

Like (2)

Report

It isn't a calculated column, just a regular numerical column. I have followed similar instructions to your linked article to "mask" the issue but still curious as to why the issue occurs in the first place.

Was this reply helpful? Yes No
Suggested answer

narayan225 2,547 Super User 2025 Season 2 on at

Like (1)

Report

It is very unusual that it happens but not sure why it happens.

Sometimes and I have experienced it myself, the straightforward things in PowerApps give error even though it shouldn't.

Cheers!

Was this reply helpful? Yes No