PowerApps Time Tracking

[@mentaljuvenile]

I could have done with this video last year. I was asked to try and make a pilot app that logged ferry, productive and duty time. It took me a while to come up with this method. I'm glad I ended up with a solution similar to yours.

[@Shellbell292]

Hi Shane, another great video which has allowed me to gain more Power Apps experience 👏🏻

[@davidmckenzie1889]

You could have the 'timer' bit working when you exit and restart the app by having the timer on repeat and setting a variable OnTimerEnd to Now - WhenStarted and using this variable rather than the timer value. Start the timer on app start and have a 1 second duration (or 2 seconds, 5 seconds or whatever). David

[@ShanesCows]

Interesting idea David. Thanks for sharing. 😀

[@robertvanraamsdonk4381]

@@ShanesCows David's method is solid. Used that mechanism on a customer time tracking app last year, timer set to 1 sec cycle on repeat, app displaying the time difference between TimerStart variable and Now() variable, with the Now() variable being updated every 1-second timer cycle OnTimerEnd. Works like a charm.

[@sannsor8799]

Amazing explanation. Thank you

[@ShanesCows]

You are very welcome!

[@Toto-pw4tw]

Hi Shane! Could you make an app on tracking daily attendance?

[@ShanesCows]

I will add it to the list to consider. :)

[@ramsree20]

Hi Shane, thanks for your video! Is there a way to track PC idle time (no key strokes or mouse click time) in power apps? Please suggest

[@ShanesCows]

Not that I know of.

[@mardithpascua8112]

HI Shane, I do have Time Logs Tracker with Start and Stop button, it saves record to SharePoint. However, for some users in different country - when they save to SharePoint it is showing different year and some date has SA or CH. I am patching the Now() to SharePoint list.

[@felipeabajo]

This is wonderful. Thanks a lot Shane

[@ShanesCows]

Happy to help

[@tahamid03]

Shane you are a Rock STARR. I learned almost everything from you. I implement this solution to one of my use case. But the issue that i am having that when someone start the timer that person only can go and stop the timer. Is it possible that other user also can go stop the timer. Thank you so much for your help.

[@ShanesCows]

Not possible. That is why I wouldn't start a timer. I would record Now() when they start and then have an end button that records Now() when they stop. So you can calculate the time.

[@GrahamParker-c3u]

Hi Shane, cool app. Have you got a video on calculating future dates. In my work place we start a production run that runs for example 265hrs, I would like to make an app that the user enters the start date and time and the run hours and the app works out what the end date and time will be.

[@ShanesCows]

This video might help kzbin.info/www/bejne/fJPHeH-MeNuaiNE Long story short I would be using DateAdd(Now(), 265, Hours) and you would get 265 from now. You will then need to replace Now() with the selected time.

[@GrahamParker-c3u]

@@ShanesCows Thanks Shane 👍

[@genovjillella3602]

Great video Shane, How would you add a pause button to this app.

[@ShanesCows]

Think of it as stop and start again is my first idea.

[@sabrinaksy]

Hi Shane! Could you make an app showing a live clock?

[@ShanesCows]

Hi Sabrina. I have never actually done that. I will add it to my list to think about. Thanks

[@michellekosek]

when the data is sent to sharepoint, it is roudning up to the nearest minute - i need seconds since most our tasks are less than a minute long. how would i accomplish this?

[@ShanesCows]

Store the time as Text instead of as a number since SP will not keep the seconds. :) Use Text function to turn number into Text. Use Value function to turn text number back into a number number. :)

[@epiccipe3061]

Can we add a dashboard for the user names and total time used in a day if yes then how?

[@ShanesCows]

Maybe use something like this video to build the dashboard? kzbin.info/www/bejne/jYepn3aOrbpjpcU

[@ebimonws6521]

Hi Shane- I need a track active screen work time. Can you please help me with your suggestions

[@vikasumapathy5056]

Hi Shane, as you know working from home we are using teams for meetings and calls more often than not, is there way I can auto track my call and meeting time using powerapps or flows??

[@ShanesCows]

Not that I know of. 😐 Would be cool though.

[@markperrah186]

In teams you can add apps and pin them. Add power apps and add this timer app or one like it, then start and stop from inside teams. i made one for my check, lunch out, lunch in, check out times. and has a history gallery showing 1 week at a time, (with Shanes help of course)

[@ravitutika1204]

Hey Shane your playlist for Power Apps is ordered ? can i start one by one if am beginner

[@ShanesCows]

Best to get you going is to watch training.powerapps911.com where I have a free intro class. My playlist is not ordered. 😑

[@APBITEMS]

Hello Shane, thanks for this awesome video! I have a very specific question and I hope I can get some insight and help from you if possible! Our company has a manual-entry form that I made in Power Apps , and recently we wanted to optimize it and track the time for how long a specific task is completed in. Our app consists of multiple buttons , so I tried putting some patch function into our button that enables a user to enter a new form( its a button that puts out an empty form and also starts a timer on the screen), but I cant get the data from the form itself ( so the data the user needs to fill in) , I just get a new blank record in my sharepoint list with a start time and when I press submit, with the end time and the time spent as the difference between the two. My main goal is to collect the data in the form ,as well as get the time difference between the start and the end time of the task into the sharepoint list (calculating the time spend). Is there a possible and an easy fix for this kind of problem? Looking forward to more videos like this!

[@Shyavasva]

Shane I asked for some info in the contact form in your website a few days back but have got no response.

[@ShanesCows]

Hmm. Reply to the email you got back and I will try to help

[@ChBharath-qy3cl]

How to calculate end time if powerapps app is idle for one hour.

[@ShanesCows]

Have the app log while they are active. Not sure you can trigger anythign when they are not active.

[@RanmaSaotome666]

Shane your are LEGENDARRRRRY :D I'm laughing since the point, that you will use IOT power plugs and this to turn off your kids monitor :D :D :D Sincerly, i'll bring it up next time a customer asks me "why is powerplatform good" :D... Fantastic use case, explanation and videon as usual ;) BTW also the MYMbas was great!

[@ShanesCows]

I do what I can. 😂

[@asimrehan73]

Hi Shane, thats a very nice setup that can be used in many time tracking scenarios. My issue is ; the time reference for the app is the time set on the device being used. There should be way to capture standard/correct time. Or else kids will change the time settings on their phone and falsely capture less time spent on games. 😅

[@ShanesCows]

You could create a record in SHarePoint. The Created By time of the record would be a standard time your kids couldn't mess with. 😀

[@asimrehan73]

@@ShanesCows my kids are smarter then me, they will find a way 😅. Once again, thanks for a well explained video.

[@epiccipe3061]

where can I download this app?

[@ShanesCows]

Subscribe here training.powerapps911.com/courses/video-library

[@hajiebaguio9143]

Hi sir. Can help me how make machine down tracker?

[@ShanesCows]

Power Apps cannot watch for something to go down. Maybe you could do it with flow? I am not sure, never treid to make a down tracker.

[@hajiebaguio9143]

@@ShanesCows thanks

[@hajiebaguio9143]

Or machine downtime log and see the dashboard colorcoding with comments.

[@hevj27]

Hi Shane, your videos have been very helpful. I've been learning power apps and been encountering weird issue. I often get this error message when trying to edit an app: "Change Power Apps Version, Something happened to the power apps version you were using." Could you help me with this? Thanks a lot!

[@vickymishra3520]

Hii Shane,plz make video on get and post Api

[@ShanesCows]

Like this one? kzbin.info/www/bejne/nX3Lo3uuq7B1mqs

[@GregNow]

Ok, so there is quite few accounting software solutions that have a kiosk where I can track log in log-out to the shop by employees, but I am looking for solutions that work on small building sites. I want to have log in and Log out times of workers. Perhaps one screen in the app that I can see who is on the job site at a given time and what are the attributes of that worker and maybe if they received induction or so I know that we have a fire marshal, first aider etc., perhaps the person who received training in access platform assembly or simply a visitor like an architect. I guess this would have to be pulled out from some data source (list?!) Also, in case of fire, I can see who is at the assembly point and how many people logged in to the site that day. So maybe one screen with lig i. Log out and a current number of people on site. Perhaps they can use QR code cards so it's easy to enter all that info and keep log of it After having this information, I would like to be able to pull out that data to create weekly time sheets per worker. And who knows, maybe use power automation to let them know their hours on Fridays with some report or keep track of project hours. It feels like the benefits can be endless How difficult is it to do that?

[@iyengar007]

Wonderful... Loved it very much., Now my second request (working PowerApps in Offline/Online). I'm still waiting for 1st request. If you don't remember; I can type again. XOXO

[@ShanesCows]

Here is offline video kzbin.info/www/bejne/hKjFopd3bs9re80

[@vickymishra3520]

Yes