cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
P00118510
Level: Powered On

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 Flow.png01 - Manually Trigger a Flow02 - Create an item.png02 - Create an item03 - When an item is created or modified.png03 - When an item is created or modified04 - List rows present in a table.png04 - List rows present in a table05 - Filter Array.png05 - Filter Array06 - Condition.png06 - Condition07 - Yes(No) Result.png07 - Yes(No) Result08 - Weekly Payroll Table.png08 - Weekly Payroll Table

1 REPLY 1
Community Support Team
Community Support Team

Re: Updating excel row

 

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
firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (5,405)