Answered

Barcodescanner in Gallery with excel data

(0) Share

Report

Posted on by MelvinGRM

Hello!

I've build a barcodescanner that scans to MyCollection. with a gallery that shows "MyCollection" Is there a way that if i scan the barcode it shows the data that match with barcode from a excel table? / (I dont have access to Sharepoint 😞 )

Schermafbeelding 2020-08-05 om 11.18.36.png

What i Get:

WhatsApp Image 2020-08-05 at 11.07.54.jpeg

What i want:

Schermafbeelding 2020-08-05 om 11.32.40.png

Thanks!

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

mdevaney 29,993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@MelvinGRM
Put this code in the Item property of the form. Then the form will show the result of what was scanned.

LookUp(ExcelTableName, barcode=BarcodeScanner1.Value)

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
MelvinGRM 84 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry...Do i put the code in a (new) gallery or in a form?
I got in the Gallery.Items: MyCollection
Thx!
mdevaney 29,993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@MelvinGRM

I would put it inside the Item property of the form.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."