MCP request successful but output not loaded into Sharepoint

(2) Share

Report

Posted on by CU05110824-0

I made an agent in Copilot Studio. I published it to Sharepoint Channel (this is an information). I had clicked approve and set as default agent. I tried it in Sharepoint but why there was no response (picture 1)? I checked it in Copilot Studio Transcript Activity, turns out MCP had been returning a response (picture 2). but why it was not loaded into Sharepoint Agent? Agent and Sharepoint are in the same tenant

Categories:

Publish & channel management

Bot administration

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

Valantis 6,735 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @CU05110824-0,

they pinpoint the issue. The MCP tool works (no error in transcript), but SharePoint/M365 Copilot discards the raw output and shows blank because it's not converted to plain text first (per Microsoft MCP docs).
Quick fix to apply:
Added message node after MCP to output plain text from the tool result.
Republished SharePoint channel and test in new chat. (wait few minutes to update)

Was this reply helpful? Yes No
CU05110824-0 56 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Valantis, could you please explain the detail? What do you mean by adding message node after MCP? Because I try it from Microsoft Teams and it works well without any additional message node configuration. I use External Agent from Fabric Data Agent as the MCP Tool. Thanks in advance

Was this reply helpful? Yes No
Suggested answer

Valantis 6,735 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @CU05110824-0,

First I want to apologize, my previous suggestion about adding a message node to convert the output to plain text was wrong and I am sorry for the confusion.

Looking at your transcript, the MCP call completes successfully and isError is false, so the tool itself is working correctly.

The blank output in SharePoint is likely related to how the SharePoint channel handles the output type coming back from the MCP tool. In your transcript the output is returning as a Table type. The SharePoint channel may not be able to render that directly the way Teams does.

Try this first: inside your topic, after the MCP tool call, add a message node and reference the content output variable from the MCP response directly in the message text. This forces the agent to explicitly surface the result as a message instead of relying on the channel to render the raw tool output automatically.

Republish and test in a fresh chat in SharePoint.

If that does not work, to help identify the exact cause I need a few things from you:

1. Can you share a screenshot of the MCP tool output schema inside Copilot Studio, specifically what variable type the content output is defined as?
2. Does the SharePoint chat show completely blank, a loading indicator that stops, or any kind of fallback message?
3. Is generative orchestration enabled in your agent settings?
4. When you test inside the Copilot Studio test pane directly, does it render the response correctly there as well, or only in Teams?

Best regards,

Valantis

✅ If this helped solve your issue, please Accept as Solution so others can find it quickly.

❤️ If it didn’t fully solve it but was still useful, please click “Yes” on “Was this reply helpful?” or leave a Like :).

🏷️ For follow-ups @Valantis.

📝 https://valantisond365.com/

Was this reply helpful? Yes No
CU05110824-0 56 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Valantis

1. Can you share a screenshot of the MCP tool output schema inside Copilot Studio, specifically what variable type the content output is defined as?

sure, this is the raw output

{
"messageDeeplink": "https://app.fabric.microsoft.com/groups/<workspace-id>/aiskills/<artifact-id>/stage/published/threads/thread_<thread-id>/runs/run_<run-id>/question/msg_<msg-id>/source/mcs",
"isError": false, ##type : boolean##
"content": [
{
"annotations": null,
"meta": null,
"text": "<generated answer from Fabric Data Agent>", ##type : string##
"type": "text"
}
]
}

2. Does the SharePoint chat show completely blank, a loading indicator that stops, or any kind of fallback message?

technically, SharePoint chat does not return anything, not even a fallback message

3. Is generative orchestration enabled in your agent settings?

Yes, it is, as you can see below

4. When you test inside the Copilot Studio test pane directly, does it render the response correctly there as well, or only in Teams?

Yes, it does

Was this reply helpful? Yes No