“Filter Data Table” activity, error states that the value for argument ‘ColumnName’ is not set or valid

I got the above error that points to file4 which has two columns. Not sure if the error is misleading me. The program is working until this point where I add the few lines of codes to filter file4 and assign the value. Thanks.

file1.xlsx (9.5 KB)
file2.xlsx (776.2 KB)
file3.xlsx (82.5 KB)
file4.xlsx (80.1 KB)
test-filter.xaml (45.4 KB)

1 Like

Hi @Kindergarden

Its done…we don’t need to mention the column name because we can enter the wrong one by mistake,

let the bot enter the column name in select method. and i tried…Its working, Kindly refer the below xaml for you reference…

Main.xaml (8.2 KB)
Book1.xlsx (15.1 KB)

Let me know if it helped you

~Diego Turati

Thanks @DiegoTurati for the codes.

Are you able to help with the error in the context of filter as this is what we want to adopt. Besides, the file4 has only two columns and we want to know what this error is pointing at.

1 Like

Sure, I will check the file and let you know.

~Diego Turati

1 Like