Skip to main content

Notifications

Power Automate - Using Flows
Unanswered

I'd like to keep track of how long an item sits in a SharePoint view status

(1) ShareShare
ReportReport
Posted on by

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.

  • FLMike Profile Picture
    FLMike 31,580 on at
    Re: I'd like to keep track of how long an item sits in a SharePoint view status

    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

     

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,636

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,942

Leaderboard

Featured topics

Restore a deleted flow