I have download .xlsx report every day in current date folder & I want to read all excel files from current date folder then how i do it
This all excel files i want to read from current date folder
1 Like
→ Use for each folder in folder activity to iterate the each folder in the Parent folder.
→ Inside for each folder in folder activity insert the If condition to check the folder name with the current date.
- Condition -> CurrentFolder.Name.Contains(Now.ToString("yyyy-MM-dd"))
→ Inside then block insert the For each file in folder activity to iterate the each file in the filtered folder (Current Date name folder).
→ Inside for each file in folder activity you can insert the activities for the further process.
xaml:
Sequence21.xaml (13.0 KB)
Regards,
- Use for each folder in folder activity and give the current date folder present path.
2: Apply if condition as currentfolder.name.contains(TodaysDate).
3: In Then sequence use for each file in folder activity and iterate all the files in that folder.
After that you can use Excel activities in it by passing “Currentfile” variable in Excel
path.
Hope it helps,
Thanks!!
Yes this is also fine
Thanks!!
You can use this but just before this for each file in folder activity use Path Exist activity to check if the path is exist or not.
Thanks,
Ashok 
Yes, you can go with this flow also but before that you need to use an folder exists activity and check whether the folder is present or not.
Folder exists activity output will be Boolean variable and pass that variable into the if condition and that if condition need to be placed after the folder exists activity.
Within the then block place all the activities need to be done further.
Regards
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.