Hello
I followed Cassy's workflow instructions here https://community.nintex.com/community/build-your-own/blog/2016/05/23/site-workflow-document-review-date-approaching-reminders which works in theory but is not fit for my current requirement and need your help / advise.
Current Requirement:
- Send one email notification with all the relevant information (instead of individual).
- Only send out the email notification when one of the predefined dates is <= (less or equal to) Current Date
1) Query List
This checks the List and filters
LeaseReminder is less than or equal to Current Date
or
MOTReminder is less than or equal to Current Date
or
ServiceReminder is less than or equal to Current Date
2) For Each
Note: the lid_ stands for : List Item ID
Inside the For Each, there is a Query List action.
PROBLEM(S)
Why does the For Each auction send an email out even though the filter does not meet the requirement?
In this case, non of the reminder dates is less than current date!
How to implement so it sends one email notification with the relevant information?
UPDATE:
I have uploaded my current workflow.