niralithakkar
Canvas Initiate

Compare field from different sharepoint list

Can anyone please suggest how I compare field from two different list. 

 

Scenario is like have two list Employee and projects. Each and every employee need to submit project in project list. If any employee who forgot to submit will send reminders to them. 

 

Employee list contain all the employees 

0 Kudos
Reply
1 Reply
SimonMuntz
Nintex Employee
Nintex Employee

Re: Compare field from different sharepoint list

Hi,

Create a workflow on the projects list or even a site workflow.

Query all the Employees in the employee list and store them in a collection variable.

Query all the employees in the Project list.

Use a For Each action to go through the Employees list and extract each employee out one at a time.
In the For Each loop have a Collection Operation action that checks if the Employee exists in the project collection variable.
If yes do nothing. 
If no send an email.

 

The workflow would look something like this.

somethinglikethis.png

 

0 Kudos
Reply