Results 1 to 2 of 2

Thread: Can I use Power Query to read a SharePoint text table

  1. #1
    Neophyte mike_1946's Avatar
    Join Date
    Jun 2019
    Posts
    2
    Articles
    0
    Excel Version
    excel 2016

    Can I use Power Query to read a SharePoint text table



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,

    I've been using power query from Excel extensively to get data from excel workbooks and databases, but this is my first attempt to read a SharePoint text table from a SharePoint page that is several pages deep. I've attached a .jpg pic of what I would like to read.

    Any help would be very much appreciated.

    Thanks,
    Mike
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	POC SharePoint Table.jpg 
Views:	14 
Size:	73.3 KB 
ID:	9157  

  2. #2
    Neophyte mike_1946's Avatar
    Join Date
    Jun 2019
    Posts
    2
    Articles
    0
    Excel Version
    excel 2016
    I've been able to get to the specific SharePoint page with the following code. But after expanding and searching all of the columns I've not been able to determine how to access the details of the page.

    let
    Source = SharePoint.Tables("https://-----------.sharepoint.com/sites/EA/", [ApiVersion = 15]),
    #"ca99c2c3-e701-4a86-aa7f-63cf025f3048" = Source{[Id="ca99c2c3-e701-4a86-aa7f-63cf025f3048"]}[Items],
    #"Renamed Columns" = Table.RenameColumns(#"ca99c2c3-e701-4a86-aa7f-63cf025f3048",{{"ID", "ID.1"}}),
    #"Filtered Rows" = Table.SelectRows(#"Renamed Columns", each ([Title] = "POC Inventory"))
    in
    #"Filtered Rows

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •