Answered

Scan Multiple QR Codes to one Sharepoint List Record

(1) Share

Report

Posted on by DougDavies

Is there a way to scan multiple QR Codes to a comma delimited list to submit with a single record?

I have an app where I'm collecting information from a survey team, and would like all their information - including a QR scan of multiple survey sheets with serial numbers printed as QR codes to a single record so it would look something like the below.

Surveyor Name | Date | Survey Numbers

John Smith | 3/22 | 001, 002, 003, 004, ...

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

KeithAtherton 3,705 Most Valuable Professional on at

Like (0)

Report
Hi @DougDavies,

Yes, here are a few possible approaches:

Continue using your approach by building a comma-delimited string to be saved against the record. Each QR code scan could return a value (e.g. 001) which is appended to a local variable (e.g. locSurveyNumbers) by using the & operator or the Concatenate function. For example:

UpdateContext({locSurveyNumbers:locSurveyNumbers & ", " & locScanValue)});

Another approach would be to save a record for each QR code scan instead of building a comma-delimited string of all scans. The benefit of this would be that you can easily identify the survey number in future as it's an individual value instead of having to split a string of multiple survey numbers. This is helpful if you need to edit/delete existing scans, report on scanned survey numbers, etc.

Obviously, the decision depends on your needs.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Follow me online.

Was this reply helpful? Yes No
DougDavies 6 on at

Like (1)

Report

Fantastic, I'll go the record individual record route.

When I add the Barcode Scanner to the Field Data Card, how do I have all the data in other cards stay, while resetting the Barcode Scanner to get ready for the next scan - aka i want all the other data card information to be saved with every barcode scan.

I can create a separate "clear all" button once they need to start a new record.

Was this reply helpful? Yes No
KeithAtherton 3,705 Most Valuable Professional on at

Like (0)

Report

Just before you reset the Barcode Scanner to get ready for the next scan, you could save all current data card values as local variables (e.g. locValue1, locValue2, etc but better named) then use these variables as default values for the data cards.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Follow me online.

Was this reply helpful? Yes No