Forum Discussion
Loading multiple SharePoint page libraries into the same query
Try this solution. The concept is to create a URL table with a row for each library, and create a custom function that will loop through each library.
https://www.howtoexcel.org/how-to-extract-data-from-multiple-webpages/
Try using Web.Contents as suggested by KNP:
let GetResults=(URL) => let Source = Web.Page(Web.Contents(URL)), Data1 = Source{1}[Data] in Data1 in GetResultsIf this doesn't work, try Source{0} instead of Source{1}.
Try
let GetResults=(URL) =>
let
Source = SharePoint.Tables(URL, [Implementation="2.0", ViewMode="All"])
in
Source
in GetResults
But I don't think that is your issue now.
The 'Dynamic data source' error is one I'm not sure you'll be able to solve with the SharePoint.Tables connector. I've not needed to solve this problem myself so far so I haven't spent enough time on it to know if there are any workarounds. The workaround for other connectors exist i.e. Web.Contents using [RelativePath] but I'm not sure how easy this would be to incorporate into this example.
Maybe DataInsights may have some more ideas in this space.
Try using Web.Contents as suggested by KNP:
let GetResults=(URL) =>
let
Source = Web.Page(Web.Contents(URL)),
Data1 = Source{1}[Data]
in
Data1
in GetResults
If this doesn't work, try Source{0} instead of Source{1}.
Thanks so much DataInsights & KNP for your time with this, I really appreciate it 🙂
