Forum Discussion

MarianneCherayil's avatar
MarianneCherayil
Icon for Microsoft rankMicrosoft
Feb 19, 2025

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

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 be...
copilot in excel
Copilot in SharePoint
wpeirone-dev's avatar
wpeirone-dev
Copper Contributor
Feb 26, 2025

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's avatar
MarianneCherayil
Icon for Microsoft rankMicrosoft
Feb 28, 2025

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. 

  • RobOK's avatar
    RobOK
    Bronze Contributor
    Mar 05, 2025

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

    • miosu's avatar
      miosu
      Copper Contributor
      Mar 18, 2025

      I still have the error, even connecting to the root path of the default documents library. Would be strange, if this is the cause. Url, Library and file can be chosen manually. 

      I have a 404 Excel Online (Business) HTTP error ConnectorRequestFailure with no additional information ;( MarianneCherayil, any idea?

      • webedge's avatar
        webedge
        Copper Contributor
        Apr 10, 2025

        im facing the same issue, any updates on this?

Resources