LOOKUP & leading zeros

[BakMunSu]

I have a LOOKUP function in one of my forms that matches on barcodes and it works fine for “normal” ones, but the ones that have leading zeros don’t seem to match.
In Gsheets I formatted both columns as Plain Text and in AppSheet they’re formated as text. Have anyone else came across this before and managed to solve it?

[BakMunSu · Accepted solution]

Nevermind, looks like for some reason one of the fields was still a Number in AppSheet.