web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Powerapps barcode scan...

Power Apps

Answered

Powerapps barcode scanner - scanned data challenge

(0) Share

Report

Report

Posted on by AndyinWales

20

Hello wonderful powerapps people!

I've built a QR scanner for event registration, that looks up the scanner QR in a sharepoint list, and then returns either the booked record or a register new person if no record found.

The challenge I'm encountering is that there are two different ways the QR code is presenting:

1. In email comms CRMURL.com/QRCodeGen.ashx?Id=4g8d1329-6b31-ee11-bdf4-6045bd905f89 .jpeg

2. In print comms 4g8d1329-6b31-ee11-bdf4-6045bd905f89

the OcScan properites are Set(VarScannedBarcode, First(BarcodeReader2.Barcodes).Value)

Then the gallery item code is Filter(ODDATA, Title=Right(VarScannedBarcode, 36)) which is getting me part of the way there, but I'm struggling to figure out how to variably remove the 5 spaces.jpeg when present.

Any help very much appreciated!

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

gcmfaizan 1,022 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @AndyinWales ,

can you try this formula I hope this will resolve your issue:

Set(VarScannedBarcode, First(BarcodeReader2.Barcodes).Value); Set(VarScannedBarcode, If(Right(VarScannedBarcode, 5) = ".jpeg", Mid(VarScannedBarcode, 1, Len(VarScannedBarcode) - 5), VarScannedBarcode)); Filter(ODDATA, Title = VarScannedBarcode)

If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.

Cheers!

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @AndyinWales ,

You can use below formula to get the ID:

Set(VarScannedBarcode,Last(Split(First(Split(First(BarcodeReader2.Barcodes).Value," ")).Value,"=")).Value)
Filter(ODDATA, Title=VarScannedBarcode)

Best regards,

Was this reply helpful? Yes No

Join the conversation