I'm trying to create a nintex workflow that will look at one field in List1 and compare it to a multiple choice field in List2. List1 has ID, Title, Field1 (single line of text). List2 has ID, Field2 (multiple choice categories), and created by
When an item is created is created in List1 the workflow should see if Field1 is in Field2 and then email the created by person in List2 for that ID.
EX:
List1:
1 This is the title Food category
List2
1 Food Category, Shoe Category, Home Category email1@email.com
2 Food Category, Yard Category email2@email.com
3 Home Category email3@email.com
So in this example email1@email.com and email2@email.com would be emailed.
I'm using a for each loop and a condition but I can't seem to get the email peice correct. Has anyone tried something like this they could help show me a flow and what I could do for this to work?
