Error while using the collection manipulation utility

[NagababuMaturi]

My requirement  take the value from workbook A and search for the value in Workbook B .
1.i have loaded the 2 excel sheets into 2 different collections 
2.Taking the value from collection A and searching for the value in collection B using "collection contains value" 
3.But it's throwing an error like "could not execute code stage because the value your searching is not available in collection B even the value is available in collection B.


can anyone help me with this .Thanks In Advance.

------------------------------
Nagababu Maturi
------------------------------

[AlexanderMarlow]

Hi Nagababu - are you specifying the field name in the target collection where you are looking for this value?

------------------------------
Alexander Marlowe
Blue Prism
Blue Prism
------------------------------

[wleung]

Hello Nagababu,

I think perhaps the input parameters you are using needs some tweaking. I am including a screenshot with an example below. It is important to send in the right Column Name for the search. My example is using hard coded string but you can add debug statements before the call to ensure you are iterating through the elements in your Collection A as well as specifying the right Column Name as you search through Collection B.

Hope this helps.

------------------------------
Wing Ling Leung
Senior Product Consultant
Blue Prism Professional Services
------------------------------