Forum Discussion
Solved
Loading multiple SharePoint page libraries into the same query
Hi folks, I'm hoping someone might be able to assist. I have a single SharePoint site collection with multiple page libraries, one in each site. Each library has identical columns. I'm trying to f...
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 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 🙂