READ EXCEL DATA AND CONDITIONAL AUTOMATION ❤️

Discussion, questions and support.
Post Reply
abhil2021
Posts: 1
Joined: Nov 22nd, ’21, 16:06

Post by abhil2021 » 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.
Post Reply