Nintex Workflow - value exist in another list

[lotus222]

I would like to search for a value in another list, if exist then set a variable to Yes otherwise No.

For example, if I have two lists

List 1

Fruit	Cost
Apple	$4/lb
Banana	$3/lb
Kiwi	$7/lb

List 2

Fruit	Color
Apple	Red
Mango	Yellow

In List 2, Running workflow in List 2, Apple should return Yes because it exist in List 1 but Mango Should return No

How can this be done?

[cassymfreeman · Accepted solution]

in your workflow on list 2 use a query list action to query list 1 using filter to select Fruit in list 1 = item property (in list 2) fruit.

Are the lists in the same site collection?

If you return the ID field you can use a set a condition action to inspect the returned ID to see if it has a value...  if it does set your variable to "Yes" and if not, set the variable to "No".

does that make sense?

[lotus222]

Thank you Casey. That makes sense.