Can I use Power Query to read a SharePoint text table

mike_1946

New member
Joined
Jun 11, 2019
Messages
2
Reaction score
0
Points
0
Excel Version(s)
excel 2016
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
 

Attachments

  • POC SharePoint Table.jpg
    POC SharePoint Table.jpg
    73.3 KB · Views: 16
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
 
Back
Top