Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Timothy Gibble]

Hello UG,

I am developing an app using the barcode scanner control.  I have a local collection, called ListAll, where the title column are part numbers and another column with the part description.  I have the app setup where the user scans a barcode that returns a part number.  I then have a label that looks up the part number in the collection and returns the description (LookUp(ListAll, Title = Label11.Text).Description).  The issue is, when I use the barcode scanner, the part number appears but the description does not.  If I change the label to show the text and not the barcode result (“73520-986”), the description appears. 

My question is, why is the barcode scanner result not the same as a manual text. 

Please see the screen shot below.  The number next to the “Scan” button is a result from the barcode scanner.  The number circled in red is just a label (“73520-986”).  The yellow circle is a function where it returns true of the label in red matches the barcode scan result, and false if they are not equal. The numbers appear to be the same.  

Thanks for you help.  

——————————
Tim
——————————

[Andy Tippin]

I played with Barcode scanner previously but my lookup was done on an integer from SQL. I remember that I had to use .Value to keep it as a number. Otherwise it treated it like text by default.

You can try to substitute Lookup with Filter or Search maybe? https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-filter-lookup

——————————
Andy Tippin
——————————
——————————————-