Check if any excel file exists in a path (all in subfolders)

[lynnsong986]

Hello, I have a main folder and 20+ subfolders stored inside of this main folder. There can be multiple excel workbooks or zero workbook stored in each of these subfolders (but none directly inside of the main folder). I need to check if there is any excel workbook saved in any of these subfolders, if not (no workbook saved in any of these subfolders) I’ll terminate workflow otherwise a process will run. How can I check that? Thank you so much in advance.

[lakshman (Ganta lakshman)]

@lynnsong986

Try below expression in IF activity.

       Directory.GetFiles("MainFolderPath","*.xlsx",SearchOptions.AllDirectories).Count > 0

The above expression will give true if atleast one excel file exists in Main or its sub-folders else not.

[lynnsong986]

@lakshman many thanks for your quick response!!