Sending email if a created item in first list doesn't exists in lookup field of second list

  • 14 September 2018
  • 1 reply
  • 4 views

Hi Everyone,

 

This is my first time using Nintex. Please help me here as i dont know where to begin and how to start.

 

I have to make a workflow. I have two lists(list A and list B) in SharePoint online. In list A, i will add items. For example i have added an item and CT0001 is the title of that item in list A. In list B, the title of my list A is the lookup column. So i want to check and send email notification for condition ---

After creating a item in the list A(tile is CT0001), if there are no items corresponding to that in the list B after 14 days of the creation of that item then it should send an email notification.

 

Please guide me here everyone.


1 reply

Userlevel 6
Badge +22
Hi,
A yes/no column should be created in List A to keep track if an email has been sent.

Run a site workflow that queries the list on a daily basis.
1. The workflow will calculate what the date was 14 days ago to start with.
2. The workflow would then check the Yes/No column.
3. Anything that is No, check if the created date on the item is equal to the date calculated in step 1.
4. If it is equal, check List B to see if the Title matches the title of the item that item.
5. If no Matches send out email and flip the Yes/No to Yes.

Reply