Drivers License PDF417 Barcode Data Extraction 02-06-2020 17:41 PM - last edited 02-07-2020 09:03 AM

[Anonymous]

     This app shows you how to extract data from a drivers license barcode. There is an incredible amount of data in every drivers license; being able to collect it has many purposes. From HR on-boarding to event registration and check in, the possibilities are nearly endless.

     There isn't a lot to this app. Each value has it's own Match() function to build the data collection. In the example below you can see that the abbreviation "DAA" matches the "Full Name" value, so I use a regular expression to find that value and add it to the collection.

{Value: First(Match(LicenseData,"\n" & "DAA" & "(.+)\n",MatchOptions.Contains).SubMatches), Description: "Full Name" },

Special thanks to this post that had the abbreviations for all the data explained.

https://blog.dynamsoft.com/imaging/extract-data-pdf417-driver-licenses/

Download the app, scan your license (or the sample license barcode attached) and let me know some use cases you can think of!

Thank you!

Eric

[sjdwyer2]

VERY cool, thank you for posting. Curious whether you need to use any licenses besides Power Apps? 

[Anonymous]

I really wish I could see the full breakdown of this or the exported .zip file for the app. Really love this and wish I could implement this in my app but having a hard time figuring out what goes where. Do you have a tutorial?

[Anonymous]

Hey @Anonymous , the .msapp file is attached above. You can use that to open the example app into your environment and poke around. The bulk of the work is done in the scanner button's OnScan action. To open the .msapp file, create a blank canvas app, go to File > Open and select the downloaded file from your computer.

Hope that helps!

[Anonymous]

I've tried multiple time to import this .msapp file and it does not allow it. Tried renaming it a ZIP file, that too doesnt work. The expected format to import is a ZIP I believe. 

Thanks

[Anonymous]

@Anonymous  Sounds like you're trying to import it via the Power Apps dashboard. Check this video out to see the steps to open an msapp file

https://youtu.be/QnwRK93rmSE?list=PLlGQVzFC9P4S4TuZoZTNu_Z7HOUXxHQlV&t=74

[Anonymous]

I've got it now, Thank you so much. Great work!

[Anonymous]

@Anonymous Awesome! Thank you!

[Anonymous]

One more thing, What would you think would be the best way to save the information scanned to a spreadsheet? I've tried to add a button that takes data from collection "driverLicenseFields" or "license data" but not sure. Also tried adding a second screen that fills out a form to submit from data collected along with a Now() but cant get the form to populate any data. Should I send it to a table or form? 

Thanks

[DC13]

Hello Eric,

Sorry I am a newbie to this. Do I need a scanning tool or can I connect it to my phone as a scanner for this app? Please let me know how it works. Thank you very much.

[onionsunset]

This is great thank you! One this I noticed is it doesn't decode the DAQ field which starts in the middle of the string in the ANSI line. Any idea how to fix that? 

{Value: First(Match(LicenseData,"\n" & "DAQ" & "(.+)\n",MatchOptions.Contains).SubMatches), Description: "License or ID Number" },