Agregar varias bibliotecas de SharePoint a una consulta

[Syndicate_Admin]

Hola amigos, estoy intentando agregar varias bibliotecas de SharePoint a la misma consulta. Aquí están mis bibliotecas:

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/

Y aquí está mi código actual, basado en una sola biblioteca:

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"

Realmente agradecería un poco de ayuda aquí 🙂

[Syndicate_Admin · Accepted solution]

Puede comenzar con estos para obtener las tablas de origen combinadas, y en la segunda línea en adelante, debe lidiar con guid, ya que es difícil comprender el objetivo final.

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

[Syndicate_Admin]

Eso es súper útil, gracias @sevenhills 🙂

[Syndicate_Admin]

Me alegro de que sea útil.