cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

Nintex Workflow - value exist in another list

Jump to solution

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

FruitCost
Apple$4/lb
Banana$3/lb
Kiwi$7/lb

 

List 2

FruitColor
AppleRed
MangoYellow

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?

Labels: (2)
Tags (1)
0 Kudos
Reply
2 Replies
Workflow Hero

Re: Nintex Workflow - value exist in another list

Jump to 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?

Reply
Workflow Hero

Re: Nintex Workflow - value exist in another list

Jump to solution

Thank you Casey. That makes sense.

Reply