Others

How to Track SharePoint Stage Progress and Time Spent

John WilsonJohn Wilson Oct 28, 2026 868 views

Question details

The user wants to track project lifecycle stages and calculate the exact duration a project remains in each stage within SharePoint.

How to Track SharePoint Stage Progress and Time Spent
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.
Before you start

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.

Solution 1Recommended

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.

1
Prepare your SharePoint List

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).

2
Create a new automated cloud flow

Open Microsoft Power Automate, click 'Create', and select 'Automated cloud flow'. Choose the SharePoint trigger 'When an item or a file is modified'.

3
Add a condition to detect stage changes

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.

4
Calculate the time spent

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'.

5
Update the SharePoint item

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.

6
Seek specialized assistance

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.

Use Power Automate to Record Stage Changes and Calculate Time
Avoid Infinite Loops: When updating a SharePoint item within a flow triggered by a modification, be sure to use Trigger Conditions to prevent the flow from triggering itself repeatedly.
Free Microsoft Office alternative

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.

Highly compatible with Microsoft Excel, Word, and PowerPoint formats.Completely free and lightweight, ensuring smooth performance on any device.Familiar user interface allows for seamless migration with no learning curve.Built-in PDF editing tools for easy project documentation and sharing.
microsoft office alternative - wps 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.