I have a two lists
List 1: Project Number, Person1, Person 2, Account Number
List 2: Project Number, Person 1, Person 2
Not all the project numbers are in List 2
However, I need to create a workflow or in Nintex Form (preferable in form) that if the Project Number exists in List 2 then pick Person 1 and Person 2. If it doesn't exist then I will send an email to Analyst to fill this information.
Can anyone help?
Thank you!