Barcode Reader to Update Excel table

Like (0) Share

Report

Posted on 3 Nov 2023 14:55:03 by TimeFae

I have an excel table with three columns, Barcode, Available, and StockQty.

I am trying to build a PowerApp where I can scan a barcode, and it look on the Excel Table in the "Barcode" column for that value.

If that barcode is in Table 1, column "Barcode" - I would like it to go to a form so I can update the Available and StockQty columns for that barcode.

I can't seem to get past the first step here.

I have tried creating a Collection of Scanned Values...

Collect(colScannedItems,
 {ScannedItem: First(BarcodeReader.Barcodes).Value, ScannedTime: Now()}
)

I have tried creating a Lookup...

LookUp(Table1,Barcode=First(BarcodeReader.Barcodes).Value)

But I keep receiving errors.

I believe a Patch function will be needed, but I cant figure out logically where to put it because BarcodeReader creates a table.

Any help is appreciated! I can't find very clear info on the most up-to-date Barcode Reader input.

barcodereader.PNG

All responses (1)

Answers (0)

TimeFae 49 on 03 Nov 2023 at 18:07:16

Like (0)

Report
Re: Barcode Reader to Update Excel table

This didn't work exactly as I had hoped but it helped me a lot - so thank you.

I ended up taking out the Form portion and instead just updating the spreadsheet directly.
Turns out I only needed to mark it as "available" not update the qty.

I ended up using this formula On Scan...
Set(scannedItem, First(BarcodeScanner.Barcodes).Value); Set(foundItem, LookUp(Table1_1, Barcode = scannedItem)); If( Not(IsBlank(foundItem)), Patch( Table1_1, foundItem, {Available:"Yes"} ), Notify("Item not found") )

scantosetyes.PNG