How to filter multi condtion with multi column

[jack.chan]

maybe this will help

How to use For each to pass variable to Filter wizard of "Filter data table" activity

assume you have 2 excels, one is the main excel , one the the excel containing the names to filter by [image] this is how you can filter dynamically instead of hardcoding a filter datatable activity 1 read “test.xlsx” to dtMain variable read “NamesToFilter.xlsx” to dtNamesToFilter datatable variable initialize a “filterList” and filterString variable [image] loop over dtNamesToFilter, in each iteraction add "[Name]='"+CurrentRow("Name").ToString+"'" to filterList [image] 3a. n…