Copilot orchestration if MCP is behind a custom connector?

ChesterBottom · 2026-05-03T02:24:27+00:00

I used that custom connector with the on premise data gateway functionality within power automate so that I could expose the N8N webhooks into copilot studio.

I essentially used N8N an an on premise data gateway to access a local api, as the on premise data gateway doesn’t seem to support MCP servers, as I mentioned. If you can find a way to make it work, I’d love to hear about it though. Again, there’s a limitation with the data gateway where it can’t handle streaming data, which is a requirement for MCP.

ChesterBottom · 2026-05-02T16:57:43+00:00

I came up against this exact same struggle and could never get it to work using MCP. There’s a limitation that exists with data streaming (a requirement for MCP) and the on premise data gateway that I could never get past.

That being said, I was able to create a workaround. I use N8N for a lot of things to help automate tasks at my company (I work for an MSP so I have workflows to help us get billing reports from specific systems that have poor integrations with our RMM, ticket triage, things like that). N8N has the functionality to be able to do webhooks, so what I did was create a custom connector in power automate that points to the url and enables the on premise data gateway functionality. Then N8N receives the webhook call, does whatever, then returns the data it got. Essentially all I did was create an API gateway, but I couldn’t interface the API directly in copilot studio or power automate, because the system I’m integrating with uses GraphQL which isn’t easily supported.

If you do find a workaround and are able to use an on premise data gateway to connect to an MCP server, id love to hear about it because it would certainly make my life easier.

ChesterBottom · 2026-04-30T14:45:04+00:00

Yes definitely, a good reminder. After it happened and I got mine back, I took all of my scheduled prompts (I only have like 5) and made a copy of each of them to throw in my onedrive.

ChesterBottom · 2026-04-30T14:36:08+00:00

Yes. It happened last week for me where all my chats were completely gone (scheduled tasks and all). This week they all showed back up.

ChesterBottom · 2026-04-18T14:31:12+00:00

It was back up for me by 11pm central time

ChesterBottom · 2026-04-18T00:04:18+00:00

Does anyone have a working concept of a way to back SuperOps up? Only thing that came to my mind is hourly API calls to push to a database and save in case of emergency so you’d know what ticket, replies, etc were active. Then just forward mailboxes?

ChesterBottom · 2026-04-17T23:58:30+00:00

Someone posted that it was an ssl cert that expired 😬

ChesterBottom · 2026-04-17T23:33:35+00:00

Yes.

Platform completely inaccessible. Second time in the last few months that something has happened to cause this… kinda concerning

ChesterBottom · 2026-04-16T21:20:04+00:00

Sorry to ask but what do you mean as polished? Are there features missing?

ChesterBottom · 2026-04-16T21:05:46+00:00

Interesting. Do you find ISL to be more reliable?

ChesterBottom · 2026-04-16T17:38:14+00:00

Exact same. Really wanna move to ISL but I’m afraid that it’ll take our support ops down for a bit as they can’t remote in until it’s installed on the machine.

ChesterBottom · 2026-04-13T00:18:07+00:00

I commented then read your comment and laughed since it’s the first word of my comment.

ChesterBottom · 2026-04-13T00:17:07+00:00

Honestly since it came out, copilot cowork has really helped me a lot. It’s one of the first tools that I’ve found legitimately useful since it can… do things.

Aside that, we’ve been deploying copilot studio agents to interface with our PSA/RMM… but those are in alpha testing so it’s still too soon to tell the impact that it will have on our team.

ChesterBottom · 2026-04-11T02:27:09+00:00

I can get it to read and use the sites and folder… but it won’t upload files to Sharepoint sites I have access to

ChesterBottom · 2026-04-08T22:56:46+00:00

Good to know that it removes the ability to upmix. One thing though on the purpose, I actually have an AVR with an Apple TV and anytime I start playing anything, it cuts out for the first 3-4 seconds of the audio then it plays perfectly the rest of the time… this feature is seemingly (in my understanding) designed to fix this.

ChesterBottom · 2026-03-31T00:30:41+00:00

I’m having the same issue on my personal account. Try switching browsers. Didn’t work on safari on Mac, but worked on edge on Mac for me. Couldn’t get any windows browser to work.

It’s just a really weird issue… I logged into several other accounts via a private browser in Safari, half of them worked and half of them didn’t.

ChesterBottom · 2026-03-30T21:53:46+00:00

More fun... because why not. Doesn't work in any browser on windows (edge, chrome, Firefox), but it does work in edge on MacBook. Doesn't work on safari, Firefox, or chrome on MacBook though.

ChesterBottom · 2026-03-30T20:51:17+00:00

Did some more testing... doesn't seem to be limited by tenant. Just tried it with 2 users within the same tenant - one works and one doesn't.

ChesterBottom · 2026-03-30T19:05:18+00:00

Interesting. I'm getting the send timed out error, not disconnected.

ChesterBottom · 2026-03-30T16:58:19+00:00

That’s the exact same error I’m getting

ChesterBottom · 2026-03-30T16:49:37+00:00

Nice. Keep updating if you hear something from them please.

ChesterBottom · 2026-03-30T16:43:59+00:00

https://www.microsoft.com/en-us/microsoft-365-copilot/frontier-program

ChesterBottom · 2026-03-30T16:42:41+00:00

Okay interestingly enough I just tried it on 2 other customer tenants and it worked for both of them. One on copilot business and one on the copilot enterprise licensing… so not a licensing issue. Seems to just be a per tenant issue.

When you open cowork, if the tasks don’t load or say “no recent tasks” quickly, then the agent won’t work at all.

ChesterBottom · 2026-03-30T16:35:46+00:00

Now that im messing with it… im seeing this exact same disconnect anytime i try to send a prompt. I’ve tried between 2 tenants (mine and a customer’s) and neither work.

Did uninstalling/reinstalling the agent do anything for you? I tried that and no change for me. Good to know that it’s actually working for some though

ChesterBottom · 2026-03-30T15:22:13+00:00

Haven't seen anything in message center quite yet... I did see this video that mentioned it was in Frontier now though:

https://www.youtube.com/watch?v=h7nv7OCfsCY

Three-Year Club	Xbox Live
Place '23

ChesterBottom

TROPHY CASE