How to use multiple "Filter" in "For Each File in Folder" Activity?

[wija (Fredy Wijaya)]

How to use multiple “Filter” in “For Each File in Folder” Activity?
for example i want to filter file with extension .xlsx and .xls at the same time when get files in folder using “For Each File in Folder” Activity.

[arivu96 (Arivazhagan A)]

Hi @wija ,
Use + icon to add additional file format.

Adding multiple filters in For each file activity

Hello, is possible in activity “for each file” to add more then one filter? I Need “.doc",".docx” and "*.pdf"files to be procesed.

Regards,
Arivu

[wija (Fredy Wijaya)]

ah, so the only way is by adding “IF” activity inside the “For each file in folder” activity?
so inefficient lol.

thanks for answering

[raja_ias (PALANIRAJA PARAMAN)]

@wija “*.(.xlsx|.xls)”
Use this and let me know.

Thanks

[arivu96 (Arivazhagan A)]

@raja_ias

“*.(.xlsx|.xls)”

It will not allow. will show error as illegal char error.

Regards,
Arivu

[Sudharsan_Ka]

Hi @wija

You can try with this expression in the For each activity

Directory.GetFiles(Environment.CurrentDirectory+"\","*.*").AsEnumerable().Where(Function(a) New FileInfo(a).Extension.ToString.ToUpper.Contains(".XLSX") Or New FileInfo(a).Extension.ToString.ToUpper.Contains(".XLS")).Select(Function(d) d)

Regards
Sudharsan

[wija (Fredy Wijaya)]

thank you for answering, but the question is for “for each file in folder” activity.

[Sudharsan_Ka]

@wija Yes i Know , I think we cant do that in for each file in folder

Regards
Sudharsan

[wija (Fredy Wijaya)]

for now, only this solution is working but inefficient.