Repeated Connection Prompts and "Send Failed. Retry" Errors When Using SharePoint Lists in Copilot

Question

Hi everyone,

I'm working on integrating SharePoint lists as a knowledge source in a Copilot agent. The setup works initially, but I'm encountering persistent issues when testing the agent or accessing it via Microsoft Teams/SharePoint site after publishing.

Issue Details:

Initial Connection Prompt: When I first test the agent or access it from Teams/Site, it prompts me to connect to the SharePoint data source. This is expected and works fine. Repeated Prompts: After the initial connection, the agent repeatedly asks me to reconnect to the SharePoint list, even within the same session. This happens multiple times during a single conversation. Error Message: Frequently, I receive the error message: "Send failed. Retry" This disrupts the conversation and makes the agent unreliable for end users. After 2-3 retry it worked Expected Behavior: I expect the connection to persist once authenticated, and for the agent to access the SharePoint list seamlessly throughout the session.

What I’ve Tried:

Verified that the SharePoint list is correctly configured and accessible. Ensured that the data source connection is added and published in the Copilot Studio. Tested in both the Copilot Studio test environment and Microsoft Teams and its working fine on Copilot Studio test environment.

Questions:

Is this a known issue with SharePoint list integration in Copilot agents? Are there any best practices to ensure persistent authentication or session handling? Could this be related to Teams-specific permissions or token expiration? Any workarounds or configuration changes that could help resolve this?

Any help or guidance would be greatly appreciated!

Thanks in advance.Hi everyone,

I'm working on integrating SharePoint lists as a knowledge source in a Copilot agent. The setup works initially, but I'm encountering persistent issues when testing the agent or accessing it via Microsoft Teams/SharePoint site after publishing.

Issue Details:

Initial Connection Prompt: When I first test the agent or access it from Teams/Site, it prompts me to connect to the SharePoint data source. This is expected and works fine.

Repeated Prompts: After the initial connection, the agent repeatedly asks me to reconnect to the SharePoint list, even within the same session. This happens multiple times during a single conversation.

Error Message: Frequently, I receive the error message:
"Send failed. Retry"
This disrupts the conversation and makes the agent unreliable for end users. After 2-3 retry it worked

Expected Behavior: I expect the connection to persist once authenticated, and for the agent to access the SharePoint list seamlessly throughout the session.

What I’ve Tried:

Verified that the SharePoint list is correctly configured and accessible.

Ensured that the data source connection is added and published in the Copilot Studio.

Tested in both the Copilot Studio test environment and Microsoft Teams and its working fine on Copilot Studio test environment.

Questions:

Is this a known issue with SharePoint list integration in Copilot agents?

Are there any best practices to ensure persistent authentication or session handling?

Could this be related to Teams-specific permissions or token expiration?

Any workarounds or configuration changes that could help resolve this?

Any help or guidance would be greatly appreciated!

Thanks in advance.

Answer 1

Hi @Kumbhar, Kanchan

Thank you for posting your question in the Microsoft Q&A forum.    

Based on the information you have provided, looks like you want to retrieve the list data from SharePoint. 

I understand how this feature could be handy for you and your colleagues. 

However, Copilot agent doesn't support SharePoint List currently. 

You can read more at Frequently asked questions about Copilot in SharePoint - Microsoft Support 

For the workaround, I found that you can create a power automate flow to retrieve SharePoint List. Since Power Automate is beyond my knowledge, I'll try my best to help you. 

You can visit Microsoft Power Platform Community Forum Thread so the specialist can assist you better than me. 

I hope this information helps. 

Thank you for your understanding. 

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".   

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi Kumbhar,
You're facing repeated SharePoint connection prompts and “Send failed. Retry” errors because of token/session issues—especially in Teams or SharePoint-embedded Copilot contexts.

Root Cause:

Auth tokens expire or aren't passed properly in Teams.

Delegated connections don't persist reliably across sessions or surfaces.

Fixes:

• Use delegated user permissions, not app-only.
• Prompt early for SharePoint connection using AskForConnection.
• Use retry logic with delays on failures.
• Ensure proper Teams/SharePoint site permissions.
• Always test in Teams, not just Studio.

Thanks,
Ayush

If the response is helpful, please click "Accept Answer" and upvote it. You can share your feedback via Microsoft Teams Developer Feedback](https://aka.ms/DevSupportFeedback)"https://aka.ms/devsupportfeedback)") link. Click here](https://aka.ms/DevCommunityEscalationForm)"https://aka.ms/devcommunityescalationform)") to escalate.