https://community.blueprism.com/t5/Product-Forum/How-to-Create-generic-Validation/m-p/73055#M25660 Hi All, I want to create a generic validation function which validate the collections field. i.e. Suppose I have a collection like OrderID OrderName OrderDate MailID Note 1 Abc 12/04/2016 abc@def.com Note1 2 DFE 12/05/2016 abc@def.com 3 Abc 12/06/2016 abc@def.com Note2 Here, except note everything is mandatory. So I want to create another collection where I can put my validation logic like, ColumnID Column Name Type Function 1 OrderID Regular [Value] "" 1 OrderDate Regular IsDate() 1 MailID Regex ^([a-zA-Z0-9_\-\.]+)@([a-zA-Z0-9_\-\.]+)\.([a-zA-Z]{2,5})$ In a loop I want to iterate through the records and do the needful. As a summary I want a function which will take Two collection as a i/p and it will return the validation result and the error message. Fri, 19 Aug 2016 11:59:00 GMT sutirtha.gupta 2016-08-19T11:59:00Z https://community.blueprism.com/t5/Product-Forum/How-to-Create-generic-Validation/m-p/73055#M25660 Hi All, I want to create a generic validation function which validate the collections field. i.e. Suppose I have a collection like OrderID OrderName OrderDate MailID Note 1 Abc 12/04/2016 abc@def.com Note1 2 DFE 12/05/2016 abc@def.com 3 Abc 12/06/2016 abc@def.com Note2 Here, except note everything is mandatory. So I want to create another collection where I can put my validation logic like, ColumnID Column Name Type Function 1 OrderID Regular [Value] "" 1 OrderDate Regular IsDate() 1 MailID Regex ^([a-zA-Z0-9_\-\.]+)@([a-zA-Z0-9_\-\.]+)\.([a-zA-Z]{2,5})$ In a loop I want to iterate through the records and do the needful. As a summary I want a function which will take Two collection as a i/p and it will return the validation result and the error message. Fri, 19 Aug 2016 11:59:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-Create-generic-Validation/m-p/73055#M25660 sutirtha.gupta 2016-08-19T11:59:00Z https://community.blueprism.com/t5/Product-Forum/How-to-Create-generic-Validation/m-p/73056#M25661 Hi Sutirtha - you can't dynamically assemble and execute an expression like that in BP. You will have to loop through the collection and validate the data row by row using decisions etc. Conceivably you could push the raw data out to an Excel file preloaded with validation logic, but that would be just as much, if not more, work to set up and maintain. Fri, 19 Aug 2016 14:44:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-Create-generic-Validation/m-p/73056#M25661 John__Carter 2016-08-19T14:44:00Z