Forum Discussion

MichaelHutchens's avatar
MichaelHutchens
Helper V
4 years ago
Solved

Adding multiple SharePoint libraries to a query

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 🙂

Need Help
  • sevenhills's avatar
    sevenhills
    4 years ago

    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"])
        }
    ), 
...

     

3 Replies

  • sevenhills's avatar
    sevenhills
    Super User
    4 years ago

    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"])
        }
    ), 
...