Excel Connector Issue in Copilot Studio for Agent using SharePoint as Knowledge Source

Question

I am creating a declarative agent in Copilot studio to easily access information from my team's SharePoint site. However, I am having issues with the excel connector.
I receive the error message below when asking copilot a question relating to the excel file.&nbsp;
"Error Message: The connector 'Excel Online (Business)' returned an HTTP error with code 404.&nbsp;
Below is a screenshot of the inputs I am using. Any ideas on what is causing the issue/why the excel file is not recognized?&nbsp;

&nbsp;

wpeirone-dev · Answer

Did you figured it out? I'm facing the same issue.
I tried to connect to Excel get row (Business) from the Actions section. I also tried directly from the topic from node, Add an action and then Connector (preview) with same results "Error Message: The connector 'Excel Online (Business)' returned an HTTP error with code 404. Error Code: ConnectorRequestFailure"

I'm specifying the Sharepoint url, without including https:// as I read in some other post, Document Library, File and Table. I needed to enter manually.

Thanks

mariannecherayil · Answer

Hello, yes I figured it out!
The excel file must directly be placed under "Documents" in SharePoint site for the file to be recognized.
Outputs will be automatically linked.&nbsp;

robok · Answer

So you have to move files to specified folders for an Agent to access it? That seems bizarre if true.

Forum Discussion

Excel Connector Issue in Copilot Studio for Agent using SharePoint as Knowledge Source

Share

Resources