Power Platform Community Forum Thread Details

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.

Categories:

Using flows

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