I want to create site workflow to send a reminder email to created by(emails) when Item created is more than 30 days and choice field called "Status" is "open". When someone has more than one items with status open in list then that person get one reminder mail only

Thanks in advance

1 Answer 1


We recommend that you use MS Flow to implement your design.

1.Add the Recurrence trigger: You can customize the trigger time and run frequency

2.Add the Get items action:

  • Filter Query: Created gt 'formatdatetime(addDays(utcNow(),-30,'yyyy-MM-dd'),'yyyy-MM-dd')' and Status eq 'Open'

3.Add the Select action

4.Add the Create HTML table action

  • From: Output (from Select action)

5.Add the Send an email (V2) action

enter image description here

enter image description here

  • Thanks for replying to this post. But I want to do this using SharePoint designer
    – Vivek
    Jun 1, 2021 at 5:28

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.