Skip to main content

Notifications

Community site session details

Community site session details

Session Id : lvFcQe1eAuGI8LOh3Ozpr2
Power Apps - Building Power Apps
Unanswered

attendance tracking via QR code

Like (1) ShareShare
ReportReport
Posted on 13 Dec 2019 17:01:25 by 371

Hello

Is is possible to scan a qr code (making use of the microsoft 365 logged in user connection) to send this information to a datasource?

Has anyone done this yet? eg student first name, surname,

 

Thanks in advance for any suggestions!

  • flistergod Profile Picture
    4 on 21 Feb 2020 at 20:02:34
    Re: attendance tracking via QR code

    Hi, i am doing a similiar project to the one you replied and the location part it´s a good ideia.

    I thought in gps and using a beacon, but i can not find any support for beacons in power apps.

    Do you know anything about this matter that can help me?

    I wanted to try using a beacon first because i don´t think using gps will the most efficient option.

    Thank you in advance.

  • flistergod Profile Picture
    4 on 21 Feb 2020 at 19:59:03
    Re: attendance tracking via QR code

    Hi, i am doing an internship and i got assigned a project similiar to your ideia.

    How did you solve the location of the qr code? with gps or with a beacon?

    I want to use a beacon, but i can not find any support for beacons in power apps.

    Thanks in advance and sorry for some gramaticall erros, not my first language 🙂

  • Community Power Platform Member Profile Picture
    on 13 Dec 2019 at 20:06:02
    Re: attendance tracking via QR code

    @Englishweb 

    Thank you. If this answered your question, please mark as solution.

  • Englishweb Profile Picture
    371 on 13 Dec 2019 at 19:29:28
    Re: attendance tracking via QR code
    Hello @ EricLott
    Genius idea to use the gps coordinates, however I fear that it wouldn’t be accurate enough to identify students who were in the building - I would need some sort of beacon in the classroom! I’ll try out your solution for the qr code, thanks.
  • Community Power Platform Member Profile Picture
    on 13 Dec 2019 at 18:59:35
    Re: attendance tracking via QR code

    Got it, thank you.

     

    All of this is possible, it's just a matter of how you want to go about it. Do you want to extract certain data from the QR code? If so, refer to my example above. As far as inputting data into a SharePoint List, you can use the Patch() function if it's a current SharePoint record, or SubmitForm() if you want to collect data then submit a new record.

     

    As for the authentication portion, I would suggest gathering the GPS coordinates in the SharePoint list as well, then you can find outliers that were not in attendance. You can get this data from Location.Latitude and Location.Longitude. You could set up a Flow in Power Automate that rejected certain GPS outliers automatically but that may or may not be a good idea.

     

    If the goal is strictly just to gather attendance, you could base it entirely off of GPS and just let them click a button when they arrive as long as they are within a certain GPS grid. Then, you could have a unique QR code as an override in case someone is having issues with their GPS or device.

  • Englishweb Profile Picture
    371 on 13 Dec 2019 at 18:52:08
    Re: attendance tracking via QR code

    Hello @Anonymous 

    Apologies for the lack of clarity!

    So, I am a teacher and I would like my students to

    • scan a QR code using PowerApps when they enter the class
    • Their name is then automatically saved to a SP  list

    As the student will be logged into Office 365 I would like to make use of this connection to create an easy way to log attendance via a QR code scan.

    Is this possible to do?

  • Community Power Platform Member Profile Picture
    on 13 Dec 2019 at 18:42:40
    Re: attendance tracking via QR code

    @Englishweb 

     

    When you say you would like to incorporate User().FullName into the QR code, do you mean you are trying to generate a QR code, or you would just like that data added as well as the QR code data?

     

    As for authentication, I'd have to understand the use case. Could you explain the process of when this would be used in more detail?

     

    Thanks

  • Englishweb Profile Picture
    371 on 13 Dec 2019 at 18:36:40
    Re: attendance tracking via QR code

    Hello @Anonymous 

    Thanks very much for replying!

    I would like to incorporate :  User().FullName into the QR Code so that the user name is saved to a SP list when the QR code is scanned by the logged on user.

     

    As an extra authenticity check, I'm trying to work out a way to avoid absent students scanning the QR Code image sent to them by their fellow students...

     

    Any ideas gratefully received !!

    Thanks again

  • Community Power Platform Member Profile Picture
    on 13 Dec 2019 at 17:33:55
    Re: attendance tracking via QR code

    This is possible. Could we see a sample QR code to help with the solution?

     

    I set up a sample QR code that returns this string:

    BEGIN:VCARD VERSION:3.0 N:Lott;Eric EMAIL:test@email.com END:VCARD

    And I used this formula to parse it into usable data: 

    Set(ExtractedName,Match(BarcodeScanner1.Value,"N:\w+;\w+",MatchOptions.Contains).FullMatch);
    Set(ExtractedFirstName,Last(Split(Right(ExtractedName,Len(ExtractedName)-2),";").Result).Result);
    Set(ExtractedLastName,First(Split(Right(ExtractedName,Len(ExtractedName)-2),";").Result).Result);
    Set(ExtractedEmail,Match(BarcodeScanner1.Value,"\w+@\w+.\w+",MatchOptions.Contains).FullMatch);
    ClearCollect(UserData,{FirstName:ExtractedFirstName,LastName:ExtractedLastName,Email:ExtractedEmail})
  • Community Power Platform Member Profile Picture
    on 13 Dec 2019 at 17:31:38
    Re: attendance tracking via QR code

    Deleted

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,670 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,011 Most Valuable Professional

Leaderboard
Loading started