Forum Discussion
How to import files from different paths
Hi. How to import files from different locations? I have paths to files saved in Excel table. I can import one path from Excel to PQ: = Folder.Files(paths{0}[Column1]) but this method gets only ...
Sorry, I didn't read your original post thoroughly enough.
If you have a (dynamic) list with multiple filenames, don't use the Folder.Files-function, but instead the Excel.Workbook-function:
1) Convert your list with filepaths to a table
2) Add a custom column to that table with the following code:
Excel.Workbook(File.Contents([ColumnNameContainingPaths])){[Item="NameOfTheTables"]}[Data]
You have to adjust the bolded parts and then just expand that new column.
thank you!
Hi skurek,
Have you solved your problem?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please feel free to ask.
Best Regards,
Cherry