I have a workflow tied to a calendar that fires when an event is added to the calendar. The workflow sends an email 7 and 3 days before the event startdate.

I am having a problem where users are getting a properly constructed email and one in which the lookup fields from the list are blank

Example Correct email:

Subject: REMINDER - renew domain address @ 1/29/2014

Problematic email

Subject: Reminder -  @ 1/1/0001

I have checked my workflow for an extra send email command and there isn't one. What would cause the workflow to send multiple emails on of which retreives nothing for the lookup fields?

Mike

A few suggestions from my end.

Have you checked to ensure that there aren't two multiple workflows running? This wouldn't normally explain an empty email but is worth investigating.

Additionally, do you have any pause steps in the workflow?

And last of all, can you check the workflow history to see if anything is being logged?  You can do this by clicking on the workflow name in the status field.

The workflow is setup to start when an item is added to the calendar. The steps of the workflow are:

1. log "Starting"
2. Log "Pausing"
3. Pause until reminder date 1
4. Log "Pausing complete"
5. log "Resuming"
6. Send email
7. Log "Email Sent."
8. Log "Pausing..."
9. Pause until reminder date 2
10. Log "Pausing complete"
11. log "Resuming"
12. Send Email
13. Log "Email Sent"
14. end

Reminder date 1 and Reminder Date 2 are calculated columns that contain [start date]-7 & [start date]-3 respectively. I checked with the users and they do in fact receive the correct reminder email. They also get a blank email along with the good email.

I checked and there is only one instance of the workflow running. The workflow is in progress since it's now in between the first email and second one. I also checked the log and everything is being logged correctly.

LOG:

Starting
Pausing
Pausing until 1/24/2014 7:00:00 PM
Pausing complete
Resuming
Emailed Geri and Karen
Pausing
Pausing until 1/30/2014 7:00:00 P

• Edited by RCDA Webmaster_ 16 hours 57 minutes ago

Hi RCDA,

For the date 1/1/0001 in mail subject based on your description "Problematic email Subject: Reminder -  @ 1/1/0001"

It looks like the "reminder date 2" column is blank when workflow has performed the action "Pause until reminder date 1".

You can try using 2 workflow variables to store the reminder date1 and reminder date2 based on the "Start Date" through the action "Add time to date", then pause until reminderDate1 .....then pause until reminderDate2, you may want to log the reminderdate value before the action "pause until date" to trace the action and value, then see if it could work.

You may also need to consider if you would change the "Start Date" value after you create the item, and if the modified date is greater than Reminderdate1 or greater than ReminderDate2, then design your proper workflow logic.

http://markeev.com/Articles/item-expiration-reminders-in-sharepoint-using-workflow.aspx

Thanks