Forum Discussion

kroman's avatar
kroman
Icon for Helper II rankHelper II
1 year ago

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:...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

No need to use Web.Contents for SharePoint lists.  Use the Standard SharePoint List connector.

kroman's avatar
kroman
Icon for Helper II rankHelper II
1 year ago

And how is that supose to sort the problem?

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    1 year ago

    You will have a static Site URL  that will satisfy the "dynamic data source monster".  All the dynamic stuff can then happen as if you were using RelativePath.

    • kroman's avatar
      kroman
      Icon for Helper II rankHelper II
      1 year ago

      Its giving the same error, I started with trying to do it with Standard SharePoint List connector and thats why I tried to do it with Web.Contents

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User
        1 year ago

        In the code you posted "Source0"  is not referenced later on, so it won't be executed anyway.

         

        Please avoid sorting tables in Power Query if possible - it is a very expensive operation that breaks spooling.

         

        Can you please describe what kind of business problem you are attempting to solve?