Forum Discussion

Mashhad88's avatar
Mashhad88
Copper Contributor
Dec 07, 2024

Copilot Sharepoint Agent (not answering queries)

Step: 1


I have created a "Sharepoint Agent" by selecting a file from sharepoint.

 

Step: 2

When i am asking any question from Agent, but not getting response.

Problem statement:

I am not getting no response from Sharepoint agent when asking anything. It says: 
 

"I apologize, but I couldn't find the specific target for January 2024 in the available documents. If you have any other questions or need assistance with something else, please let me know!"

 

or

I apologize, but I couldn't find the specific region-wise targets in the available documents. If you have any other questions or need assistance with something else, please let me know!

 

Data Structure

 

Can anyone please support on this, urgent support is required.

 

Copilot in SharePoint
  • HelloBenTeoh's avatar
    HelloBenTeoh
    Bronze Contributor
    Dec 13, 2024

    Hey, a few questions:

    • Does the spreadsheet work when you use the default agent in SharePoint?
    • Are there any sensitivity labels that may affect Copilot's access?
    • How many docs do you have in the folder/site? It may be having trouble if you're not specifying which file to look at in your prompt
    • It shouldn't be an issue, but have you tried with a smaller data set?
  • Mashhad88's avatar
    Mashhad88
    Copper Contributor
    Dec 20, 2024

    Hi HelloBenTeoh,
    Thank you, responses are mentioned against questions asked by you:

    • Does the spreadsheet work when you use the default agent in SharePoint?
      Response: When I attached excel file from copilot.microsoft.com, I get the responses. But when i create a Copilot agent it shows the above message. i.e.

      "I apologize, but I couldn't find the specific region-wise targets in the available documents. If you have any other questions or need assistance with something else, please let me know!"

    • Are there any sensitivity labels that may affect Copilot's access?
      Response: There are no sensitivity labels that effect Copilot's access.

    • How many docs do you have in the folder/site? It may be having trouble if you're not specifying which file to look at in your prompt
      Response: There is only 1 file in folder, however the Copilot agent is created by selecting that excel file only.
    • It shouldn't be an issue, but have you tried with a smaller data set?
      I have tried it with the smaller data set, getting the same result.

Resources