This was a great video Randy. Your approach is truly unique. I learned a lot of concepts I haven't seen anywhere else. Please keep the tutorials coming!
Hi Randy, this is my first time watching your video, it's awesome!! Also, you have solved one of my issue, I have created a booking app which prevent double booking (it works fine) but I want to recreate the app but avoid using "Edit Form", or use individual component, my issue was, I couldn't find the "Update Data Card", you have solved that issue, thank you! 👍👍
Thank you for sharing useful techniques and you showed clearly step to follow. I have followed your steps to create app for time attendance recording. However, I would like to keep the record and want to clear data on screen when recording is complete. Could you please advise how to do it?
Hey Randy it’s awesome 👏 I want to ask you one thing. It’s possible when we check-in or check out I want to get user's GPS location every time once user check in-out Please guide me on how I can do that.
Randy, Great App....I 'm trying to switch to a sql server table ? But now the times will not switch on the button when logging in etc? Should that make any difference. ?
Hi Randy, In our healthcare organization we have users that have overnight shifts. Is there any way we can edit that to reset itself based on a 16 hour hour time reset or something like that instead of by date?
Thank you so much for posting this, when I created the app though my clock in times for my buttons all defaulted to 12:00 am and I cant seem to get them to update correctly to the actual time. Also when I added the time change option it all works but it doesn't update the time on the main screen. From what I can tell all of my codes matches yours.
Great Video and explained very well. I was wondering would it be possible to add location restrictions, as to only allow to punch in and out if they are actually in a certain area range (office) ?
Thanks for this great work! I've modified your setup for this to create an order check in/ check out. I have inserted a timer that starts on the check in/ check out buttons, however, I am struggling to come up with a way to make the timer reset the button to allow a new record to be created OnTimerEnd. Any thoughts on this?
Hello randy I want to track the break timming at work but I don't have the activity type I want to capture 5 different types of break all in one column for on individual which had individual log in and log out time with their headers on the table please can you help me with this
Great video Randy! This helps me a lot. Do you happen to know if it is possible to reset the buttons immediately after the employee presses the Check Out button? and, if so, could you assist me with this one? Thank you for responding. Because some employees work night shifts.
Awesome!! Wish I saw this a week ago as we just complete building a time tracker app. In our app though we saved the times in one record as we need to calculate hours worked. How would you deal with preventing users from changing the time on their device to trick the now() function?
Marion- Not sure you can stop them from changing local time, but when information is written back to SharePoint, it will have a Created and Modified date for each new and modified record - that will be based on the system time, not the local time on the device. That might be usable in some way to catch dishonest folks.
@@randyhayes891 Yes. That we ended up doing. On App start we created a record in a SP list called TimeStamp and captured the created date and time then used that with a timer control to build an App clock from which to get the sign in/out times.
Thanks for the great video randy, in my scenario i have an app which makes the users to manually enter the hours ex:project hours,meeting hours,training hours,rework etc for a particular day, applying the concept in this video i dont have a unique activity type column in my list, the only thing that remains constant in my sharepoint list item would be the date, rest of all the other columns depend on the users entry, can you please guide me with this
Hey Randy. This is fantastic. Thank you. I'm trying adapt this to track temp employee's times utilizing a dropdown with the temps names to log the check in/out times. rather that the glbuser id. Any suggestions on where to begin with that.? I've created a separate list with temp names to populate the dropdown, however unsure how to adapt the response from that to act as your glbuser did on the Time Tracker list. Any advice would be greatly appreciated! ~Robert
Hi, can anyone assist me here, I am trying to get the "ShortTime" function to work here but it won't update on the buttons when its clicked. In the video it is from 28:30 Any help would be appreciated.
Can its possible to make changes check in and check should update in single row in share point list and also can we add location tracker of check in and check out
Sure thing. You would just need to add the additional columns to your list and then capture the information and store it from the app. As for flattening the data to one row, that would be possible, but would take a bit more work to pull off. If you would be adding in the location information, that may make it a little longer. But, all possible!
Nice video Randy! I tried to reproduce your solution and on button1 my "ThisItem.value" is recording in SharePoint the right date and time, but on "Text" keep displaying 12:00. Any ideas?
Make sure you have the correct formula as shown in the video for the Text property of the button. And, more importantly, make sure the Update property on the dynamic variable (the DataCard) is as shown in the video. If all other aspects are the same, should work well.
That’s amazing! Thanks a lot for the video , I’ve learned a lot. During the pandemic, many are working remotely and sometime at the office . What if we needed to add a location too? Does power apps capable of recording gps location, or maybe adding a location menu, as office, home, etc. Thanks a lot Randy🙏
I'm not entirely sure what you mean by clearing the times. Do you mean the ones that show up on the buttons? If so, it's not something that the app was built around. It was built with the concept of the individual user on the individual day. So clearing the times would be confusing in the context of this app. However, on the next day, all times are clear and ready to start over.
Excellent Randy just what I was after, I've added other fields from users 365 to record department etc in the sharepoint list after learning from your video. What method would be best to record perhaps in the finished time row the total hours for that day minus and lunch taken? Any chance of a small/short/video example on this?
Glad you liked it! I will put something like that on my schedule. In general though, you could just do a calculation on the final close and write that into the list.
Hi Randy I have come across your posts when digging for answers in google, but only today it happened to go through UA-cam channel. Pretty handy tricks to learn and appreciated. Let me reach out to you for your expertise on the matter please if you could spare a minute! I have 30 columns in a SP list and filter in a gallery Some columns do not have values after filter is applied. How can I get the columns with value to the gallery please Thanks 😊
Randy, Thank you for the content. I am new to PowerApps and hope you can point me in the right direction. When creating the first data card. I keep getting an error in the formula for the Text(Today(), "yyyymmdd"). It states that there is an error in the formula. Try and revise it. Also, when I create the labels in the gallery, no text appears in the label boxes. Am I missing something that would correct these issues? I really appreciate any assistance you can provide.
Hey, Need another video where user can select some drop down in another field and lunch in and lunch out related activities should be recorded as single record in SharePoint list
this video is great. howeverI may not probably able to catch you up as the code -- With({........ has got an error on ( -- it said that unexpected characters. the formula contains 'ParenClose' where 'CurlyOpen' is expected. and Characters are used in the formula in an unexpected way. I have no idea why it's diff from your video. Could you please advice?
Thank you. That was very helpful. I learned very much. I would appreciate it if you could help me with reporting each person every day in/lunch/out times in one row or export it to an Excel file!
I am looking for time tracker where user can put some comments and select value in drop down field and basis that value- start and end time need to be recorded along with lunch in lunch out
@@randyhayes891 my app only need SharePoint list having some drop down in activity type and then....start time and end time with pause and resume button
Great Video Randy, I am trying to replicate this app and I am following step by step, however, when I want to check in (around minute 24:13) I can't see the data on my sharepoint list, when I click on the error, the issue says: Title: Field "Title" is required, and in Location: Button1 OnSelect, any thoughts on how I can fix this, Thanks
Hello, I have a question, how do I make the filter see if the input record was made but the output record was not made on the same date i.e. one day later. Example: the check in was made at 8:15 AM (2022-08-25) but the check out is at 2:00 AM (2022-08-26). How to make the filter check if he checked out even if the day is different. I mention that because I have employee that check in at 10:00 PM (2022-08-25) and their check out time is 6:00 AM the next day (2022-08-26).
My "Lunch In" button keeps being enabled even when pressed. I am not sure where the error is. {display:"Lunch In", value:data.LunchIn, enabled:!IsBlank(data.CheckIn) && !IsBlank(data.LunchOut) && IsBlank(data.CheckOut)}
I get a output like this 2/26/2021 6.41 PM but in your video you get just the time for the text in the button. what am i doing wrong here? much appreciate if you can help me on this ***On Select Property*** If(ThisItem.display = Self.Text && ThisItem.enabled, Patch('Attendance Tracker', Defaults('Attendance Tracker'), {Title: glbUser, ActivityType: ThisItem.display, ActivityDateTime: Text(Now(), "[$-en-US]yyyymmddhhmm"), ActivityDate:Now() } ) ) ***Text Property**** Coalesce(Text(ThisItem.value, ShortTime), ThisItem.display)
The video was great but after following all the steps, still got some error with the formula, specially in setting the "Button". Your response is highly appreciated.
The glbUser variable is only set in one place - the OnStart and it should be set to Lower(User().Email) Make sure you have it in your OnStart and that you have run the OnStart
It took me a couple of hours, but as a complete PowerApps beginner, I could follow along because your explanations were so clear. Thank you!
You are the best🤩, i have used this approch to track delivery timestamps, you are the best Randy.
This was a great video Randy. Your approach is truly unique. I learned a lot of concepts I haven't seen anywhere else. Please keep the tutorials coming!
Awesome, thank you!
TY Randy! Great videos and very informative and entertaining. Nice work Sir!
Randy, I just discovered your site and this app is amazing. Thank you.
Hi Randy, this is my first time watching your video, it's awesome!! Also, you have solved one of my issue, I have created a booking app which prevent double booking (it works fine) but I want to recreate the app but avoid using "Edit Form", or use individual component, my issue was, I couldn't find the "Update Data Card", you have solved that issue, thank you! 👍👍
Thanks Randy for this beautiful tutorial. Please keep posting this sorts of tutorial
More to come for sure!
I actually created a useful attendance app using your video as my guide. Thank you so much for this helpful video. 👍👍👍👍👍👍
Clever! That data card update trick is pretty interesting.
I've got an upcoming video just on that topic!
Great Video! Thank you for explaining it so thoroughly and taking the time to create it.
Thank you for sharing useful techniques and you showed clearly step to follow. I have followed your steps to create app for time attendance recording. However, I would like to keep the record and want to clear data on screen when recording is complete. Could you please advise how to do it?
Hey Randy it’s awesome 👏 I want to ask you one thing.
It’s possible when we check-in or check out I want to get user's GPS location every time once user check in-out
Please guide me on how I can do that.
Hi Randy, Great content!!! I am having some issues with the Coalesce and ShortTime function at the 28 minute mark. Am I missing something here?
Excellent Videos, it will be nice to see how to intergrate location list as home office, office, ..
Randy, Great App....I 'm trying to switch to a sql server table ? But now the times will not switch on the button when logging in etc? Should that make any difference. ?
This is brilliant - exactly what I needed. Thanks very much!
Glad it helped!
Hi Randy,
In our healthcare organization we have users that have overnight shifts. Is there any way we can edit that to reset itself based on a 16 hour hour time reset or something like that instead of by date?
Thank you so much for posting this, when I created the app though my clock in times for my buttons all defaulted to 12:00 am and I cant seem to get them to update correctly to the actual time. Also when I added the time change option it all works but it doesn't update the time on the main screen. From what I can tell all of my codes matches yours.
Great Video and explained very well.
I was wondering would it be possible to add location restrictions, as to only allow to punch in and out if they are actually in a certain area range (office) ?
Thanks for the amazing work
I have one question
When I enter the value it’s not appearing on the button ?
Can you help please
Thanks for this great work! I've modified your setup for this to create an order check in/ check out. I have inserted a timer that starts on the check in/ check out buttons, however, I am struggling to come up with a way to make the timer reset the button to allow a new record to be created OnTimerEnd. Any thoughts on this?
Hello randy I want to track the break timming at work but I don't have the activity type I want to capture 5 different types of break all in one column for on individual which had individual log in and log out time with their headers on the table please can you help me with this
Hi Randy, if i decide to do a lookup separate for each button which property should I use to achieve the exact same output??
Great video Randy! This helps me a lot. Do you happen to know if it is possible to reset the buttons immediately after the employee presses the Check Out button? and, if so, could you assist me with this one? Thank you for responding. Because some employees work night shifts.
Awesome!! Wish I saw this a week ago as we just complete building a time tracker app.
In our app though we saved the times in one record as we need to calculate hours worked.
How would you deal with preventing users from changing the time on their device to trick the now() function?
Marion- Not sure you can stop them from changing local time, but when information is written back to SharePoint, it will have a Created and Modified date for each new and modified record - that will be based on the system time, not the local time on the device. That might be usable in some way to catch dishonest folks.
@@randyhayes891 Yes. That we ended up doing. On App start we created a record in a SP list called TimeStamp and captured the created date and time then used that with a timer control to build an App clock from which to get the sign in/out times.
Awesome little trick! I like it!
Thanks for the great video randy, in my scenario i have an app which makes the users to manually enter the hours ex:project hours,meeting hours,training hours,rework etc for a particular day, applying the concept in this video i dont have a unique activity type column in my list, the only thing that remains constant in my sharepoint list item would be the date, rest of all the other columns depend on the users entry, can you please guide me with this
Hey Randy. This is fantastic. Thank you. I'm trying adapt this to track temp employee's times utilizing a dropdown with the temps names to log the check in/out times. rather that the glbuser id. Any suggestions on where to begin with that.? I've created a separate list with temp names to populate the dropdown, however unsure how to adapt the response from that to act as your glbuser did on the Time Tracker list. Any advice would be greatly appreciated! ~Robert
Keka Lite Version! Great concept Sir.
This was a nice tutorial but i have a question how to calculate the total login hrs and break hours as a supervisor using this approach.
Hi, can anyone assist me here, I am trying to get the "ShortTime" function to work here but it won't update on the buttons when its clicked. In the video it is from 28:30
Any help would be appreciated.
Can its possible to make changes check in and check should update in single row in share point list and also can we add location tracker of check in and check out
Sure thing. You would just need to add the additional columns to your list and then capture the information and store it from the app. As for flattening the data to one row, that would be possible, but would take a bit more work to pull off. If you would be adding in the location information, that may make it a little longer. But, all possible!
Nice video Randy! I tried to reproduce your solution and on button1 my "ThisItem.value" is recording in SharePoint the right date and time, but on "Text" keep displaying 12:00. Any ideas?
Make sure you have the correct formula as shown in the video for the Text property of the button. And, more importantly, make sure the Update property on the dynamic variable (the DataCard) is as shown in the video. If all other aspects are the same, should work well.
26:10
Great video. Do you have a Timesheet entry app example where users enter time against a client/Project and a timer option?
I'm looking for this as well. Did you find anything?
That’s amazing! Thanks a lot for the video , I’ve learned a lot.
During the pandemic, many are working remotely and sometime at the office .
What if we needed to add a location too?
Does power apps capable of recording gps location, or maybe adding a location menu, as office, home, etc.
Thanks a lot Randy🙏
This is an amazing video. I really like it, and I learned a lot from it. Thank you.
Hi! How do you just clear the time values on the app? I don't want to delete the records in my SharePoint List.
I'm not entirely sure what you mean by clearing the times. Do you mean the ones that show up on the buttons? If so, it's not something that the app was built around. It was built with the concept of the individual user on the individual day. So clearing the times would be confusing in the context of this app. However, on the next day, all times are clear and ready to start over.
@@randyhayes891 yeah, the one that shows up on the buttons. I see, that will do. Thank you so much! Your video is really helpful.
Excellent Randy just what I was after, I've added other fields from users 365 to record department etc in the sharepoint list after learning from your video. What method would be best to record perhaps in the finished time row the total hours for that day minus and lunch taken? Any chance of a small/short/video example on this?
Glad you liked it! I will put something like that on my schedule. In general though, you could just do a calculation on the final close and write that into the list.
Hi Randy
I have come across your posts when digging for answers in google, but only today it happened to go through UA-cam channel.
Pretty handy tricks to learn and appreciated.
Let me reach out to you for your expertise on the matter please if you could spare a minute!
I have 30 columns in a SP list and filter in a gallery
Some columns do not have values after filter is applied.
How can I get the columns with value to the gallery please
Thanks 😊
Randy, Thank you for the content. I am new to PowerApps and hope you can point me in the right direction. When creating the first data card. I keep getting an error in the formula for the Text(Today(), "yyyymmdd"). It states that there is an error in the formula. Try and revise it. Also, when I create the labels in the gallery, no text appears in the label boxes. Am I missing something that would correct these issues? I really appreciate any assistance you can provide.
Network error when using Patch function: Field 'cr273_name is required.
why error and how solve
many thanks for your knowledge
Hey,
Need another video where user can select some drop down in another field and lunch in and lunch out related activities should be recorded as single record in SharePoint list
I'm a little backlogged on videos and time, but I will put the concept on my list.
I would also love to see this!
this video is great. howeverI may not probably able to catch you up as the code -- With({........ has got an error on ( -- it said that unexpected characters. the formula contains 'ParenClose' where 'CurlyOpen' is expected. and Characters are used in the formula in an unexpected way. I have no idea why it's diff from your video. Could you please advice?
Check to make sure you have matching opening and closing parens and curly brackets. From that error, sounds like one is missing.
Thank you. That was very helpful. I learned very much. I would appreciate it if you could help me with reporting each person every day in/lunch/out times in one row or export it to an Excel file!
how can i add location choice column for each checkin checkout ?
can you please help ? i get RUNTIME error when i click on the first buttom .thanks
When the minute in which it was registered passes, it allows me to dial again, as I solve it for the whole day
Can you add more: Employeer Name and email?
I am looking for time tracker where user can put some comments and select value in drop down field and basis that value- start and end time need to be recorded along with lunch in lunch out
You could certainly adapt this solution to that need. It would require some logic changes, but not impossible to do.
@@randyhayes891 please share your email Id...I can share my requirement in detail....
@@randyhayes891 my app only need SharePoint list having some drop down in activity type and then....start time and end time with pause and resume button
Expected number value error when i make the With ({lclRecs .. Kindly advice,
Excelente video 👏🏿👏🏿👏🏿👏🏿 me funciono al 100 genial
Great Video Randy, I am trying to replicate this app and I am following step by step, however, when I want to check in (around minute 24:13) I can't see the data on my sharepoint list, when I click on the error, the issue says: Title: Field "Title" is required, and in Location: Button1
OnSelect, any thoughts on how I can fix this, Thanks
Hello. Were you able to resolve this error?
You need to click on App/three dots(...)/ Run OnStart
then you try to do the process again
Hello, I have a question, how do I make the filter see if the input record was made but the output record was not made on the same date i.e. one day later. Example: the check in was made at 8:15 AM (2022-08-25) but the check out is at 2:00 AM (2022-08-26).
How to make the filter check if he checked out even if the day is different. I mention that because I have employee that check in at 10:00 PM (2022-08-25) and their check out time is 6:00 AM the next day (2022-08-26).
looking for the same thing, did you find an answer to this @rikalva?
@@princessminstrel111 No.
My "Lunch In" button keeps being enabled even when pressed. I am not sure where the error is.
{display:"Lunch In", value:data.LunchIn, enabled:!IsBlank(data.CheckIn) && !IsBlank(data.LunchOut) && IsBlank(data.CheckOut)}
found it :)
Great video! I was very happy to see this and follow along. Thank you!!
I get a output like this 2/26/2021 6.41 PM but in your video you get just the time for the text in the button. what am i doing wrong here? much appreciate if you can help me on this
***On Select Property***
If(ThisItem.display = Self.Text && ThisItem.enabled,
Patch('Attendance Tracker', Defaults('Attendance Tracker'),
{Title: glbUser,
ActivityType: ThisItem.display,
ActivityDateTime: Text(Now(), "[$-en-US]yyyymmddhhmm"), ActivityDate:Now()
}
)
)
***Text Property****
Coalesce(Text(ThisItem.value, ShortTime), ThisItem.display)
Found the solution. Thanks
Coalesce(Text(DateTimeValue(ThisItem.value),ShortTime), ThisItem.display)
Glad you uncovered it!
The video was great but after following all the steps, still got some error with the formula, specially in setting the "Button". Your response is highly appreciated.
Same thing here. Can't get any way to fix and pass that.
That's a tutorial. It doesn't get any better than this and the potential has been fully exploited. Can I have some more, please!
The tricky bit will be to use this model as fire roster and alert if someone is in the building.
I believe a good filter on the list should give you what you need.
glbuser= power apps encountered an internal error trying to evaluate this expression
Please help me on above error
The glbUser variable is only set in one place - the OnStart and it should be set to Lower(User().Email)
Make sure you have it in your OnStart and that you have run the OnStart
@@randyhayes891 Thanks Got it
Is there other alternative..I am still getting the error for glbUser..I defined this variable at the start
@@TheZoZoO Check your OnStart formula. It should have the following: Set(glbUser, Lower(User().Email))
Is that giving you some error?
I am getting an error in Thisitem.value.Any suggestion would be highly appreciated
do you find any solution to that?