How to filter excel based on list of keywords in a particular column

[Palaniyappan (Palaniyappan P)]

@Palaniyappan

CopyToDatatabl

Fine, make changes as per, open the xaml in the notepad and add the assembly reference as mentioned in the below thread

AsEnumerable is not a member of 'System.Data.Datatable'

Hi @lucas.mcgonagle EDIT 20.10 fixed this issue for newly created projects. You can fix it by adding the Assembly Reference manually in your xaml file: [image] Simply open the file in Notepad and create new line with this String: <AssemblyReference>System.Data.DataSetExtensions</AssemblyReference> Then reopen your project and the error should be gone. Please be careful while doing so and always keep a backup.

Cheers @karthik_A