How to Create Time Limit Alerts for SharePoint List Items
Question details
Set up an automated notification when an item in a SharePoint list remains in a specific workflow stage longer than the allowed duration.

- Product
- SharePoint and Power Automate
- Device & OS
- not provided
- Scenario
- Tracking workflow stages and notifying stakeholders automatically when an item is delayed past a specified time limit.
- Observed behavior
- Standard SharePoint list Rules cannot natively evaluate calculated columns for elapsed time, requiring a Power Automate flow to process the condition and send the alert.
Ensure you have the necessary permissions to edit the SharePoint list, add calculated columns, and create Power Automate flows for your site.
Use Power Automate with a Calculated Column
Bypass the limitations of built-in SharePoint list rules by using a Power Automate flow triggered by calculated elapsed hours.
Since the standard SharePoint list 'Rule' feature does not support triggering alerts based on complex calculated columns, creating an automated cloud flow in Power Automate is the most reliable method.
Navigate to your SharePoint list settings and add two new columns named 'TimeIn' and 'TimeOut'. Ensure both are formatted as Date and Time.
Create a new Calculated column (e.g., 'TimeOutHours') to calculate the elapsed hours. Use the formula: =INT(TimeOut-TimeIn)*24+HOUR(MOD(TimeOut-TimeIn,1))+MINUTE(MOD(TimeOut-TimeIn,1))/60.
Open Power Automate, create an 'Automated cloud flow', and select the trigger 'When an item is created or modified'. Point this trigger to your specific SharePoint site and list.
Add a 'Condition' step to your flow. In the condition box, use the expression float(triggerOutputs()?['body/TimeOutHours']) and set it to 'is greater than', followed by your time limit in hours (for example, 48).
In the 'If yes' branch of your condition, add the 'Send an email (V2)' action. Fill in the recipient details, subject, and body to notify stakeholders that the item has exceeded the time limit.

Manage Your Project Data Efficiently with WPS Office
While SharePoint and Power Automate handle complex automated web workflows, WPS Office provides a lightweight, free, and highly compatible suite for analyzing exported list data, managing project timelines, and creating workflow reports without heavy subscription fees.

Frequently Asked Questions
Can I use the default SharePoint Rule feature instead of Power Automate?
The built-in Rule feature in SharePoint lists has limitations when reading and triggering based on calculated columns that track complex elapsed time. Power Automate is required for this specific scenario to ensure the condition evaluates correctly.
Why is my calculated column formula returning a syntax error?
Ensure that your column data types for 'TimeIn' and 'TimeOut' are strictly set to Date and Time. Additionally, verify your site's regional settings; some regions require semicolons (;) instead of commas (,) to separate formula arguments.
How do I change the time limit from 48 hours to another value?
In your Power Automate flow, locate the condition step where you entered the threshold. Simply change the value '48' to your desired number of hours, save the flow, and test it.




