AnsweredAssumed Answered

Help needed: Reminder Worflow to send one email

Question asked by bimi82 on Dec 17, 2018
Latest reply on Jan 4, 2019 by bimi82

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.

Attachments

Outcomes