Email generated after a renewal date is expected

Site level workflow will handle everything you are looking to do, as everyone pointed out already

‌'s blog post goes into details on how you would set it up and build it, but at a high level, you will need the following:

• Query list/library
  • To get the item(s) that are up for renewal
• Loop
  • To loop through your results, build an context around the item, and then email it out

Hope this helps!

Sounds Great Priya! If ‌'s blog works out for you, please remember to come back and mark her answer as correct.

Thanks and Regards,

Patrick Kelligan

Hi Cassy,

Just wanted to let you know that i have successfully implemented a site workflow with a few tweaks but its worked.

Thank you so much for your help.

This community is amazing any problems i have had or unsure how to complete a problem I have found the answers here.

Thank you again Cassy

regards

Priya

Hi Cassy,

How can I amend the workflow to allow for 3 dates.

This is the scenario, its a contract renewal and the workflow sends an email on each reminder date.

I am still thinking a site workflow is best but not sure how to use one workflow that sends an email dependent on the 3 different reminders dates.

thanks for your help in advance

Cassy Freeman‌ & Priya Chohan‌ - 

If it is three different dates that you need to look for within the same list, I would do one query, find the date for each item, and then if [item_date] == [reminder_date] trigger your notification. You will need to do that for each reminder_date you are looking for (assuming something like [renewal_date]-10, -5, -1, so 10 days out, 5 days out, then the day before).

Doing it this way allows you to do one query, and one loop. You need to add into your loop a Run in parallel action with all the Run if actions, something like this:

Of course, anything else you may need/want to grab from the query you can and add in collection actions, but this allows you to look at one item and see what reminder it would fall into.

Let us know if this is what you were thinking or if i am way off

Hope this helps!

Hello cassymfreeman

I Couldn't find your blog post you mentioned please.

Is there a link to the original blog post anywhere? Thanks