attendance tracking via QR code

(1) Share

Report

Posted on by Englishweb

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!

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (0)

Community Power Pla... on at

Like (0)

Report

Deleted

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Deleted

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
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})

Was this reply helpful? Yes No
Englishweb 371 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@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

Was this reply helpful? Yes No
Englishweb 371 on at

Like (0)

Report
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?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Englishweb 371 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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

Was this reply helpful? Yes No
flistergod 4 on at

Like (0)

Report

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 🙂

Was this reply helpful? Yes No