Date review Workflow only sending one alert

Discussion created by darrenfloyd666 on Nov 13, 2017
Latest reply on Nov 29, 2017 by krishnachaluvadi

I'm trying to set up a Workflow where a user gets alerted when the date in a Start Date field has hit 7 days in the future.

I've followed this blog which has worked up to a point. It's sending just one alert out for the first item/form in the library. 


For the purposes of testing I've set the site workflow to run every hour and I've set the Calculate date action to add 20 minutes to a Check Date.


Calculate Date


I think this issue I'm having is with the For Each and Query List actions.


I've set up a CollectedHRDates Collectable which I've targeted it in the For Each action and stored it in a ListItemID variable.


For Each


On the Query list action I've set the Filter as and output as below:


This is the email alert I'm getting showing the Check Date output as 11/13/

This is the library with the multiple forms




So why am I not getting alerts for each item? The fact that 20 minutes has elapsed since the form was submitted should trigger an email for all items shouldn't it?


Should the filter in the Query list be 'Show the items when column Start Date is equal to Check Date'?

Any help appreciated!!