Now liveThe Skillselion MCP - thousands of ranked skills, loaded into your agent mid-task. No install.Get it →
github avatar

Flowstudio Power Automate Mcp

  • 4.1k installs
  • 37.1k repo stars
  • Updated July 28, 2026
  • github/awesome-copilot

flowstudio-power-automate-mcp is an agent skill: >-

About

The flowstudio-power-automate-mcp skill >-. Power Automate via FlowStudio MCP — Foundation This skill is the **plumbing layer**. It gives an AI agent a reliable way to talk to a FlowStudio MCP server, discover what tools are available, and handle the responses cleanly. The actual workflow narratives live in four specialized skills that all build on this one. > **Real debugging examples**: [Expression error in child flow](https://github.com/ninihen1/power-automate-mcp-skills/blob/main/examples/fix-expression-error.md) | > [Data entry, not a flow bug](https://github.com/ninihen1/power-automate-mcp-skills/blob/main/examples/data-not-flow.md) | > [Null value crashes child flow](https://github.com/ninihen1/power-automate-mcp-skills/blob/main/examples/null-child-flow.md) > **Requires:** A [FlowStudio](https://mcp.flowstudio.app) MCP subscription (or > compatible Power Automate MCP server). Agents should read SKILL.md quick start steps, verify required binaries and environment variables, and follow reference files for exact parameters before calling tools. The workflow includes decision gates, anti-patterns, and cross-links to sibling skills so agents stay aligned with upstream documenta.

  • Covers flowstudio-power-automate-mcp quick start, workflow steps, and reference pointers from SKILL.md.
  • Tagged for stage build and subphase integrations in the closed Skillselion taxonomy.
  • Documents prerequisites, permissions network, shell, and compatible agents.
  • Includes AEO tagMeta with task queries, keywords, and evidence quotes for discovery.
  • Cross-links related skills and generated REFERENCE.md tables where the repo provides them.

Flowstudio Power Automate Mcp by the numbers

  • 4,120 all-time installs (skills.sh)
  • +30 installs in the week ending Jul 28, 2026 (Skillselion tracking)
  • Ranked #91 of 2,742 Automation & Workflows skills by installs in the Skillselion catalog
  • Security screen: HIGH risk (skills.sh audit)
  • Data as of Jul 28, 2026 (Skillselion catalog sync)
At a glance

flowstudio-power-automate-mcp capabilities & compatibility

Capabilities
flowstudio power automate mcp documented workflo · quick start examples · reference parameter lookup · taxonomy aligned metadata · aeo discovery fields
Works with
azure
Use cases
orchestration · project management
From the docs

What flowstudio-power-automate-mcp says it does

>-
SKILL.md
npx skills add https://github.com/github/awesome-copilot --skill flowstudio-power-automate-mcp

Add your badge

Show developers this skill is listed on Skillselion. Paste this into your README.

Listed on Skillselion
Installs4.1k
repo stars37.1k
Security audit2 / 3 scanners passed
Last updatedJuly 28, 2026
Repositorygithub/awesome-copilot

How do I run flowstudio-power-automate-mcp correctly without guessing steps, tools, or parameters?

>-

Who is it for?

Teams using flowstudio-power-automate-mcp when SKILL.md triggers match the user request.

Skip if: Skip when the task is outside flowstudio-power-automate-mcp documented triggers or sibling skill scope.

When should I use this skill?

User mentions flowstudio-power-automate-mcp, related trigger phrases, or asks to follow this SKILL.md workflow.

What you get

Completed flowstudio-power-automate-mcp workflow with outputs and checks defined in SKILL.md.

  • flowstudio-power-automate-mcp output per SKILL.md

By the numbers

  • Stage build/integrations
  • Category Automation & Workflows
  • Complexity intermediate

Files

SKILL.mdMarkdownGitHub ↗

Power Automate via FlowStudio MCP — Foundation

This skill is the plumbing layer. It gives an AI agent a reliable way to talk to a FlowStudio MCP server, discover what tools are available, and handle the responses cleanly. The actual workflow narratives live in four specialized skills that all build on this one.

Real debugging examples: Expression error in child flow |
Data entry, not a flow bug |
Null value crashes child flow
Requires: A FlowStudio MCP subscription (or
compatible Power Automate MCP server). You will need:
- MCP endpoint: https://mcp.flowstudio.app/mcp (same for all subscribers)
- API key / JWT token (x-api-key header — NOT Bearer)
- Power Platform environment name (e.g. Default-<tenant-guid>)

---

Which Skill to Use When

Skills are organized by use-case intent, not by which tools they call. Multiple skills reuse the same underlying tools — pick by what the user is trying to accomplish.

The user wants to…Load this skill
Make or change a flow (build new, modify existing, fix a bug, deploy)`flowstudio-power-automate-build`
Diagnose why a flow failed (root cause analysis on a failing run)`flowstudio-power-automate-debug`
See tenant-wide flow health, failure rates, asset inventory`flowstudio-power-automate-monitoring` (Pro+)
Tag, audit, classify, score, or offboard flows`flowstudio-power-automate-governance` (Pro+)
Just connect, set up auth, write the helper, parse responsesthis skill (foundation)

Same tools, different lenses. flowstudio-power-automate-build and flowstudio-power-automate-debug both call update_live_flow, get_live_flow, and the run-error tools — they differ in direction (forward vs backward) and intent (compose vs diagnose). flowstudio-power-automate-monitoring and flowstudio-power-automate-governance both call the Store tools — they differ in audience (ops vs compliance) and outcome (read health vs write metadata). Don't try to memorize "which tools belong to which skill"; pick the skill by what the user is doing.

---

Source of Truth

PrioritySourceCovers
1Real API responseAlways trust what the server actually returns
2`tool_search` / `list_skills`Authoritative tool schemas, parameter names, types, required flags
3SKILL docs & reference filesWorkflow narrative, response shapes, non-obvious behaviors

If documentation disagrees with a real API response, the API wins. Tool schemas in this skill (or any other) may lag the server — call tool_search to confirm the current shape before invoking a tool you haven't used recently.

---

How Agents Discover Tools

The FlowStudio MCP server (v1.1.5+) exposes two non-billable meta-tools that let an agent load only the tools relevant to the current task. Use these in preference to tools/list (which loads all 30+ schemas at once) or guessing tool names.

Meta-toolWhen to call
list_skillsCold start — see the available bundles (build-flow, create-flow, debug-flow, monitor-flow, discover, governance) and pick one
tool_search with query: "skill:<name>"Load the full schema set for one bundle (e.g. skill:debug-flow)
tool_search with query: "select:tool1,tool2"Load specific tools by name (e.g. when chaining across bundles)
tool_search with query: "<keywords>"Free-text search when the user request is ambiguous (e.g. "cancel run")

The server's tool_search bundles are intentionally narrower than this skill family — they're starter packs of the most-likely-needed tools per intent. A workflow skill (e.g. flowstudio-power-automate-debug) may pull a bundle and then call tool_search again for additional tools as the workflow progresses.

# Cold start — pick a bundle by intent
skills = mcp("list_skills", {})
# [{"name": "debug-flow", "description": "Investigate why a flow is failing...",
#   "tools": ["get_live_flow_runs", "get_live_flow_run_error", ...]}, ...]

# Load schemas for the bundle
debug_tools = mcp("tool_search", {"query": "skill:debug-flow"})

Current common bundles:

BundleUse when
create-flowCreating a brand-new flow; includes environment/connection discovery, connector description, dynamic options, and update_live_flow
build-flowReading or modifying an existing flow definition
debug-flowInvestigating failed runs and action-level inputs/outputs
monitor-flowStarting/stopping, triggering, cancelling, or resubmitting runs
discoverEnumerating environments, flows, and connections
governancePro+ cached-store tagging, maker audit, and metadata updates

---

Recommended Language: Python or Node.js

All examples in this skill family use Python with `urllib.request` (stdlib — no pip install needed). Node.js is an equally valid choice: fetch is built-in from Node 18+, JSON handling is native, and async/await maps cleanly onto the request-response pattern of MCP tool calls — making it a natural fit for teams already working in a JavaScript/TypeScript stack.

LanguageVerdictNotes
PythonRecommendedClean JSON handling, no escaping issues, all skill examples use it
Node.js (≥ 18)RecommendedNative fetch + JSON.stringify/JSON.parse; no extra packages
PowerShellAvoid for flow operationsConvertTo-Json -Depth silently truncates nested definitions; quoting and escaping break complex payloads. Acceptable for a quick connectivity smoke-test but not for building or updating flows.
cURL / BashPossible but fragileShell-escaping nested JSON is error-prone; no native JSON parser
TL;DR — use the Core MCP Helper (Python or Node.js) below. Both handle
JSON-RPC framing, auth, and response parsing in a single reusable function.

---

Core MCP Helper (Python)

Use this helper throughout all subsequent operations:

import json, urllib.request

TOKEN = "<YOUR_JWT_TOKEN>"
MCP   = "https://mcp.flowstudio.app/mcp"

def mcp(tool, args, cid=1):
    payload = {"jsonrpc": "2.0", "method": "tools/call", "id": cid,
               "params": {"name": tool, "arguments": args}}
    req = urllib.request.Request(MCP, data=json.dumps(payload).encode(),
        headers={"x-api-key": TOKEN, "Content-Type": "application/json",
                 "User-Agent": "FlowStudio-MCP/1.0"})
    try:
        resp = urllib.request.urlopen(req, timeout=120)
    except urllib.error.HTTPError as e:
        body = e.read().decode("utf-8", errors="replace")
        raise RuntimeError(f"MCP HTTP {e.code}: {body[:200]}") from e
    raw = json.loads(resp.read())
    if "error" in raw:
        raise RuntimeError(f"MCP error: {json.dumps(raw['error'])}")
    text = raw["result"]["content"][0]["text"]
    return json.loads(text)
Common auth errors:
- HTTP 401/403 → token is missing, expired, or malformed. Get a fresh JWT from mcp.flowstudio.app.
- HTTP 400 → malformed JSON-RPC payload. Check Content-Type: application/json and body structure.
- MCP error: {"code": -32602, ...} → wrong or missing tool arguments. Call tool_search with select:<toolname> to confirm the schema.

---

Core MCP Helper (Node.js)

Equivalent helper for Node.js 18+ (built-in fetch — no packages required):

const TOKEN = "<YOUR_JWT_TOKEN>";
const MCP   = "https://mcp.flowstudio.app/mcp";

async function mcp(tool, args, cid = 1) {
  const payload = {
    jsonrpc: "2.0",
    method: "tools/call",
    id: cid,
    params: { name: tool, arguments: args },
  };
  const res = await fetch(MCP, {
    method: "POST",
    headers: {
      "x-api-key": TOKEN,
      "Content-Type": "application/json",
      "User-Agent": "FlowStudio-MCP/1.0",
    },
    body: JSON.stringify(payload),
  });
  if (!res.ok) {
    const body = await res.text();
    throw new Error(`MCP HTTP ${res.status}: ${body.slice(0, 200)}`);
  }
  const raw = await res.json();
  if (raw.error) throw new Error(`MCP error: ${JSON.stringify(raw.error)}`);
  return JSON.parse(raw.result.content[0].text);
}
Requires Node.js 18+. For older Node, replace fetch with https.request
from the stdlib or install node-fetch.

---

Verify the Connection

A 3-line smoke test that confirms the token, endpoint, and helper all work:

skills = mcp("list_skills", {})
print(f"Connected — {len(skills)} skill bundles available:",
      [s["name"] for s in skills])

Expected output:

Connected — 6 skill bundles available: ['build-flow', 'create-flow', 'debug-flow', 'monitor-flow', 'discover', 'governance']

If this fails, see the Common auth errors note above. If it succeeds, hand off to the workflow skill matching the user's intent.

---

Handling Oversized Responses

Some MCP tool responses are large enough to overflow the agent's context window:

ToolTypical sizeCause
describe_live_connector100-600 KBFull Swagger spec for a connector
get_live_dynamic_properties50-500 KBDynamic connector field schemas such as SharePoint list columns
get_live_flow_run_action_outputs (no actionName)50 KB – several MBTop-level action outputs; with an action in a foreach, every repetition can be returned
get_live_flow (large flows)50-500 KBDeeply nested branches
list_live_flows (large tenants)50-200 KBHundreds of flow records

When the harness spills to a file

Agent harnesses (Claude Code, VS Code Copilot, etc.) save oversized responses to a temp file (e.g. tool-results/mcp-flowstudio-describe_live_connector-NNNN.txt) and return the path instead of the inline JSON. The file is double-wrapped — the outer MCP envelope plus the inner JSON-escaped payload:

[{"type":"text","text":"<JSON-escaped payload>"}]

Two parses to reach a usable object:

import json
with open(path) as f:
    raw = json.loads(f.read())
payload = json.loads(raw[0]["text"])
$payload = ((Get-Content $path -Raw | ConvertFrom-Json)[0].text) | ConvertFrom-Json

Rules of thumb

1. Extract, don't echo. Pull the specific field(s) you need (one operationId, one action's outputs) and discard the rest before reasoning about it. 2. Always pass `actionName` to `get_live_flow_run_action_outputs`. Omitting it fetches all top-level actions. For actions inside a foreach, passing actionName without iterationIndex can return every repetition of that action. 3. Reuse the spill file within a session. Refetching the same connector swagger costs 30+ seconds and produces another spill — cache the path. 4. Don't grep the spill file for JSON keys directly. Strings are JSON-escaped inside the file (\"OperationId\":), so a plain grep for "OperationId": will not match. Parse first, then filter. 5. Summarize tool output to the user. Echo name + state + trigger for flow lists and actionName + status + code for run errors — not raw JSON, unless asked.

# Good — drill into one operation in a connector swagger
conn = mcp("describe_live_connector", {"environmentName": ENV, "connectorName": "shared_sharepointonline"})
op = conn["properties"]["swagger"]["paths"]["/datasets/{dataset}/tables/{table}/items"]["get"]
print(op["operationId"], "—", op.get("summary"))

# Bad — keeping the whole 500 KB swagger in context
print(json.dumps(conn, indent=2))   # don't do this

---

Auth & Connection Notes

FieldValue
Auth headerx-api-key: <JWT>not Authorization: Bearer
Token formatPlain JWT — do not strip, alter, or prefix it
TimeoutUse ≥ 120 s for get_live_flow_run_action_outputs (large outputs)
Environment nameDefault-<tenant-guid> (find it via list_live_environments or list_live_flows response)

---

Reference Files

  • MCP-BOOTSTRAP.md — endpoint, auth, request/response format (read this first)
  • tool-reference.md — response shapes and behavioral notes (parameters are in tool_search)
  • action-types.md — Power Automate action type patterns
  • connection-references.md — connector reference guide

Related skills

How it compares

flowstudio-power-automate-mcp implements its own SKILL.md workflow rather than a generic substitute skill.

FAQ

Who is flowstudio-power-automate-mcp for?

Agents and developers following the flowstudio-power-automate-mcp SKILL.md guidance.

When should I use flowstudio-power-automate-mcp?

When user intent matches description triggers and quick start scenarios.

Is flowstudio-power-automate-mcp safe to install?

Review the Security Audits panel before production shell or network use.

Automation & Workflowsintegrationsbackend

This week in AI coding

Five minutes, every Monday - the tools, releases and tactics for developers.

unsubscribe anytime.