Skip to main content

Notifications

Community site session details

Community site session details

Session Id : Gp1s1xB10lXiwO38jCv44Q

Drivers License PDF417 Barcode Data Extraction

Community Power Platform Member Profile Picture Posted 07 Feb 2020 by Community Power Pla...

bc.png

     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

Categories:

Mobile App Design and User Experience

Comments

  • MarieKĂĽhne Profile Picture MarieKĂĽhne
    Posted 04 Mar 2024 at 15:10:45
    Drivers License PDF417 Barcode Data Extraction

    I can also recommend checking this article of a Barcode SDK provider, giving an overview of the barcode types.

  • CALEBHOWARD80 Profile Picture CALEBHOWARD80 25
    Posted 03 Feb 2023 at 04:18:40
    Drivers License PDF417 Barcode Data Extraction

    Solved: Re: How To Open .MSApp Files - Power Platform Community (microsoft.com)

  • onionsunset Profile Picture onionsunset
    Posted 28 Sep 2022 at 15:47:16
    Drivers License PDF417 Barcode Data Extraction

    I don't really understand all of the regular expression stuff but I tried on the test barcode from this post and my state's barcode which uses the same format as the test. They both have the DAQ prefix preceding the license number. Unlike all of the other ones where the new line starts with the prefix, the DAQ one is in the middle of the string of that line, not starting as its own line. As an example, the sample barcode from this post has DAQ is in the line "ANSI 6360050101DL00300203DLDAQ3265188" and the match isn't finding the DAQ in that line and returning 3265188. It works for every other field!

  • FirstFedDH Profile Picture FirstFedDH
    Posted 28 Sep 2022 at 15:33:47
    Drivers License PDF417 Barcode Data Extraction

    I think it depends on what state you are decoding for but have you checked to see if the data you need is in one of the two following outputs:

    First(
    Match(
    LicenseData,
    "\n" & "DAQ" & "(.+)\n",
    MatchOptions.Contains
    ).SubMatches).Value

     

    or 

    First(
    Match(
    LicenseData,
    "\n" & "DCF" & "(.+)\n",
    MatchOptions.Contains
    ).SubMatches
    ).Value

  • onionsunset Profile Picture onionsunset
    Posted 28 Sep 2022 at 15:12:38
    Drivers License PDF417 Barcode Data Extraction

    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" },

     

  • DC13 Profile Picture DC13
    Posted 20 Aug 2022 at 19:10:03
    Drivers License PDF417 Barcode Data Extraction

    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.

  • Community Power Platform Member Profile Picture Community Power Pla...
    Posted 05 Aug 2022 at 15:57:07
    Drivers License PDF417 Barcode Data Extraction

    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

  • Community Power Platform Member Profile Picture Community Power Pla...
    Posted 02 Aug 2022 at 20:19:42
    Drivers License PDF417 Barcode Data Extraction

    @Anonymous Awesome! Thank you!

  • Community Power Platform Member Profile Picture Community Power Pla...
    Posted 02 Aug 2022 at 20:19:06
    Drivers License PDF417 Barcode Data Extraction

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

  • Community Power Platform Member Profile Picture Community Power Pla...
    Posted 02 Aug 2022 at 20:17:54
    Drivers License PDF417 Barcode Data Extraction

    @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