I need to read certain Excel files that are in a folder, but the filter does not work for me. I need to know the name of the Excel files and that they contain “C1”.
The files are these:
I use “Get Folders contents”:
But it returns in the variable “filesc1” all files.
What should I put if I just want to know the name of the files that are xlsx and contain “C1”?