Hello,
I'd like to track how long an item stays in a status once it enters a particular view of my SharePoint. Currently, items move through 5 views, and once it enters into the fourth view, I'd like to monitor how long it stays in that 4th view until it moves into another status. Is there a way to take the start time and end time, then output it into an excel table? I'd like to prevent adding any columns into the SharePoint.
Hi @Tconti
You have to be able to track the 2 changes.
So you would have to
1. Create a Triggered flow for when the Record is updated, and specifically add a Trigger on the View Column. If you have 2 specific stages it takes like
ViewStage and then EndStage
1B) If so, then you would put a Trigger Condition on this, checking to see if the row that was modified, was either in ViewStage or EndStage
1C) When its a ViewStage, put it in your excel and make sure you Track some Id so that you can update/query Excel later.
Now if you check and its EndStage now view stage
1B) Use List Rows in a Table to get the row from the excel that has the StartTime of ViewStage
1C) Use the Trigger Modified DateTime data, to update the Excel using Update Row in a Table (I think its called)
Now you are writing when it started and when it ended to an excel.
If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others
Cheers
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey