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

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

mdevaney 29,989 Moderator on at

Like (0)

Report
@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."

Was this reply helpful? Yes No
MelvinGRM 84 on at

Like (0)

Report

Sorry...Do i put the code in a (new) gallery or in a form?
I got in the Gallery.Items: MyCollection
Thx!

Was this reply helpful? Yes No
mdevaney 29,989 Moderator on at

Like (0)

Report

@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."

Was this reply helpful? Yes No