cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
korfanidi
New Member

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

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 toValidLostNumber Plate
12 34 56 78BobYN1-NUMB-PLATE
34 56 78 89MaryNY2-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

 

1 REPLY 1
WarrenBelz
Super User
Super User

Hi @korfanidi ,

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

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

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,295)