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

[v-xida-msft]

Hi @azzamnizam,

If you want to save the Note/Remark text into your SP list, please modify the formula within the OnSelect proeprty of the "Check In" button as below:

Set(
     CurrentCheckedInRecord,
     Patch(
       'YourSPList',    
        Defaults('YourSPList'),
        {
          Title: "Check In&Out Test",
          StaffName: User().FullName,
          StaffEmail: User().Email,
          Check_x0020_In: Now(),
          Remark: TextInput1.Text    /* <-- Add formula here. Remark represents the column in your SP list to store your Notes/Remarks. TextInput1 represents the Text Input control within your app*/
        }
    )
);
Navigate(CheckInSuccessScreen,ScreenTransition.Cover)

If you have solved your problem, please go ahead and click “Accept as Solution” so that this thread will be marked for other users to easily identify.

Best regards,

Kris

[azzamnizam]

yes sure after all problem encounterd.... but the new problem I discoverd is....after I check in....I end the program task or end the task.... the check out data cannot be stored....how do I make the sessions last until I press the check out button pressed.. my concern is how if the user phone restart or no battery phone off....the cache data will lost and cant be check out

@v-xida-msft

rgd

AzzamNizam

[v-xida-msft]

Hi @azzamnizam,

Do you want to cache your Check In record into your local device?

If you want to cache your Check In record into your local device, I think the SaveData function and LoadData function could achieve your needs.

Please check and see if the following blog would help in your scenario:

https://powerapps.microsoft.com/en-us/blog/build-offline-apps-with-new-powerapps-capabilities/

On your side, you should take a try with the following workaround:

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

ClearCollect(                                /* <-- Save Check In record into a Collection */
     CurrentCheckedInRecord,
     Patch(
       'YourSPList',    
        Defaults('YourSPList'),
        {
          Title: "Check In&Out Test",
          StaffName: User().FullName,
          StaffEmail: User().Email,
          Check_x0020_In: Now(),
          Remark: TextInput1.Text    /* <-- Add formula here. Remark represents the column in your SP list to store your Notes/Remarks. TextInput1 represents the Text Input control within your app*/
        }
    )
);
SaveData(CurrentCheckedInRecord, "CachedData")    /* <-- Add formula here */
Navigate(CheckInSuccessScreen,ScreenTransition.Cover)

Set the OnStart or OnVisible property of the first screen of your app to following:

LoadData(CurrentCheckedInRecord, "CachedData")

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 ,

Other storage than local device where else can store the cache data ?? Is there possible to store in cloud or any SP list ???

 and if I store in local device means store in user phone ?? then what happen to the data after checkout button press ? the data still in the local device or has been released ?

[ShehanPeiris]

Hi Team,

Your solution helped me a lot to create a check in and check out app. 

I have created SP list and successfully passed check in time and check out time.

but I need different scenario of this.

I want to place a mobile near to entrance and need to scan the QR code. each staff member will give a unique QR code containing a unique e-mail.

when he/she is check-in, I'm going to scan his/her QR code and do the check-in. after few people check-in, how to check-out 1st or 2nd checked-in user. (any solution to track using email and check-out)

Appreciate your support...

[Poweruser_11]

Hi v-xida-msft

Thank you for sharing the solution.

when i am trying to implement this solution , there is no data in SP list while i click on the check in and check out button. Secondly, i am receiving an error on Check In button as shown in the image.

Please help me with this issue.

I am trying to create an app for employee daily attendance system along with PTO(Paid Time Off- where employee able to check their available leave and request a leave like Leave->Request Template available in PowerApp)Check in button errorSP list

[azzamnizam]

Dear @v-xida-msft ,

hi there how are you its been awhile I'm using it, need your assistance if I want to replace the textinput box to become radio button with specific list, do I need to change the code? or just link the sharepoint storage to radio button in order the data will goes in to sharepoint ? hope for your swift response thank you 🙂

warm regard 

Azzam Nizam

[azzamnizam]

@v-xida-msft 

after i change to radiobutton, its become error. Need fast help.

 Thank you,

Azzam Nizam

[WarrenBelz]

Hi @azzamnizam ,

The value for a radio button should be Radio1.Selected.xxxx

Where xxxx is

1. Value if the items are from a choice field
2. Result if from a Distinct filter
3. FieldName (actual field name) if filtered to display this

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[rafaelbenicio]

Hi Azzam, Did you get this app working?

Can you please share your check-out "on select" code? My data can't still be stored after the first line. 

Thank you,