cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
azzamnizam
Level: Powered On

Attendance System for check in & check out

Dear All PowerApps Dev.

I am looking for someone can help me to build an attendance system using PowerApps, I'm really need help for this apps that will make all progress run smoothly.
Function Required:-

  • Have a list all staff,
  • Every morning each staff will click check in to represent the staff arrive in certain time and date, when time to go back the staff will check out in certain time and date,
  • Every thing need to be recorded,
  • For staff with no check in and check out for that day means the staff was absense,
  • Admin can monitor all staff IN and OUT everyday.

 

Thank You

AzzamNizam

15 REPLIES 15
azzamnizam
Level: Powered On

Re: Attendance System for check in & check out

need help for this issue !!!

Community Support Team
Community Support Team

Re: Attendance System for check in & check out

Hi @azzamnizam,

Do you want to create a Attendance system for Check in & Check out using PowerApps?

Could you please share more details about your Staff List?

Based on the needs you provided, I think you could achieve your needs.

Firstly, you need to create another SP list (e.g. CheckInAndOut) to store the Check in and Check out records for each staff at current day. I have create a CheckInAndOut list as below:3.JPG

App's configuration as below:4.JPG

Set the OnVisible property of the first screen of my app to following:

 

Set(CurrentUserEmail, User().Email)

 

Within the first screen (MainScreen) of your my app, set the OnSelect property of the "Check In" button to following:

 

Patch(
'20181115_CheckInAndOut', /* <-- '20181115_CheckInAndOut' represents the SP list on my side, you should replace with your own list*/
Defaults('20181115_CheckInAndOut'),
{
Title: "Check In&Out Test",
StaffName: User().FullName,
StaffEmail: User().Email,
Check_x0020_In: Now()
}
); Navigate(CheckInSuccessScreen,ScreenTransition.Cover)

Set the OnSelect property of the "Check Out" button to following:

 

 

Refresh('20181115_CheckInAndOut');
If( !IsBlank(LookUp('20181115_CheckInAndOut',StaffEmail=CurrentUserEmail && Text(Created,"[$-en-US]mm/dd/yyyy")=Text(Now(),"[$-en-US]mm/dd/yyyy"))), /* <-- Created represents the System column in your SP list, here is used to check if current login user has checked in before already*/ Patch(
'20181115_CheckInAndOut',
LookUp('20181115_CheckInAndOut',StaffEmail=CurrentUserEmail && Text(Created,"[$-en-US]mm/dd/yyyy")=Text(Now(),"[$-en-US]mm/dd/yyyy")),
{
Check_x0020_Out: Now()
}
) ); Navigate(CheckOutSuccessScreen,ScreenTransition.Cover)

The GIF screenshot as below:

Test1.gif

 

Set the Visible property of the "Admin Monitor" button to following:

 

If(CurrentUserEmail="The email address of the Admin",true,false)

Set the OnSelect property of the "Admin Monitor" button to following:

 

Navigate(AllCheckInAndOutRecords,ScreenTransition.Cover)

Within the AllCheckInAndOutRecords screen, add a Data Table control, set the Items property of the Data Table control to your CheckInAndOut list:5.JPG

 

 

Best regards,

Kris

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
azzamnizam
Level: Powered On

Re: Attendance System for check in & check out

@v-xida-msft aka Kris

 

First of all I want to thank you for your smooth reply. Really appreciate it.

I'll provide you more detail in this progress to make this apps happen.

 

Firstly I'm our organisation have a microsoft lisence for this access, and currently we are have an outlook email.

So for the staff details I just want to save to database by name or email using User().FullName/ User().Email then the system will the catch the staff name or email.

The rest just Date and Time, check in and check out , last but not least notes/remarks column.

If possible under the check in and check out button have a text field for REMARKS that staff can state the resson in case the staff attend but need to assign to other area to do some work. If there is no outside work then the text field will left blank.

 

Hopefully you can continue assist me on this apps 🙂 

 

Warm regards,

AzzamNizam

azzamnizam
Level: Powered On

Re: Attendance System for check in & check out

1.pngCheck In2.pngCheck OutThere is an error at Check In and Check Out button how to solve it ?

@v-xida-msft

Highlighted
azzamnizam
Level: Powered On

Re: Attendance System for check in & check out

After alter the SP list name... The apps works but got a few problem on check out collumn because every time checkin...when check out not appear on next list only update on first row....... how to figure it out ?? @v-xida-msft 

Because need to check in and check out daily..

Really need your assist on this.... Thank you

3.pngCheckout collumn

azzamnizam
Level: Powered On

Re: Attendance System for check in & check out

5.pngNotes/RemarksI put oneTextInput for notes and remarks...Then what should I add on formula to make sure the item that fill in TextInput goes to SP list...I already added one collumn for Notes in SP

 

@v-xida-msft

azzamnizam
Level: Powered On

Re: Attendance System for check in & check out

UP!!!! Need Someone Help Me on this Issue....

 

Kindly appreciate you response

Community Support Team
Community Support Team

Re: Attendance System for check in & check out

Hi @azzamnizam,

Do you mean that one user could Check In and Check Out for more times every day?

The solution I provided for you is based on that one user could only Check In and Check Out for one time every day.

If one user could Check In and Check Out for more times every day, please take a try with the following workaround:

Set the OnSelect property of the "Check In" button to following formula:

Set(
     CurrentCheckedInRecord,
     Patch(
       'YourSPList',    
        Defaults('YourSPList'),
        {
          Title: "Check In&Out Test",
          StaffName: User().FullName,
          StaffEmail: User().Email,
          Check_x0020_In: Now()
        }
    )
);
Navigate(CheckInSuccessScreen,ScreenTransition.Cover)

Set the OnSelect property of the "Check Out" button to following:

Refresh('YourSPList');
If(
    !IsBlank(CurrentCheckedInRecord),
    Patch(
      'YourSPList',
       CurrentCheckedInRecord,
       {
         Check_x0020_Out: Now()
       }
     )
);
Navigate(CheckOutSuccessScreen,ScreenTransition.Cover)

Best regards,

Kris

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
azzamnizam
Level: Powered On

Re: Attendance System for check in & check out

dear @v-xida-msft

 

How about the Note/Remark textfield ??? how do I make it to save in SP list

 

Best regards,

AzzamNizam

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (4,555)