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

[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.

[enriqueglopez]

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

[Wahv]

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.

[timl · Accepted solution]

@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-...

[Wahv]

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