Look up a value from QR Code Scanner, and get a list of associated variables

[Anonymous]

Hi there!

Newbie here, sorry if this seems too easy. I have been looking on forums and YouTube and I can't seem to get it right!

I have an excel sheet with format:

Car Pass Code	Team Assigned to	Valid	Lost	Number Plate
12 34 56 78	Bob	Y	N	1-NUMB-PLATE
34 56 78 89	Mary	N	Y	2-PLATE-NUMB

My goal is to scan the QR code (that just codes the number from the first column) i.e. 12 34 56 78 and to get as a result a list like:

Car Pass code: 12 34 56 78

Team Assigned to: Bob

Valid: Y

Expired: N

Number Plate: 1-NUMB-PLATE

and then the possibility to:

a) edit this data

2) go back to scanner and scan another QR code.

I manage to have the results by typing the code, but I can't by scanning it.

Can someone help with the coding please??

Thank you in advance,

Katerina

[WarrenBelz]

Hi @Anonymous ,

The Item of the Form (ensure also the DataSource is set to the table name) would be

LookUp(
   ExcelTableName,
   'Car Pass Code' = BarcodeScannerName.Value
)

[TimoSwart]

Hi @WarrenBelz,

How would you do this when you're using the "Scan Multiple" scanning mode as it will give you a table instead of a text value?

I'm trying to figure this out myself.

[WarrenBelz]

@TimoSwart ,

The first scanned item is

First(BarcodeScannerName.Barcodes).Value

[TimoSwart]

@WarrenBelz,

Thanks! But this will only return the first scanned barcode. If I scan, let's say, 5 barcodes, I want to see data for those 5 scanned barcodes not just the first one.

Here's the code I've created right now:

ForAll(
BarcodeReader1.Barcodes, LookUp(Articlenumbers,ID = First(BarcodeReader1.Barcodes).Value, Article & " " & Name)
)

Right now this generates a list of articles where the number of records is equal to the amount of scanned articles. However, all of the data displayed is the same for each item.

Hope I've described it clearly 🙂

[WarrenBelz · Accepted solution]

@TimoSwart ,

You have a many-to-many relationship and this is not straight-forward. Also if ID is a number, you have a further Delegation issue. So with ID as a Number

With(
   {
      _Scanned:
      AddColumns(
         BarcodeReader1.Barcodes,
         "_ID",
         Value(Value)
      )
   },
   Ungroup(
      ForAll(
         _Scanned As _Codes,
         AddColumns(
            Filter(
               Articlenumbers,
               ID = _Codes._ID
            ),
            "Data",
            Article & " " & Name
         )
      ),
      "Value"
   )
).Data

With ID as a Text value

Ungroup(
   ForAll(
      BarcodeReader1.Barcodes As _Codes,
      AddColumns(
         Filter(
            Articlenumbers,
            ID = _Codes.Value
         ),
         "Data",
         Article & " " & Name
      )
   ),
   "Value"
).Data

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications)   Visit my blog Practical Power Apps

[TimoSwart]

@WarrenBelz,

Thanks for your help! This works perfectly.