Hello, I am a Nintex Newbie.
I need to send an email notification for an award due date that is 30 days away. I created a SharePoint list with 4 columns (including awardname, awardduedate, etc). Below is the current workflow I have. The issue with this workflow is that the email notifications are being generated for all of the awards I have populated on the SharePoint list.
For example, I received an email notification correctly for an award with a due date 30 days away (i.e. today is 3/12, and the award is due 4/12).
Unfortunately, I also received an email notification erroneously for an award with a due date that is more than 30 days away.
In addition, I also received an email notification erroneously for an award with a due date that is upcoming, but the 30 day mark has already passed (i.e. the 30 day mark was 2/20).
The main issue appears to be with the "Run if" - I have tried several variations (after searching forums/posts) and none have worked. I tried using the "Current Date" from the "Common" tag. After that I created the variable "varTodaysDate" after reading this forum here. What can I do to correct this?
Solved! Go to Solution.
In addtion, here are all of the workflow details:
(1) Query list
(2) Run if
(3) Query list
(4) Calculate date
(5) Run if (as seen above in original post)
(6) Send notification
I see that your mail action is directly nested in the for each action. So whatever you calculate, the last action will always be to send the mail. I think what you intended to do is to nest it in the run if action.
While I'm unsure if the run if condition will work as expected this would be the first thing needed to make the workflow run correctly.
Hi - thanks for the reply.
Unfort. when I try that, I end up receiving zero notification emails... any other ideas?
It's working now. My Run if needed to be changed.
So now it looks like:
With, Run if nested with Send notification:
Thanks for replying!