cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
P00118510
Frequent Visitor

Updating excel row

Hi everyone, 

 

I have a timesheet tracker of sorts. Users can clock-in and out (also lunch in and out) via manually triggered button. All ins and outs are recorded on SharePoint list. I have a separate excel online sheet that gets updated based on previous SharePoint list entries. 

The current set up properly records all SP list entries to excel BUT I cannot figure out how to make it so that if a person records an entry other than "clock-in" my excel table to update the action and the time on the previous "clock-in" record" rather than to override it completely. I was thinking of some condition such as " if date is same, and person name is same, and previous action is already equal to "clock-in" then grab that new "clock-out"(or lunch-out or lunch-in) action and time and update it on the the same daily clock-in record. That way i can calculate daily hours worked. See below for screenshots.

 

01 - Manually Trigger a Flow01 - Manually Trigger a Flow02 - Create an item02 - Create an item03 - When an item is created or modified03 - When an item is created or modified04 - List rows present in a table04 - List rows present in a table05 - Filter Array05 - Filter Array06 - Condition06 - Condition07 - Yes(No) Result07 - Yes(No) Result08 - Weekly Payroll Table08 - Weekly Payroll Table

1 REPLY 1
v-bacao-msft
Community Support
Community Support

 

Hi @P00118510 ,

 

It seems you can try to calculate the intermediate time difference after check-in and check out, and both are added to the working hours of the day.

 

But the difficulty is how to calculate the time difference. In fact, the best thing is that there is a record of the actual work in the OA system, and then it can be directly obtained.

 

The calculation of time difference in MS Flow is not particularly friendly at present, especially the time stored in the Excel table. The value displayed in Flow is number, which is not conducive to calculation.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (2,435)