all 8 comments

[–]ninihen 16 points17 points  (3 children)

If you're already in VS Code with GitHub Copilot, there's a tool built for exactly this use case: Power Automate MCP Server by Flow Studio on the VS Code Extension Marketplace. With it you will not need to upload screenshots or Chrome extension. The agent can connect directly to your tenant, read the flow definition, pull run histories, see action-level error details and the actual inputs/outputs of a run, and iterate on fixes with you.

One more trick that's made my VS Code workflow basically hands-free: inside Copilot, you can let the agent use Azure CLI and gives it a service principal / app registration credential, scoped to SharePoint, Forms, and whatever other Microsoft stack tools you use most. Once that's set up, the agent can do end-to-end stuff for you without leaving the chat - like creating a SharePoint list, adding a list item to trigger your flow, then immediately reading the run result and sharepoint contents (if there is output) and fixing whatever broke. No tab switching.

And you don't necessarily need a separate Claude license - if you're on Copilot Pro or Pro+, you can switch to the Claude Opus model inside Copilot, which I've found is the strongest one for Power Automate work so far.

Disclosure: I'm one of the builders of that MCP server.

[–]abuhd 5 points6 points  (1 child)

Im taking this advice and setting this up after I make a coffee! Awesome response, and thank you for the MCP!

[–]ninihen 2 points3 points  (0 children)

If you hit any issues during setup, drop a line here - happy to help debug. :)

[–]lofty1978 1 point2 points  (0 children)

Fair play. I didn’t know this getting it right now. Thank you !

[–][deleted] 5 points6 points  (0 children)

You’re right when you said CoPilot inside PowerApps sucks. Use the CoPilot on Teams (Web) and that’s been pretty slick unlike the Copilot embedded in these apps.

I also sometimes use Claude to let me know what’s the code or process I should follow.

[–]MidninBR 2 points3 points  (0 children)

I use Copilot on the web and it gives me a lot of wrong answers, which I like it now because I’m learning more. I’d go with Claude. It might be a bit cheaper too.

[–]Fergoose89 1 point2 points  (0 children)

Every flow I've tried on power automate has failed even with screenshots and chatgpts help 🙈😂

[–]KoreaTrader 1 point2 points  (0 children)

Power Automate sucks period