Answered

Value() length limitation?

(0) Share

Report

Posted on by JasonZF

572

I can't find any article or mention of this anywhere. Is there a number length limitation to the Value() function? I'm trying to use Value() on an 18-digit barcode to drop the leading zero, and it's returning the wrong value. Sometimes the last digit is correct, sometimes it's off by one. I can probably get around this by evaluating the first digit inside an If() function, but I'd like for Value() to work.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

AhmedSalih 6,680 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hello, @JasonWS , yes, there is limitations of the 64-bit double precision floating-point format used by Power Apps. This format can exactly represent integers up to 15 digits long, but beyond that, it may not be able to represent large integers exactly due to its finite precision.

My test:

I would then recommend using the if function:

If( Left(YourBarcodeValue, 1) = "0", Right(YourBarcodeValue, Len(YourBarcodeValue) - 1), YourBarcodeValue )

If my reply helped you, please give a 👍 If it solved your issue, please give a 👍 & accept it as the Solution to help other community members find it more.

Visit my Blog: ahmedsalih.blog

Visit my YouTube Channel: https://www.youtube.com/@powerplatformplace/videos

Was this reply helpful? Yes No
JasonZF 572 on at

Like (2)

Report
Copy link

Link copied!
Thanks! Glad I'm not going crazy. I indeed swapped my formula, although I have a slight difference. Mid() works without the 3rd parameter.
If( Left(Self.Text,1) = "0", Mid(Self.Text,2), Self.Text )
This is on the text input control where the barcode is scanned.

Was this reply helpful? Yes No
iAm_ManCat 18,256 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi,

Just wanted to add that while I agree with Ahmed about the precision, I don't believe removing the preceding zero is sufficient.

If we look at a few examples I pulled, converting to value using the same barcode format you have, there are times where the rounding does not work as expected.

I would Heavily advise in this case to compare it as a string against another string instead of using Value.

Cheers,

Sancho

Was this reply helpful? Yes No
JasonZF 572 on at

Like (1)

Report
Copy link

Link copied!

I am not converting it to a value after removing the zero since it's still over the 15-digit limit. I am leaving it as a string after removing the leading zero. I was trying to utilize Value() purely to remove the leading zero, not because I needed it to be a number. This string contains two different pieces of data mashed together, so I am utilizing Value() farther down in my formula, however only on subsets of the string. For example, the last seven digits are a serial number. I am utilizing Value(Right(BarcodeString,7)) at one point to remove the leading zero from those seven digits, which works fine.

Was this reply helpful? Yes No
iAm_ManCat 18,256 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Awesome, well no worries then! Just wanted to flag that in case the 15+ Value might be used somewhere 🙂

Hope you have a good rest of the weekend,

Cheers,

Sancho

Was this reply helpful? Yes No