Attendance System for check in & check out

[azzamnizam]

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

[azzamnizam]

need help for this issue !!!

[v-xida-msft]

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:

App's configuration as below:

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:

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:

Best regards,

Kris

[azzamnizam]

@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]

Check InCheck OutThere is an error at Check In and Check Out button how to solve it ?

@v-xida-msft

[azzamnizam]

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

Checkout collumn

[azzamnizam]

Notes/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]

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

Kindly appreciate you response

[v-xida-msft]

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

[azzamnizam]

dear @v-xida-msft

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

Best regards,

AzzamNizam