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.

 

4 Replies

  • PlusCTRL's avatar
    PlusCTRL
    Copper Contributor

    Hi there,

    This seems to be an old thread but Mashhad88 did you manage to find the reason why this was happening to you? I'm having exactly the same issue.

  • Hello,

    Did you create the agent using Copilot Work or Copilot Studio? Can you make a screenshot of the knowledge window?

  • Mashhad88's avatar
    Mashhad88
    Copper Contributor

    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.
  • HelloBenTeoh's avatar
    HelloBenTeoh
    Bronze Contributor

    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?

Resources