PowerApps Time Tracking
HTML-код
- Опубликовано: 9 июн 2021
- Learn how to build a Power App Time Tracker app. Video covers starting and stopping the tracking, summary of time, time calculations, and a bunch of other littler things to help you build apps for tracking tasks and activities in your business.
Power Apps Consulting and training at www.PowerApps911.com 
Наука
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.
Hi Shane, another great video which has allowed me to gain more Power Apps experience 👏🏻
This is wonderful. Thanks a lot Shane
Happy to help
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!
I do what I can. 😂
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!
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!
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.
Hi Shane- I need a track active screen work time. Can you please help me with your suggestions
Great video Shane, How would you add a pause button to this app.
Think of it as stop and start again is my first idea.
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.
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.
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. 😅
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. 😀
@@ShanesCows my kids are smarter then me, they will find a way 😅.
Once again, thanks for a well explained video.
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
Not that I know of.
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
Interesting idea David. Thanks for sharing. 😀
@@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.
Hi Shane!
Could you make an app on tracking daily attendance?
I will add it to the list to consider. :)
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.
This video might help ruclips.net/video/FbdGLVCvgRo/видео.html 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.
@@ShanesCows Thanks Shane 👍
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??
Not that I know of. 😐 Would be cool though.
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)
Hey Shane your playlist for Power Apps is ordered ? can i start one by one if am beginner
Best to get you going is to watch training.powerapps911.com where I have a free intro class. My playlist is not ordered. 😑
Hi Shane!
Could you make an app showing a live clock?
Hi Sabrina. I have never actually done that. I will add it to my list to think about. Thanks
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?
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. :)
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
Here is offline video ruclips.net/video/NwbqdA9j8Ek/видео.html
Yes
Can we add a dashboard for the user names and total time used in a day if yes then how?
Maybe use something like this video to build the dashboard? ruclips.net/video/WVFnCXxU0oc/видео.html
Shane I asked for some info in the contact form in your website a few days back but have got no response.
Hmm. Reply to the email you got back and I will try to help
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?
How to calculate end time if powerapps app is idle for one hour.
Have the app log while they are active. Not sure you can trigger anythign when they are not active.
Hii Shane,plz make video on get and post Api
Like this one? ruclips.net/video/gLhrHxvKBdI/видео.html
where can I download this app?
Subscribe here training.powerapps911.com/courses/video-library
Hi sir. Can help me how make machine down tracker?
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.
@@ShanesCows thanks
Or machine downtime log and see the dashboard colorcoding with comments.