Forum Discussion

akhaliq7's avatar
akhaliq7
Icon for Post Prodigy rankPost Prodigy
3 years ago
Solved

SharePoint runs slow when loading from folder

So I am trying to connect to the sharepoint folder to access data, but the refresh is really slow once I apply all the steps. First there are 70000 rows/files that load from my sharepoint. When I sea...
Need Help
  • lbendlin's avatar
    lbendlin
    3 years ago

    Experiment with Table.Buffer

akhaliq7's avatar
akhaliq7
Icon for Post Prodigy rankPost Prodigy
3 years ago

I ended up using sharepoint.contents instead of the default for the sharepoint folder connection

Einomi's avatar
Einomi
Icon for Helper V rankHelper V
3 years ago

To use SharePoint.Contents is recommended by Wyn hopkins instead of SharePoint.Files/Folder

  • akhaliq7's avatar
    akhaliq7
    Icon for Post Prodigy rankPost Prodigy
    3 years ago

    Yeh that is how I know this function seen his video on connecting to sharepoint folder also it does make a big difference in processing speed.

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      3 years ago

      Technically SharePoint.Contents should be slower as it requires more steps to get to your data.  You may have more luck with the API, or at least with using ODATA filters.

      • akhaliq7's avatar
        akhaliq7
        Icon for Post Prodigy rankPost Prodigy
        3 years ago

        Ok I'll check those options out thanks