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?
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?
Thank you Casey. That makes sense.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.