Adding multiple SharePoint libraries to a query

[MichaelHutchens]

Hi folks, I'm trying to add multiple SharePoint libraries to the same query. Here are my libraries:

https://URL.com/sites/who-we-are/
https://URL.com/sites/tools-to-do-my-job/
https://URL.com/sites/our-locations/
https://URL.com/sites/how-we-work/

And here's my current code, based on a single library:

let
  Source = SharePoint.Tables("https://URL.com/sites/who-we-are/", [Implementation="2.0", ViewMode="All"]),
    #"793529eb-48c3-4fad-a005-7a4aa0a716ad" = Source{[Id = "793529eb-48c3-4fad-a005-7a4aa0a716ad"]}[Items],
  #"Expanded Topic" = Table.ExpandListColumn(#"793529eb-48c3-4fad-a005-7a4aa0a716ad", "Topic"),
  #"Expanded Topic1" = Table.ExpandRecordColumn(#"Expanded Topic", "Topic", {"Label", "TermID"}, {"Topic.Label", "Topic.TermID"}),
    #"Added Prefix" = Table.TransformColumns(#"Expanded Topic1", {{"Name", each "https://URL.com/sites/who-we-are/SitePages/" & _, type text}}),
    #"Removed Other Columns" = Table.SelectColumns(#"Added Prefix",{"Name", "Topic.TermID"}),
    #"Renamed Columns" = Table.RenameColumns(#"Removed Other Columns",{{"Topic.TermID", "Topic ID"}})
in
    #"Renamed Columns"

I'd really appreciate some help here 🙂

[sevenhills · Accepted solution]

You can start with these to get the combined source tables, and second line onwards you have to deal with GUIDs, as it is tough to understand the end goal

let
    Source = Table.Combine(
        {
        SharePoint.Tables("https://URL.com/sites/who-we-are/", [Implementation="2.0", ViewMode="All"]),
        SharePoint.Tables("https://URL.com/sites/tools-to-do-my-job/", [Implementation="2.0", ViewMode="All"]),
        SharePoint.Tables("https://URL.com/sites/our-locations/", [Implementation="2.0", ViewMode="All"]),
        SharePoint.Tables("https://URL.com/sites/how-we-work/", [Implementation="2.0", ViewMode="All"])
        }
    ), 
...
            

[MichaelHutchens]

That's super helpful, thanks @sevenhills 🙂

[sevenhills]

Glad it is helpful.