Set Item property for Barcode Reader control

(0) Share

Report

Posted on by SoniaW316

I have a barcode reader control on my edit screen.

The new control scans the values to a table.

I have my OnScan property as: Set(varScanArt, First(BarcodeReaderArt.Barcodes).Value)

I need to set the item property of my form and that is where I am struggling.

I tried this:

LookUp(Pieces, First(BarcodeReaderArt.Barcodes).Value = varScanArt) - it works but it pulls the first value in the entire table and not what I just scanned.

Appreciate any assistance.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

narayan225 2,547 Moderator on at

Like (0)

Report
Copy link

Link copied!
@SoniaW316

You are using to LookUp an item in the Pieces table. But when using the LookUp you are comparing the barcode table with varScanArt which also contains barcodes.

Try using this.

LookUp(Pieces,columnName = First(BarcodeReaderArt.Barcodes).Value)

There are more tutorials here if you need any:

https://www.spguides.com/powerapps-barcode-scanner/

Cheers!

Was this reply helpful? Yes No
SoniaW316 81 on at

Like (0)

Report
Copy link

Link copied!

So I have 4 screens I need to navigate to. I will put the barcode reader on each of the four.
I want to scan a qr code and populate both the details portion and the edit details of this form? Only the bottom form gets submitted since it's open for edits.

I used LookUp(Pieces, First(BarcodeReaderArt.Barcodes).Value = varScanArt) which holds but only pulls the first item from the Dataverse table and not what I just scanned.

I tried Filter(Pieces,'Install Location'=varScanArt) - obviously errors.

Just using the variable from the Set isn't working.

Was this reply helpful? Yes No
narayan225 2,547 Moderator on at

Like (0)

Report
Copy link

Link copied!
@SoniaW316

You will need to set the OnScan property of barcode reader to:

Collect( colScannedItems, {ScannedItem: First(BarcodeReader1.Barcodes).Value} )

After that, use the following formula to get the scanned item from your data source.

LookUp(Pieces,columnName = First(colScannedItems).ScannedItem)

Replace columnName from above formula to the column that exists in Pieces table/list.

Cheers!

Was this reply helpful? Yes No
SoniaW316 81 on at

Like (0)

Report
Copy link

Link copied!

These forumlas worked but it just says getting your data and never retrieves anything.

The QR Code has 3 pieces of data embedded, Install Location, Piece # and Job. I tried using all 3 column names and it was the same result.

I appreciate you helping me with this!

Was this reply helpful? Yes No
narayan225 2,547 Moderator on at

Like (0)

Report
Copy link

Link copied!

@SoniaW316

What is your formula for the onscan property of the barcode reader and item property of the form?

Also, when you can QR Code/Barcode, it will send you just one value to your app. You are saying that it has 3 piece of data embedded, what do you mean?

When using the lookup, you need to compare the value you are getting to the column that you have in SharePoint to access that record.

Cheers!

Was this reply helpful? Yes No