tracker

%3CLINGO-SUB%20id%3D%22lingo-sub-1217050%22%20slang%3D%22en-US%22%3Etracker%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1217050%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20create%20a%20timetracker%20but%20running%20into%20some%20problems.%26nbsp%3B%3C%2FP%3E%3CP%3EBusiness%20Requirement%20%3A%20when%20an%20employee%20comes%20to%20office%2C%20I%20want%20him%20to%20log%20his%20arrival%20time%20and%20when%20he%20leaves%2C%20i%20want%20him%20to%20log%20the%20exit%20time.%20This%20entry%20and%20exit%20will%20create%20list%20entries%20in%20sharepoint.%20The%20employee%20should%20initiate%20the%20flow%20from%20desktop%20and%20not%20mobile.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20I%20did%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20Create%20a%20list%20on%20sharepoint%20site%20with%20columns%20User%2C%20Event%20(arrival%2C%20exit)%20and%20Time%20(uk)%20time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhats%20the%20best%20way%20to%20capture%20the%20time%20automatically%20when%20an%20item%20is%20created.%20I%20don't%20want%20employees%20to%20type%20in%20their%20own%20time%20due%20to%20misuse%20of%20feature.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20where%20the%20difference%20between%20arrival%20and%20exit%20is%20calculated%20so%20I%20can%20get%20an%20idea%20of%20how%20many%20hours%20were%20logged%20by%20employees%20since%20we%20typically%20have%20per%20hour%20billing%20for%20some%20projects.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1217050%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ETracker%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1218094%22%20slang%3D%22en-US%22%3ERe%3A%20tracker%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1218094%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F577224%22%20target%3D%22_blank%22%3E%40witcher121%3C%2FA%3E%26nbsp%3BSharePoint%20automatically%20saves%20the%20date%20%26amp%3B%20time%20that%20each%20item%20was%20created%20in%20the%20Created%20column.%20And%20that%20cannot%20be%20changed.%20So%20in%20your%20view%20of%20the%20list%20make%20sure%20you%20are%20displaying%20the%20Created%20column%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%220a-SP-EditView.png%22%20style%3D%22width%3A%20925px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F175944i347D973FCA9AA43C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%220a-SP-EditView.png%22%20alt%3D%220a-SP-EditView.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%220-SP-list.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F175943i6696283D264AF19D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%220-SP-list.png%22%20alt%3D%220-SP-list.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20doing%20the%20calculations%20and%20submitting%20the%20timesheet%2C%20the%20way%20I%20do%20it%20is%20to%20have%20a%20customised%20PowerApps%20form%20(from%20the%20Power%20Apps%20link%20above%20the%20list).%20It%20knows%20who%20the%20logged%20in%20user%20is%20so%20they%20don't%20have%20to%20enter%20their%20name%20but%20do%20enter%20their%20starting%2C%20finishing%20and%20lunch%20times%20and%20their%20hourly%20rate.%20The%20form%20then%20calculates%20the%20total%20for%20the%20day%20and%20clicking%20Save%20adds%20it%20to%20the%20SharePoint%20list.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%221-customizedForm.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F175961i116CD707C22E6DE5%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%221-customizedForm.png%22%20alt%3D%221-customizedForm.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20you%20might%20not%20want%20the%20users%20to%20see%20the%20timesheet%20that%20others%20have%20submitted.%20So%20the%20app%20can%20be%20embedded%20on%20a%20page%20on%20this%20or%20another%20site%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%222-EmbeddedForm.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F175962iCD207EC9A5CAFFB5%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%222-EmbeddedForm.png%22%20alt%3D%222-EmbeddedForm.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBy%20having%20another%20screen%20on%20the%20app%20you%20could%20have%20a%20gallery%20that%20showed%20the%20user%20a%20list%20of%20the%20timesheets%20that%20they%20had%20submitted%20but%20they%20wouldn't%20see%20the%20timesheets%20of%20anyone%20else.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDo%20come%20back%20with%20any%20questions%20about%20this%20or%20you%20need%20more%20information%20about%20how%20it%20has%20been%20done.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%233366FF%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1221522%22%20slang%3D%22en-US%22%3ERe%3A%20tracker%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1221522%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40Rob%20Elliott%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20the%20inputs.%20This%20is%20helpful.%20The%20only%20thing%20which%20I%20dont%20want%20is%20the%20user%20selecting%20his%20own%20time.%26nbsp%3B%20could%20we%20in%20someway%20trigger%20the%20time%3F%20Some%20folks%20might%20misuse%20the%20forms%20and%20not%20put%20in%20right%20arrival%20time.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1221875%22%20slang%3D%22en-US%22%3ERe%3A%20tracker%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1221875%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F577224%22%20target%3D%22_blank%22%3E%40witcher121%3C%2FA%3E%26nbsp%3B%20with%20the%20created%20time%20you%20can%20select%20from%20the%20list%20settings%20whether%20to%20display%20the%20time%20as%20well%20as%20the%20date%20(as%20in%20my%20first%20screenshot)%20or%20not.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%222%22%20color%3D%22%233366FF%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I am trying to create a timetracker but running into some problems. 

Business Requirement : when an employee comes to office, I want him to log his arrival time and when he leaves, i want him to log the exit time. This entry and exit will create list entries in sharepoint. The employee should initiate the flow from desktop and not mobile. 

 

What I did 

1. Create a list on sharepoint site with columns User, Event (arrival, exit) and Time (uk) time.

 

Whats the best way to capture the time automatically when an item is created. I don't want employees to type in their own time due to misuse of feature. 

 

Is there a way where the difference between arrival and exit is calculated so I can get an idea of how many hours were logged by employees since we typically have per hour billing for some projects.

3 Replies

@witcher121 SharePoint automatically saves the date & time that each item was created in the Created column. And that cannot be changed. So in your view of the list make sure you are displaying the Created column:

0a-SP-EditView.png

 

0-SP-list.png

 

For doing the calculations and submitting the timesheet, the way I do it is to have a customised PowerApps form (from the Power Apps link above the list). It knows who the logged in user is so they don't have to enter their name but do enter their starting, finishing and lunch times and their hourly rate. The form then calculates the total for the day and clicking Save adds it to the SharePoint list.

 

1-customizedForm.png

 

But you might not want the users to see the timesheet that others have submitted. So the app can be embedded on a page on this or another site:

2-EmbeddedForm.png

 

By having another screen on the app you could have a gallery that showed the user a list of the timesheets that they had submitted but they wouldn't see the timesheets of anyone else.

 

Do come back with any questions about this or you need more information about how it has been done.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

Hi @RobElliott ,

 

Thanks for the inputs. This is helpful. The only thing which I dont want is the user selecting his own time.  could we in someway trigger the time? Some folks might misuse the forms and not put in right arrival time. 

@witcher121  with the created time you can select from the list settings whether to display the time as well as the date (as in my first screenshot) or not.

 

Rob
Los Gallardos

Microsoft Power Automate Community Super User