Unanswered

reminder email when status is not updated for 7 days. How?

(0) Share

Report

Posted on by yesilkkkkk

I have a MS List on which we record requests.

Now I want to send a reminder to a person (also on the list) when a specific status is not changed for 7 days.
How can I automate this with Power Automate? I wasnt able to do this, I hope you can help.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

Nived_Nambiar 18,136 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @yesilkkkkk

I have an idea to do this, but feels it would be little complex.

in the microsoft list, create a column of date type with name Status modfied which captures the date on which status column is modfied, but keep it as hidden if you don't want it to be visible.. To update the modified date of status column- a power automate flow has to be created which runs when item is modified. see the below flow

So when the status column is updated, update item action will update the Status Modified column with current date.

Now create a recurrance flow/scheduled flow which runs every day and compare the status modified date with current date, if date difference >=7- it will send a reminder email.

Hope this idea helps !

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
S-Venkadesh 1,214 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @yesilkkkkk ,
Here is the solution to check if the 'Status' field has been updated in the last 7 days:
Ensure versioning is enabled for the SharePoint list
Use a condition to check if the last modified date of the item is within the last 7 days.
If the item has not been modified in the last 7 days:
Conclude that the 'Status' field has not been modified.
Proceed with your workflow accordingly.
If the item has been modified in the last 7 days:
Use an HTTP action to make a GET request to the SharePoint REST API endpoint to retrieve the previous version:

/_api/web/lists/getbytitle('your-list-title')/items('your-item-id')/versions?$filter=IsCurrentVersion eq false&$orderby=versionId desc&$top=1

note: this extract the 'Status' field value from the previous version:
5. Compare the 'Status' field value from the previous version with the current value: If the values are the same, conclude that the 'Status' field has not been modified and Send reminder email

I hope this information is helpful. If it is, please consider giving a thumbs up.

Best regards,
Venkadesh Sundaramurthy

Was this reply helpful? Yes No