Forum Discussion
MichaelHutchens
Helper V
Helper VLoading 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}.
DataInsights
Super User
Super User
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/