Search all excel files in folder for keyword, then if they have the key word move to a different folder

Help
21

I’m not getting an error, the documents are not moving to the new folder. Thanks for your help

22

can i have a view on the xaml if possible
@sparkplug93

23

ExcelDocSearch.xaml (5.1 KB)

24

Hi,

Check with this,

ExcelDocSearch.xaml (5.3 KB)

25

Thanks! Is there a way to search in the files rather than just the names?

26

we can do that if it is a text file or a html file where the content can be searched directly. But this is excel file, so you need to read the file individually before search inside the file content.

27

How would that be done? Thanks for your time

28

Yah of course
make sure we have like this

image
image974×413 22.7 KB

Cheers @sparkplug93

29

ExcelDocSearch.xaml (6.5 KB)

Check this to search inside the content of files in a directory

30

I’m still encountering the same issue where no files are moving. I added my search criteria and correct folders.

31

but why your marked something as a solution then? :stuck_out_tongue_closed_eyes:

32

My mistake haha

33

if you want to search inside excel files, use LookUp Range…