Answered

Sharepoint list lookup from Barcode scan

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi All,

So looking to make a poor man's barcode scanner for some of our field guys, the barcodes and partnumbers are part of a sharepoint list (barcode (num) , partnumber(text) )

I can use a button and run a look up fine against the list with a barcode number

Set(<PartVariable>, LookUp(<SPList>, Barcode = 884548000000, <PartNumInList>))
The variable is populated and used in the rest of the app

But when i try to use the barcodescanner.value it fails to lookup the value

Set(<ScanVariable>, Value(BarcodeScanner1.Value));
Set(<PartVariable>, LookUp(<SPList>, Barcode = Scan, <PartNumInList>))

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

cwebb365 3,334 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Put a label on screen with that variable see what returns to it if anything. Could be the barcode type isn’t supported or something.
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the suggestion, I added a text input box and confirmed the barcode was coming across right. What i should have checked before was that the barcode actually existed in the document list! I added the right barcode and part number and bam, worked like a dream.

only question i have now is should i be capturing the barcodescanner input into a variable first? if so is there a limit to variables for an app? Also maybe how do you delete a global variable(for the life of me I can't figure it out!)?

Solution -
Confirmed Barcode output was coming across as expected tp input textbox
Confirmed the barcode number i was using actually was in the SP list i running lookup against (was not so fixed this issue)
tested query with actual barcode value that was present the SP list
barcode scan used in the lookup worked as expected.
Jeitana 2 on at

Like
a
(0)

Report
Copy link

Link copied!

I Still cannot look up by barcode scan, please give me more details about this.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Can you give a little more information about what the setup you are using?