I have a Form Library for new starters. One of the InfoPath fields is Start Date. What I want to happen is that after seven days has elapsed after the input start date that the initiator gets an email to remind them.
I've set up a Caculate date action as below. dt_Today is a Date and Time variable, dt_NotificationDate is also a Date and Time variable
Next I have a Build String action to format the date and store it in txt_TodaysDate which is a Single line of text
Next I have Query List action. The Coll_IDs variable is a List Item ID variable
Next I have a Loop action. The CollecetedHRDates is a collection variable, the varCurrTitle is a single line of text variable and idx is a number.
This is where I come a cropper. I've got a Collection operation Action
When I run the Workflow and look at the Workflow Progress it carries out the For Each action, but doesn't action the Collection operation and the subsequent Send Notification action.
I've set up two Log in history list actions and I'm getting results for dt_Today, dt_NotificationDate and txt_TodayDate but not Coll_IDs.
Any suggestions on why it's not executing the Collection operation and subsequently not sending the notification?