PowerApps reading incorrect large numbers from Sharepoint List

Like (1) Share

Report

Posted on 28 Aug 2024 01:58:11 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:

Connectors

All responses (5)

Answers (0)

Suggested answer

narayan225 2,454 Super User 2025 Season 1 on 29 Aug 2024 at 10:54:24

Like (1)

Report

PowerApps reading incorrect large numbers from Sharepoint List

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!
CJ-28080137-0 6 on 28 Aug 2024 at 12:30:21

Like (2)

Report

PowerApps reading incorrect large numbers from Sharepoint List

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.
Suggested answer

narayan225 2,454 Super User 2025 Season 1 on 28 Aug 2024 at 07:14:21

Like (1)

Report

PowerApps reading incorrect large numbers from Sharepoint List

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
CJ-28080137-0 6 on 28 Aug 2024 at 06:46:55

Like (1)

Report

PowerApps reading incorrect large numbers from Sharepoint List

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.
narayan225 2,454 Super User 2025 Season 1 on 28 Aug 2024 at 05:27:44

Like (1)

Report

PowerApps reading incorrect large numbers from Sharepoint List

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.