I want to filter datatable dynamically

[nidhanshu]

PolicyInfo.xlsx (8.4 KB)
need to filter this table based on “PolicyCategory”, AA policy in AA sheet and same goes to rest of the category. and in future if any category added then we don’t need to change the code.

Thanks in advance for helping me

[jack.chan]

look at my other solution here , it will answer your question

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…

[farhaan.khan86 (Farhaan Khan)]

Hello @nidhanshu ,

Please find attached instant solution and may help you to solve the issue , however we may have different way as well.

PolicyInfoMain.xaml (8.2 KB)