Forum Discussion
Sharepoint connection with Web Contents
Dear all, how are you? I'm working with a project which I need to access a few Sharepoint Lists that are hosted in different Sharepoint SubSites (despite being different subsites, all of them has...
Hi jennratten and JOAOLBMARTINS
I'm in a similar situation. For me I tried to use a function to parse through SharePoint.Tables as follows, putting my root URL and the part that changes inside Web.Contents(), but I haven't had any luck doing that either. I'll keep playing around with other combinations of wrapping Web.Contents and if something works I'll let you know:
(siteURL,listname) =>
let
Source = SharePoint.Tables(Web.Contents("https://projectportal.xyzcorp.com/PWA/", [Query=[siteURL]]), [ApiVersion = 15]),
#"MyListData" = Source{[Title=listname]}[Items]
in
#"MyListData"