Lookup in Collection

[paul_tudberry]

​HI Guys, apologies if this has been asked previously, I have 2 matching collections with identical field names, I wish to lookup if a value exists in a certain field and return a true/false answer without looking through the full collection.

For example

the Value in [Collection1.Field1] = "Dave"

Collection 2 could have 50 names in it, I wish to see if  any of   the values in [Collection2.Field1]="Dave" without looping through the full collection.

------------------------------
npower
Europe/London
------------------------------
​

[JeroenOosterhol · Accepted solution]

You can use action "Collection contains value" from the Utility - Collection Manipulation to check whether a value occurs in a collection

------------------------------
Jeroen Oosterholt
Automation Designer
DHL
Maastricht
------------------------------

[AndreyKudinov]

Or filter collection 2 by that value and see if result set contains data.

------------------------------
Andrey Kudinov
Project Manager
MobileTelesystems PJSC
Europe/Moscow
------------------------------

[paul_tudberry]

​Great , thank you guys,

------------------------------
npower
Europe/London
------------------------------