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.
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.
@lakshman many thanks for your quick response!!
1 Like
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.