Forum Discussion
Getting 'One or more table references a dynamic Data Source' even with Web.Contents with Relativepat
Hi All I have a simple query where trying to get a site url from one item in SP list and then get files list from that site, by following code: let
Source0 = Json.Document(Web.Contents("https:...
I see. So you have a SharePoint list that contains a list of sharepoint sites. You filter the list by a certain criteria and are then attempting to list all the files of the first site in that list.
Source = SharePoint.Files(TheSite,
That then triggers the dynamic source warning, and rightfully so.
How big is the list? I would try not to use the Table.First filter, at least not at that point). Maybe for each list item add the SharePoint.Files table object as a custom column, and only then say "Keep first row".
Nothing to do with filtering, I tried loading site url as single value from another website with
Source = SharePoint.Files(Text.FromBinary(Web.Contents("https://SomeSite.net/thelink.html" )) , [ApiVersion = 15]),but still getting same problem
Understand. What if you have a static list of sites?