Forum Discussion

j_ocean's avatar
j_ocean
Icon for Helper V rankHelper V
5 years ago

Connecting to a Single Excel File on Sharepoint

I can connect to my SharwePoint site library just fine using the sharepoint folder connector. I need one file but the only option is to "combine", which adds many helper queriesa nd parameters. How d...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi j_ocean 

Open the Excel file in SharePoint and copy the File path (File->Info) and delete the "?web=1", then change the Source to this, it should be working

Excel.Workbook(Web.Contents("https://company.sharepoint.com/sites/XXXX.xlsx"))

 

  • j_ocean's avatar
    j_ocean
    Icon for Helper V rankHelper V
    5 years ago

    What connector do I use with that?

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi j_ocean 

       

      From Web, or blank query

      • j_ocean's avatar
        j_ocean
        Icon for Helper V rankHelper V
        5 years ago

        Ah. Well I know that won't work here. Thanks though.