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

[WarrenBelz]

@Benmo33 ,

Thanks for the tag. Due to timezone (7:00am Wednesday) responding now.

@rafaelbenicio is correct - Location.Latitude/Longitude will do the job for you.

[Abhilash]

i'm also using same formulas but whenever application refreshed only checkin button is visible.... even previously he was out logged out also..any idea about that?

[Abhilash]

I'm also using same application but i'm not getting.. What if i check-in with one device and check out in other device? please reply as soon as possible.. 

[Abhilash]

I Used same formulas but i'm getting error in patch....can you tell me what is the problem? you can refer code i placed below..

Attendance is my sp list name CurrentCheckedInRecord is my collection name

Refresh(Attendance);

If(

!IsBlank(CurrentCheckedInRecord),

    Patch(

      Attendance,

       CurrentCheckedInRecord,

       {

         Checkout: Now(),CheckoutReason:chkoutreason.Selected

       }

     )

);

[WarrenBelz]

@Abhilash ,

I am a little lost in the logic of the post - can you please explain exactly what you are trying to do.

Refresh(Attendance);
If(
   !IsBlank(CurrentCheckedInRecord),     //If collection is blank??
   Patch(                                
      Attendance,
      CurrentCheckedInRecord,            //This will not work - ThisItem??
      {
         Checkout: Now(),
         CheckoutReason:chkoutreason.Selected      //this is a table - needs .Selected.xxxx
      }
   )
)

[Taylor28]

Hi,

Im experiencing the same dilemma. When closing the app or task the check in button doesn't populate on Sharepoint. I tried the workaround but keep receiving this error message on the check out button "Invalid Argument Type(Table).Expecting a Record Value Instead". I'm completely puzzled and not sure how to fix. Attached is the code for the Check Out button. Any help would be greatly appreciated thank you!

[WarrenBelz]

@Taylor28 @Abhilash @Benmo33 ,

I was tagged with a question on Location, which I have answered.

This is an old thread and it is becoming a party and will completely confuse people as to who is answering who.

Can everyone please create new threads with their individual questions

[alakhani]

Dear #rafaelbenicio

I am making a Attendance record based on Geo Location and I am taking help from your codes.

The code is giving error and I thought because of these two lines? Can you kindly explain these 2 labels?

FALATLabel.Text and DeviceLatLabel.Text

Abs(Value(FALatLabel.Text)- Value(DeviceLatLabel.Text)) <= 0.0005000
    && 
    Abs(Value(FALongLabel.Text) - Value(DeviceLogLabel.Text)) <= 0.0005000,

What is the difference between these two Latitude and Longitude Labels and kindly if you can share the codes of these two labels please. Would really appreciate.

[Anonymous]

Hi @v-xida-msft ,

Thanks for sharing this solution. I am new to powerapps and looking for some quick help. I do not find visible property for the button "Admin monitor"..i could only find the onselect. on the search bar within advanced properties of the button when i searched for visible and entered the function, the button became invisible.

Can you please suggest.

Thanks.

[rafaelbenicio]

Hi @alakhani ,

I would be happy to assist you. A simple answer is that I am running some calculations between the Final destination and device destination. Just to make sure the person is at the final location. Does it make sense? 

FALatLabel and FALongLabel are my final destination source. I collected the geolocation from google and I included the information on those labels as a value. In addition to that, I used Location.Latitude and Location.Longitude expression for DeviceLatLabel and DeviceLogLabel. 

Please let me know if you still have any questions.