Others

How to Create Time Limit Alerts for SharePoint List Items

Natalie TaylorNatalie Taylor Oct 20, 2026 868 views

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.

How to Create an Alert When a SharePoint List Item Exceeds a Time Limit
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.
Before you start

Ensure you have the necessary permissions to edit the SharePoint list, add calculated columns, and create Power Automate flows for your site.

Solution 1Recommended

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.

1
Create Date and Time Columns

Navigate to your SharePoint list settings and add two new columns named 'TimeIn' and 'TimeOut'. Ensure both are formatted as Date and Time.

2
Add a Calculated Column for Elapsed 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.

3
Set Up the Power Automate Trigger

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.

4
Configure the Condition

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

5
Add the Email Action

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.

Use Power Automate with a Calculated Column
Formula Tip: If your SharePoint site uses regional settings that require semicolons instead of commas, replace the commas in the MOD functions with semicolons.
Free Microsoft Office alternative

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.

Fully compatible with Microsoft Excel (.xlsx), Word (.docx), and PowerPoint (.pptx) formats.Easily process and analyze exported SharePoint list data using advanced spreadsheet functions.Free, lightweight, and features a familiar user interface for a seamless transition.Includes built-in PDF editing tools for comprehensive project documentation.
microsoft office alternative - wps office

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.