https://community.blueprism.com/t5/Product-Forum/Collection-manipulation-Filtering-with-a-data-item/m-p/57832#M11764 I think you've confused the square brackets in the filter expression with the square brackets in the BP expression. It should be something like this: ""[First Name] = '"" & [dataitem] & ""'"" So that the result of this BP expression is a filter expression like this: [First Name] = 'John' Fri, 14 Jul 2017 14:13:00 GMT John__Carter 2017-07-14T14:13:00Z https://community.blueprism.com/t5/Product-Forum/Collection-manipulation-Filtering-with-a-data-item/m-p/57830#M11762 How would you filter a collection for a value in a data item? for example I use collection manipulation with the action "Filter collection" I can filter if I have a set value e.g "[Collectionfield]='12345'" but when I try and filter from a data item "[Collectionfield]=[dataitem]" blue prism tells me that it cannot find "[dataitem]" in the collection. How do I distinguish between a field in a collection and a data item while filtering the collection? Thu, 13 Jul 2017 21:00:00 GMT https://community.blueprism.com/t5/Product-Forum/Collection-manipulation-Filtering-with-a-data-item/m-p/57830#M11762 Jan_LouisMoster 2017-07-13T21:00:00Z https://community.blueprism.com/t5/Product-Forum/Collection-manipulation-Filtering-with-a-data-item/m-p/57831#M11763 Hi, U mean u have a collection and want to extract particular column items in to new collection ? If in that case u can use Filter Collection Action , Then u have to put the collection u want to filter in the collection In and the Filter Text : ""Column name u want to filter ='""&Column name from the collection&""'"" Hope it helps Thanks Fri, 14 Jul 2017 07:47:00 GMT https://community.blueprism.com/t5/Product-Forum/Collection-manipulation-Filtering-with-a-data-item/m-p/57831#M11763 leela 2017-07-14T07:47:00Z https://community.blueprism.com/t5/Product-Forum/Collection-manipulation-Filtering-with-a-data-item/m-p/57832#M11764 I think you've confused the square brackets in the filter expression with the square brackets in the BP expression. It should be something like this: ""[First Name] = '"" & [dataitem] & ""'"" So that the result of this BP expression is a filter expression like this: [First Name] = 'John' Fri, 14 Jul 2017 14:13:00 GMT https://community.blueprism.com/t5/Product-Forum/Collection-manipulation-Filtering-with-a-data-item/m-p/57832#M11764 John__Carter 2017-07-14T14:13:00Z https://community.blueprism.com/t5/Product-Forum/Collection-manipulation-Filtering-with-a-data-item/m-p/57833#M11765 Thank you John and Leela, your solution worked Mon, 17 Jul 2017 12:17:00 GMT https://community.blueprism.com/t5/Product-Forum/Collection-manipulation-Filtering-with-a-data-item/m-p/57833#M11765 Jan_LouisMoster 2017-07-17T12:17:00Z