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
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?
Solved! Go 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?