Sharepoint 2013 Workflow send email reminder based on priority and certain weekdays

Question

Good day. I have a list with many columns but I have 2 columns, one called Priority and the other Status. I'll like to create a workflow that

1. If priority is High, send an email twice a week on Mondays and Thursdays;
2. If Priority is Medium, send an email once a week every Monday;
3. If priority is LOW, send an email every two weeks on Mondays.

This should always be running and sending reminders until column Status is not "Completed".

Any help is really appreciated.

Answer 1

Your best choice would be to write a timer job. But if you can't, you could write a workflow that runs on create and on change. You would get the last modified date, pause until the day you want it send, send an email, and then restart the workflow.

To get a string representing day of week: Copy 2 characters from start of [Modified Date (as Long Date)] output to Variable: DayOfWeek (e.g. Mo, Tu, We, Th...) Then, if DayOfWeek = Mo send an email and pause (# of days depending on priority). Then restart the workflow.

Continue for each possible day of week. Wait for Status = Complete and stop the workflow.