Skip to main content

Notifications

Community site session details

Community site session details

Session Id : a+j2tRDaJHKSCH+WyNEXXI
Power Apps - Building Power Apps
Answered

Barcode attendance tracker with powerapps

Like (0) ShareShare
ReportReport
Posted on 4 Apr 2022 02:15:31 by 3

Hello,

 

I need a help to make attendance tracker with QR barcode scanner in powerapps. I need to solve following issues but I couldn't make it by myself, so I need your helps. 

1. The first time of scanning the barcode is arrival time and the last time of scanning barcode is departure time. To do that, how I can separate the records of both arrival time and departure time in sharepoint list in different column. 

2. I need to patch my records to sharepoint list without any button, which means need to create autostart barcode scanner. 

 

Thank you for your help. 

  • Verified answer
    v-jefferni Profile Picture
    on 07 Apr 2022 at 03:57:57
    Re: Barcode attendance tracker with powerapps

    Hi @Khulan ,

     

    Am not knowing of your list columns, so I assume you have at least four columns: Attendees, Date, Arrival time and Departure time. When a user first time using the App to scan the QR code in a day, App should update the user info along with the date, and save scan time to the arrival time column; when second time scan the QR code in the same day, App should look up the user info from the list and save departure time to the Departure time column.

     

    So, OnScan of Barcode Scanner could set to:

    If(
     IsBlank(
     LookUp(YourList, Attendees = User().DisplayName && Date = Today())
     ),
     Patch(
     YourList, 
     Defaults(YourList),
     {Attendees: User().DisplayName, Date: Today(), ArrivalTime: Now()}
     ),
     Patch(
     YourList, 
     LookUp(YourList, Attendees = User().DisplayName && Date = Today()),
     {DepartureTime: Now()}
     )
    )

     

    One point you need to note is, on the first time scanning in a day to prevent a second false scan, it's best to let the app navigate to another screen and inform the user a successful scan and the result. Otherwise, if someone scan twice quickly, they will get both arrival time and leave time populated to the list.

     

    Hope this helps.

     

    Best regards,

    Community Support Team _ Jeffer Ni
    If this post helps, then please consider Accept it as the solution to help the other members find it.

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!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,743 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,089 Most Valuable Professional

Leaderboard
Loading started