Forum Discussion
Import multiple Excel files from one SharePoint folder through dynamic parameters
Are these files the same format?
You could use:
Get Data > "Folder"Then, click on the filter icon next to file name and do a filter "Text Filter" > "Contains".
This can be a parameter or hard coded value.
You can click the double down arrow to combine all files.
There's not a great way to load individually. One hacky way, you could make a blank query, then add the step:
Source = try #"Your Folder Query Name"{0}[Content] otherwise null
then do the same:
Source = try #"Your Folder Query Name"{1}[Content] otherwise null
repeat and increase the number by 1 (it is 0 indexed, so 0 references the first item in the list and so on). Make enough queries that there will always be more than items in the list.
Appreciate your Kudos
Connect with me!
Memorable MemberAre these files the same format?
You could use:
Get Data > "Folder"
Then, click on the filter icon next to file name and do a filter "Text Filter" > "Contains".
This can be a parameter or hard coded value.
You can click the double down arrow to combine all files.
There's not a great way to load individually. One hacky way, you could make a blank query, then add the step:
Source = try #"Your Folder Query Name"{0}[Content] otherwise null
then do the same:
Source = try #"Your Folder Query Name"{1}[Content] otherwise null
repeat and increase the number by 1 (it is 0 indexed, so 0 references the first item in the list and so on). Make enough queries that there will always be more than items in the list.
Appreciate your Kudos
Connect with me!