How to set a reminder from sharepoint list based on the last modified date (enabled from list settings) ?

Question

Actually the scenario is to send a reminder mail when the last modified date is overdue by 7 days.

I have enabled modified date & time column in sharepoint list settings. so in that case this column will not comes under set a reminder options.

So we have to pick the last modified column values and compare it to our flow and if the condition satisfies then mail should trigger as a reminder to check the overdue data.

I am very new to Power automate so its very hard to understand all the things ..

Answer 1

Dear,
@Arivalagan, Dinesh Kumar
I tried to understand your problem and solved it after seeing your situation.

I made a space as an example to illustrate your problem with following details.
I made 4 columns for this process to complete in orderly manner. So, I searched a formula on this also as:
=IF(AND([Current Date] > TODAY() + 7, [Status] = "Complete"), "OD", [Status]) which worked and helped me alot!

Title:

current date: having today's default value.

Status: Complete

Attachments

Inputs, Conditions and Triggers are working fine. I performed the manual and Automatic tests to satisfy myself with an example.

Powerautomate worked with Sharepoint. So, now you can try my solution and reach me here.

Links:
https://pern.sharepoint.com/:li:/s/DineshKumar/EzeMF4XcnTRKkH-GeX9KcI4BDWdFx56_3ka6GwkyetFVfA?e=Ky84YW

Answer 2

@Yanli Jiang - MSFT

As per your request , i have posted your answer for the scenario which i am looking for now.

Below the answers from you :

I have followed the same method which you given and still my task is not complated , no mails are received .

Did you applied any filter query in get items ?

Please help to solve this asap :)

Thanks

DK

Answer 3

Hi Arivalagan, Dinesh Kumar,

Thank you for reaching out to us on the Microsoft Q&A forum.

This topic is currently not supported in the Q&A forums.

I suggest you start a new discussion via the Power Automate Community. and moderators will be there to help you.

Please don't forget to Accept helpful answer and close this thread.