Can I load files (list of names are predefined in excel) from a folder in a query?|Power Query|Excel Forum|My Online Training Hub

Dear,

What I want to achieve: I want to load different version of archiving for my forecast files. The file names are pre-defined in an excel sheet (2201F, 2202F, ... 2212F) and they will be restored in the same folder. I know I can load all files from a certain SP library folder, but I want to make sure only the ones having good names are loaded to prevent someone accidently drop some other files to the folder.

So the query will only load the files having name: 2201F, 2202F, ... 2212F (pre defined on a excel sheet). Nothing else. And if some versions are not yet available e.g. 2205F, no error will appear, the query will only load the ones that are existing: 2201F to 2204F.

If this is not possible, I know alternatively, you can add queries to load every single file with pre defined route. But this needs to be done 12 times... Is there a way to pre define all routes and pick up those ones only?

Thanks,

Br,

Yuan