Labsco
ninihen1 logo

Flow Studio - Power Automate MCP Server

โ˜… 20

from ninihen1

Debug, build, and manage Microsoft Power Automate cloud flows with AI agents. 15 tools for action-level error details, flow creation, run history, and multi-tenant operations.

๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿ”ฅโœ“ VerifiedFreeNeeds API keys

FlowStudio MCP โ€” Power Automate Skills for AI Agents

Give your AI agent the same visibility you have in the Power Automate portal โ€” plus a bit more. The Graph API only returns top-level run status โ€” agents can't see action inputs, loop iterations, or nested failures. Flow Studio MCP exposes all of it.

Agent debugging a Power Automate flow via MCP

You can click through the portal and find the root cause. Your agent can't โ€” unless it has MCP.

The portal shows everything to a human โ€” but agents only see the top-level error via Graph API

With Flow Studio MCP, the agent sees what you see

When you need this

  • Your agent can see that a flow failed, but not why โ€” Graph API only returns status codes
  • You want your agent to see action-level inputs and outputs, like you can in the portal
  • A loop has hundreds of iterations and some produced bad output โ€” in the portal you'd click through each one, but the agent can scan all iteration inputs and outputs at once
  • You want to check flow health, failure rates, and maker activity across your tenant without opening the admin center
  • You need to classify flows, detect orphaned resources, or audit connectors at scale โ€” without installing the CoE Starter Kit
  • You're tired of being the middle-man between your agent and the portal

Graph API vs Flow Studio MCP

The core difference: Graph API gives your agent run status. MCP gives your agent the inputs and outputs of every action.

What the agent seesGraph APIFlow Studio MCP
Run passed or failedYesYes
Action inputs and outputsNoYes
Error details beyond status codeNoYes
Child flow run detailsNoYes
Loop iteration dataNoYes
Flow definition (read + write)LimitedFull JSON
Resubmit / cancel runsLimitedYes
Cached flow health & failure ratesNoYes
Maker / Power Apps / connection inventoryNoYes
Governance metadata (tags, impact, owner)NoYes

Skills

SkillDescription
power-automate-mcpConnect to and operate Power Automate cloud flows โ€” list flows, read definitions, check runs, resubmit, cancel
power-automate-debugStep-by-step diagnostic process for investigating failing flows
power-automate-buildBuild, scaffold, and deploy Power Automate flow definitions from scratch
power-automate-monitoringFlow health, failure rates, maker inventory, Power Apps, environment and connection counts
power-automate-governanceClassify flows by impact, detect orphans, audit connectors, manage notifications, compute archive scores

The first three skills use live Power Automate API calls. The monitoring and governance skills use the cached store โ€” a daily snapshot with aggregated stats, remediation hints, and governance metadata. Requires a FlowStudio for Teams or MCP Pro+ subscription for store tools.

Each skill follows the Agent Skills specification and works with any compatible agent.

Supported agents

Copilot, Claude Code, Codex, OpenClaw, Gemini CLI, Cursor, Goose, Amp, OpenHands

Real debugging examples

These are from real production investigations, not demos.

  • Expression error in child flow โ€” contains(string(...)) crashed on a nested property. Agent traced through parent flow, into child, through loop iterations, and found the failing input. Portal showed "ExpressionEvaluationFailed" with no context.

  • Data entry, not a flow bug โ€” User reported two "bugs" back to back. Agent proved both were data entry errors (missing comma in email, single address in CC field). Flow was correct. Diagnosed in seconds.

  • Null value crashes child flow โ€” split(Name, ', ') crashed when 38% of records had null Names. Agent traced parent to child to loop to action, found the root cause, and deployed a fix via update_live_flow.

Repository structure

Copy & paste โ€” that's it
skills/
  power-automate-mcp/          core connection & operation skill
  power-automate-debug/        debug workflow skill
  power-automate-build/        build & deploy skill
  power-automate-monitoring/   flow health & tenant inventory skill
  power-automate-governance/   compliance & governance skill
examples/                      real debugging walkthroughs
README.md
LICENSE                        MIT

Available on GitHub

Works with Copilot, Claude, and any MCP-compatible agent.

Contributing

Contributions welcome. Each skill folder must contain a SKILL.md with the required frontmatter. See the existing skills for the format.

License

MIT


Keywords: Power Automate debugging, flow run history, expression evaluation failed, child flow failure, nested action errors, loop iteration output, agent automation MCP, Power Platform AI, flow definition deploy, resubmit failed run, flow monitoring, governance, CoE, orphan detection, connector audit, archive score, maker inventory