READ EXCEL DATA AND CONDITIONAL AUTOMATION ❤️
Posted: Nov 22nd, ’21, 16:14
I need help from someone in the group to create this workflow.
I have a folder in windows PC, in that more than 1000 Word Files. And I have a list of 100 word file names in an Excel Sheet.
What I want is ;
Search that folder with 100 file names to check whether the files are there or not.
The conditions are to be:
[ IF Files are there in the folder ; want to copy each one to a new folder rename "1-100 as file names" in the order wise ;
Else (Files are not there) ; update as " File Not found" in each 100 cases to the Excel file ie, the file include the list of 100 word file names.
]
Really appreciate if anyone give a guidelines.
I have a folder in windows PC, in that more than 1000 Word Files. And I have a list of 100 word file names in an Excel Sheet.
What I want is ;
Search that folder with 100 file names to check whether the files are there or not.
The conditions are to be:
[ IF Files are there in the folder ; want to copy each one to a new folder rename "1-100 as file names" in the order wise ;
Else (Files are not there) ; update as " File Not found" in each 100 cases to the Excel file ie, the file include the list of 100 word file names.
]
Really appreciate if anyone give a guidelines.