How to Track SharePoint Stage Progress and Time Spent
Question details
The user wants to track project lifecycle stages and calculate the exact duration a project remains in each stage within SharePoint.

- Product
- Microsoft SharePoint and Power Automate
- Device & OS
- not provided
- Scenario
- Managing project lifecycles and automating the calculation of time spent during different project phases.
- Observed behavior
- The user needs a reliable method to record stage transitions and measure the time elapsed between those transitions.
Ensure you have active licenses for both Microsoft SharePoint and Power Automate, and that you hold the necessary permissions to create and manage lists and flows in your workspace.
Use Power Automate to Record Stage Changes and Calculate Time
Create an automated cloud flow in Power Automate to detect when a project stage changes in SharePoint and calculate the time difference.
Power Automate provides the necessary triggers and date-time operations to track status changes dynamically. Because calculating stage duration requires checking previous item states, the workflow logic can be advanced.
Navigate to your SharePoint site and ensure your list contains columns for 'Project Stage' (Choice), 'Stage Start Date' (Date and Time), and 'Days in Stage' (Number).
Open Microsoft Power Automate, click 'Create', and select 'Automated cloud flow'. Choose the SharePoint trigger 'When an item or a file is modified'.
Add a 'Condition' action to check if the 'Project Stage' value is different from the previous version of the list item. You may need to use the 'Get changes for an item or a file (properties only)' action to compare versions.
If the stage has changed, use a 'Compose' action with a Date Time expression (such as ticks() or the dateDifference function) to calculate the time elapsed between the current date and the 'Stage Start Date'.
Add an 'Update item' action to write the calculated duration into the 'Days in Stage' column, and update the 'Stage Start Date' to the current date for the next tracking cycle.
Because tracking previous states and calculating exact business days can become complex, visit the Microsoft Power Automate Community forums to ask specific implementation questions and download community-shared templates.

Enhance Your Productivity with WPS Office
While SharePoint and Power Automate are great for enterprise workflow automation, managing your day-to-day project data, reports, and presentations requires a fast, reliable office suite. WPS Office is a powerful, free alternative to Microsoft Office.

Frequently Asked Questions
Can I track SharePoint stage durations without Power Automate?
Basic tracking can be approximated using SharePoint version history or calculated columns. However, calculated columns update only when the item is modified, meaning they won't show real-time elapsed duration. Fully automating the time capture requires Power Automate or a custom SharePoint Framework (SPFx) solution.
What SharePoint list columns are needed to track stage progress?
At a minimum, you should have a 'Choice' column for the project stages, a 'Date and Time' column for when the current stage started, and a 'Number' column to record the calculated time spent in previous stages.
Where can I find templates for tracking project lifecycles in Power Automate?
The Microsoft Power Automate Community forums and the official Power Automate templates gallery are the best resources. Searching for 'track SharePoint status change' or 'calculate days between dates' will yield numerous pre-built flows and expert advice.
Why is my Power Automate flow triggering endlessly when a stage changes?
This happens when your flow uses the 'When an item is modified' trigger and includes an 'Update item' action, creating an infinite loop. To fix this, go to the trigger settings and add a Trigger Condition so the flow only runs when specific columns (like the Stage column) are changed.




