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 Flow02 - Create an item03 - When an item is created or modified04 - List rows present in a table05 - Filter Array06 - Condition07 - Yes(No) Result08 - Weekly Payroll Table
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.
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.