Connecting to a Single Excel File on Sharepoint

Question

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.

anonymous · Answer

Hi&nbsp;j_ocean&nbsp;Open the Excel file in SharePoint and copy the File path (File-&gt;Info) and delete the "?web=1", then change the Source to this, it should be workingExcel.Workbook(Web.Contents("https://company.sharepoint.com/sites/XXXX.xlsx"))&nbsp;

j_ocean · Answer

What connector do I use with that?

anonymous · Answer

Hi&nbsp;j_ocean&nbsp;&nbsp;From Web, or blank query

j_ocean · Answer

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

v-kkf-msft · Answer

Hi&nbsp;j_ocean&nbsp;,
&nbsp;
You can use SharePoint folder or Web Connector to connect a single excel.
&nbsp;
1. SharePoint&nbsp;folder.
&nbsp;

&nbsp;
2.&nbsp;Web Connector.
&nbsp;
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.
&nbsp;
&nbsp; 
&nbsp;
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.
&nbsp;