Int() Function Unintentionally Incrementing - Possible Integer Digit Limit?

(0) Share

Report

Posted on by Wahv

Hello All,

I am having trouble understanding why this is happening in my app.

Context: My data is stored in a SharePoint list, one of my fields is a 15-digit binary string saved as a single line of text in SharePoint. For testing, I set the field to all ones (111111111111111). My procedure is to concatenate this string of ones to a leading integer, 9 in this case, so that the left most digits wont get trimmed by the Int() function if they are 0.

Issue: When I run Int() on the string "9111111111111111", it converts to Int and increments the integer by 1 making it "9111111111111112". Furthermore, anything past 18 digits becomes a 0.

I think I might be running into the size limit on integers, which if true is kind of a letdown. It's like if Superman could do everything but tie his shoes.

Thanks for any advice on this, please let me know if I need to supply more information.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

enriqueglopez 503 Moderator on at

Like (0)

Report

Why dont you use 'Value()'? Int is for round

Was this reply helpful? Yes No
Wahv 62 on at

Like (0)

Report

That's a good idea, but Value appears to be behaving similarly to Int in this case. Both functions end up yielding numbers in scientific notation that I can see at the bottom of the function box. It appears to have a limit of 18 decimal places.

Was this reply helpful? Yes No
Verified answer

timl 36,383 Super User 2025 Season 2 on at

Like (1)

Report

@Wahv

9111111111111111 exceeds the maximum value that's supported by JavaScript, which Power Apps has a dependency on. Therefore, the answer to your question is yes, there is an integer digit that you've hit.

There are some more details in this post beneath.

https://powerusers.microsoft.com/t5/Building-Power-Apps/What-s-the-maximum-value-you-can-store-in-a-number-field/m-p/31418

Was this reply helpful? Yes No
Wahv 62 on at

Like (0)

Report

Thanks! Looks like the strings are the way to go here.

Was this reply helpful? Yes No