Connecting to a Single Excel File on Sharepoint

[j_ocean]

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 do I connect to just one file at a time?

I tried the web connector but that doesn't connect.

[v-kkf-msft]

Hi @j_ocean ,

You can use SharePoint folder or Web Connector to connect a single excel.

1. SharePoint folder.

2. Web Connector.

Follow the steps below to get the file path directly from SharePoint Online:

• Select the Excel file
• Click Details
• In the Details pane, scroll down in the pane to find the Path section
• Click the Copy Direct Link button

Then paste the link into the Web connector, and log in to your SharePoint account.

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Vera_33]

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]

What connector do I use with that?

[Vera_33]

Hi @j_ocean 

From Web, or blank query

[j_ocean]

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