Unanswered

Having an issue with forces rounding of long numbers

(0) Share

Report

Posted on by Dmansell

I've created an app recently that requires the input of a 16 digit number. When a user submits this form it goes to the sharepoint list it's connected to with the last 2 digits rounded (ex. 78 rounds to 80). I'm finding nothing online about this topic.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

LaurensM 12,516 Moderator on at

Like (0)

Report

[Edited]

Misread the topic, please see @timl's answer

Was this reply helpful? Yes No
LaurensM 12,516 Moderator on at

Like (0)

Report

[Removed]

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

Like (1)

Report

Hi @Dmansell

If you used a SharePoint number column, the floating point nature of this data type does not support the accurate storage of numbers that are 16 digits in length. The workaround is to store your number in a text field. The limitation of this is that you can't sort or perform calculations on the value.

There are more details in the documentation here:

https://support.microsoft.com/en-gb/office/list-and-library-column-types-and-options-0d8ddb7b-7dc7-414d-a283-ee9dca891df7

Was this reply helpful? Yes No
LaurensM 12,516 Moderator on at

Like (0)

Report

Thanks for sharing @timl! - indeed did not think of storage afterwards.

Was this reply helpful? Yes No
Dmansell 2 on at

Like (0)

Report

Thanks for the reply! I knew I could use the text field as a last resort, but I wanted to at least ask in the forum to see if anyone knew of a way to do it with the number column.

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

Like (0)

Report

Hi @Dmansell - unfortunately, there's no way around this issue except to store the number in a text field.

If you need to store numbers fewer than 15 characters, you can prefix the number with 0's. This can help if need to sort the numbers.

Was this reply helpful? Yes No