Need help in sending reminder mail in Power Automate after user hasn't modified an item in SharePoint Library

[vastestuser]

Hello Folks,

Was wondering if you could help me with a particular requirement regarding configuring logic to send reminder mails, via Power Automate

Here is my current Scenario : 

1. There is a SharePoint library having some word documents (which are essentially profiles of employees in the org)

2. There is a power automate flow that looks at the "modified" column in the Library. 

3. The flow also uses a expression to capture "current date - 90days " (which is to subtract 90 days backwards from today). for example if today is 15th Septemver, then this expression returns the date which is 90 days earlier than today. This is stored in a variable.

4. The flow then has logic where, if the "modified" Date is older than "current date - 90", then send emails to the employees (whom the respective files is named after). This mail says that they havent actioned their profile in last 90 days, and that they need to update their profile. The employees then can click on link from email, and update their respective profiles in the library.

I have configured the flow until this point and it works fine. However I need help with sending "reminder" to the employees.

Logic should be :   If they haven't taken any action after the original email is sent,  they need to get a 1st reminder mail 3 days after the first email. If they dont action even after 1st reminder, then second reminder shd be sent after another 3 days. 

Pleaser advice how this can be done.  I assume this should be again based on "modified" column. If the "Modified" column hasnt been changed since the first email is sent, then that can possibly be used as a criteria to send reminder mail. But I am unable to understand how to set this up in the flow. 

Any pointers will be appreciated.

[Nived_Nambiar]

Create a column in that sharepoint list of datetime type , let's say with name EmailSentDate , This will record the date in which mail has been sent. Make the flow in such a way that flow records the date on which mail is sent, then based on that create a condiion which checks whether the mail send date is 3 days prior to current date, if Yes send reminder email again.

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! 🙌

[spiik]

If this would trigger daily and started now, then you could just use this Modified datetime field. Since you might have many years old files, you need to add two more columns to the document libraries (use content types or manually add columns, depends how many libraries you have). Add for example columns "Notification sent" datatime and "Notification level" as choices Notif1, Notif2 and Notif3. These columns does not need to be visible to the user or in library view.

When you loop documents trough and there is more than 90 days older, sent notification 1 and write column "Notification sent" the current datetime and "Notification Level" for value "Notif1". This way you can determine next loops that when is 3 days passed and which notification to be sent next

1st email to be sent - if the Modified date is exactly 90