ninihen1 avatar

Power Automate MCP Server by Flow Studio

ninihen1/power-automate-mcp-skills

Gives AI agents action-level visibility into Power Automate cloud flows that the Graph API doesn't expose. You get inputs and outputs for every action, loop iteration data, nested failure details, and the ability to read, write, and deploy flow definitions. Includes diagnostic skills for step-by-step debugging, plus cached monitoring data for flow health, failure rates, and governance metadata like maker inventory and connector audits. The core difference is that Graph API tells your agent a run failed, but this shows why it failed and what data caused it. Connects via streamable HTTP to FlowStudio's hosted MCP endpoint with API key auth.

tools
32
auth
Secret needed
transport
HTTP
last updated
Apr 3, 2026

Install

From registry metadata
$ npx add-mcp https://mcp.flowstudio.app/mcp --name flowstudio-mcp --header 'x-api-key: ${X_API_KEY}'

Run in your terminal. add-mcp asks which agents to add it to, then asks for each value it needs. Add -g to install it for every project.

Review the command, arguments and environment values before installing. MCP servers run with your local permissions.

Other ways

Claude Code

$ claude mcp add --transport http flowstudio-mcp https://mcp.flowstudio.app/mcp --header 'x-api-key: YOUR_X_API_KEY'

Run in your terminal. Add --scope user to make it available in every project.

Tools

Verified live · 32 tools

Verified live against the running server on Nov 6, 2026.

tool_searchFind a tool listed here instead of guessing its name, and get its definition. Query forms: (1) "skill:<name>" — a whole bundle; call list_skills for the names; (2) "select:name1,name2" — exact tools; (3) free text like "cancel run" — ranked against name and description. Non-bi...2 params

Find a tool listed here instead of guessing its name, and get its definition. Query forms: (1) "skill:<name>" — a whole bundle; call list_skills for the names; (2) "select:name1,name2" — exact tools; (3) free text like "cancel run" — ranked against name and description. Non-bi...

Parameters* required
max_resultsinteger
Max tools to return for keyword queries (default 5). Ignored for select: and skill: queries.default: 5
query*string
Search query. Forms: "select:name1,name2", "skill:<name>", or free-text keywords.
list_skillsSkill bundles: groups of the tools listed here that are used together for one task (diagnose-connection-references, build-flow, debug-flow, monitor-flow, discover, governance). Returns each bundle's name and one-line description. Use it when unsure which tools fit a request; t...

Skill bundles: groups of the tools listed here that are used together for one task (diagnose-connection-references, build-flow, debug-flow, monitor-flow, discover, governance). Returns each bundle's name and one-line description. Use it when unsure which tools fit a request; t...

No parameters. Call it with no arguments.

report_bugReport a Flow Studio MCP bug or missing capability, append text evidence, or check your reports. Free and available even after quota is reached. Do not include passwords, access tokens, secrets, or full flow definitions unless necessary.18 params

Report a Flow Studio MCP bug or missing capability, append text evidence, or check your reports. Free and available even after quota is reached. Do not include passwords, access tokens, secrets, or full flow definitions unless necessary.

Parameters* required
action*string
one of report · append · status · list
categorystring
one of wrong-result · error · missing-capability · docs-or-hints · performance · otherdefault: other
chunkinteger
Optional. Omit to append the next chunk automatically.
contact_emailstring
contentstring
Text attachment body. Max 64 KB per call.
content_base64string
Binary attachment body, base64-encoded. Max 256 KB decoded per call. Use for images/PDF; pass text through `content` instead. Do not send both.
content_typestring
Media type of the attachment. text/plain (default), text/csv, text/markdown, application/json, application/har+json, application/xml, image/png, image/jpeg, image/gif, image/webp, application/pdf.
detailsstring
environment_namestring
file_namestring
final_chunkboolean
flow_namestring
include_diagnosticsboolean
default: true
notifyboolean
default: true
severitystring
one of blocker · major · minordefault: major
summarystring
ticketstring
tool_namestring
list_store_flows[Requires Pro+ plan] List Power Automate flows from the Power Clarity cache. Optionally filter by governance flags (monitor, notification rules). Returns key fields including trigger URL, state, and run failure rate. Data is from the stored snapshot — not live from the Power A...3 params

[Requires Pro+ plan] List Power Automate flows from the Power Clarity cache. Optionally filter by governance flags (monitor, notification rules). Returns key fields including trigger URL, state, and run failure rate. Data is from the stored snapshot — not live from the Power A...

Parameters* required
monitorboolean
If set, only return flows where monitor equals this value.
rule_notify_onfailboolean
If set, filter flows by whether on-fail notifications are enabled.
rule_notify_onmissingdaysboolean
If set, filter flows by whether missing-days notifications are enabled.
get_store_flow[Requires Pro+ plan] Get full details for a single Power Automate flow from the Power Clarity cache. Includes trigger URL, owners, state, run statistics, and governance metadata. Data is from the stored snapshot — not live from the Power Automate API.2 params

[Requires Pro+ plan] Get full details for a single Power Automate flow from the Power Clarity cache. Includes trigger URL, owners, state, run statistics, and governance metadata. Data is from the stored snapshot — not live from the Power Automate API.

Parameters* required
environmentName*string
Name of the Power Platform environment.
flowName*string
Name (ID) of the flow.
get_store_flow_runs[Requires Pro+ plan] Get cached run history for a flow from the Power Clarity store. Defaults to the last 7 days. Returns startTime, endTime, status, duration (seconds), failedActions, and remediation hint per run. Data is from the stored snapshot — not live from the Power Aut...6 params

[Requires Pro+ plan] Get cached run history for a flow from the Power Clarity store. Defaults to the last 7 days. Returns startTime, endTime, status, duration (seconds), failedActions, and remediation hint per run. Data is from the stored snapshot — not live from the Power Aut...

Parameters* required
endTimestring
ISO 8601 end of the time window.
environmentName*string
Name of the Power Platform environment.
flowName*string
Name (ID) of the flow.
startTimestring
ISO 8601 start of the time window (default: 7 days ago).
statusarray
Filter by status. Only the first value is used in the OData filter.
topnumber
Maximum number of run rows to return (default 5000).
get_store_flow_summary[Requires Pro+ plan] Get aggregated run statistics for a flow from the Power Clarity cache: total runs, success count, failure count, success rate, fail rate, and average/max duration over a time window. Data is from the stored snapshot — not live from the Power Automate API.4 params

[Requires Pro+ plan] Get aggregated run statistics for a flow from the Power Clarity cache: total runs, success count, failure count, success rate, fail rate, and average/max duration over a time window. Data is from the stored snapshot — not live from the Power Automate API.

Parameters* required
endTimestring
ISO 8601 end of the time window.
environmentName*string
Name of the Power Platform environment.
flowName*string
Name (ID) of the flow.
startTimestring
ISO 8601 start of the time window (default: 7 days ago).
update_store_flow[Requires Pro+ plan] Update governance/metadata fields on a flow record in the Power Clarity store (description, business impact, owner team, tags, monitor flag, notification settings, etc.). Only fields provided are updated (merge semantics). Writes to the cache — does not ca...18 params

[Requires Pro+ plan] Update governance/metadata fields on a flow record in the Power Clarity store (description, business impact, owner team, tags, monitor flag, notification settings, etc.). Only fields provided are updated (merge semantics). Writes to the cache — does not ca...

Parameters* required
businessImpactstring
businessJustificationstring
businessValuestring
criticalboolean
descriptionstring
environmentName*string
Name of the Power Platform environment.
flowName*string
Name (ID) of the flow.
monitorboolean
Enable/disable monitoring for this flow.
ownerBusinessUnitstring
ownerTeamstring
rule_notify_emailstring
Comma-separated email addresses for notifications.
rule_notify_onfailboolean
Send notification when the flow fails.
rule_notify_onmissingdaysnumber
Send notification when flow has not run for this many days (0 = disabled).
securitystring
supportEmailstring
supportGroupstring
tagsstring
tierstring
list_store_environments[Requires Pro+ plan] List all Power Platform environments from the Power Clarity cache.

[Requires Pro+ plan] List all Power Platform environments from the Power Clarity cache.

No parameters. Call it with no arguments.

list_store_makers[Requires Pro+ plan] List all makers (citizen developers / AAD users) from the Power Clarity cache.

[Requires Pro+ plan] List all makers (citizen developers / AAD users) from the Power Clarity cache.

No parameters. Call it with no arguments.

get_store_maker[Requires Pro+ plan] Get details for a single maker from the Power Clarity cache by their key (usually the AAD object ID). Includes flow/app counts and whether the account has been deleted.1 params

[Requires Pro+ plan] Get details for a single maker from the Power Clarity cache by their key (usually the AAD object ID). Includes flow/app counts and whether the account has been deleted.

Parameters* required
makerKey*string
Maker RowKey (AAD object ID of the user).
list_store_power_apps[Requires Pro+ plan] List all Power Apps canvas apps from the Power Clarity cache.

[Requires Pro+ plan] List all Power Apps canvas apps from the Power Clarity cache.

No parameters. Call it with no arguments.

list_store_connections[Requires Pro+ plan] List all Power Platform connections from the Power Clarity cache.

[Requires Pro+ plan] List all Power Platform connections from the Power Clarity cache.

No parameters. Call it with no arguments.

get_live_flow_runsFetch run history for a flow directly from Power Automate. Returns { runs, runCount, triggerChecks }: each run has name, status, startTime, endTime, trigger name/code, and any top-level error. IMPORTANT — no runs does NOT mean the flow is healthy. A trigger that fires and eval...8 params

Fetch run history for a flow directly from Power Automate. Returns { runs, runCount, triggerChecks }: each run has name, status, startTime, endTime, trigger name/code, and any top-level error. IMPORTANT — no runs does NOT mean the flow is healthy. A trigger that fires and eval...

Parameters* required
environmentName*string
Name of the Power Platform environment.
flowName*string
Name (ID) of the flow.
includeTriggerChecksboolean
Also report trigger check history when runs DO exist. Checks are always reported when there are no runs. Costs two extra API calls.
startedAfterstring
ISO date-time. Only runs and checks that started at or after it.
startedBeforestring
ISO date-time. Only runs and checks that started before it.
statusstring
Only runs with this status, e.g. Failed.one of Succeeded · Failed · Cancelled · Running
topnumber
Max runs to return. Paginates automatically. Default 30.
triggerCheckStatusstring
Only trigger checks with this status; reads the checks.one of Succeeded · Failed · Skipped
get_live_flow_run_errorFetch error details for a specific flow run from the live Power Automate API. Lists every failed action with its error code and message to help diagnose what went wrong.4 params

Fetch error details for a specific flow run from the live Power Automate API. Lists every failed action with its error code and message to help diagnose what went wrong.

Parameters* required
environmentName*string
Name of the Power Platform environment.
flowName*string
Name (ID) of the flow.
runName*string
Run identifier (name field from get_live_flow_runs), or "latest" for the most recent run.
topnumber
Max actions to return. Paginates automatically. Omit for all.
get_live_flow_run_action_outputsRead the recorded inputs and outputs of actions in one flow run. Without actionName: the top-level actions (optionally filtered by name). With actionName: every execution of that action across foreach iterations, each with repetitionIndexes, status, error, and resolved inputs/...8 params

Read the recorded inputs and outputs of actions in one flow run. Without actionName: the top-level actions (optionally filtered by name). With actionName: every execution of that action across foreach iterations, each with repetitionIndexes, status, error, and resolved inputs/...

Parameters* required
actionNamestring
Action name. Without iterationIndex: returns all repetitions of this action across every foreach iteration. With iterationIndex: returns the single repetition matching that iteration. Omit entirely...
checkIdstring
Trigger check id (checkId from get_live_flow_runs -> triggerChecks). Returns that check's inputs/outputs, including the failure reason. Not a run id — the two are different, which is why a check id...
environmentName*string
Name of the Power Platform environment.
flowName*string
Name (ID) of the flow.
iterationIndexnumber
Zero-based foreach iteration index. Matched against the innermost repetitionIndexes[].itemIndex in the PA repetition record. Only meaningful when actionName is also set.
runNamestring
Run identifier (name field from get_live_flow_runs), or "latest" for the most recent run. Required unless checkId is given.
topnumber
Max actions or repetitions to return. Paginates automatically. Omit for all.
triggerboolean
Return the RUN's trigger inputs/outputs instead of its actions. Requires runName.
trigger_live_flowRun a flow on demand — the same as the maker portal's "Run flow" button. Works with Request triggers (HTTP request, manual Button, PowerApps) and with scheduled RECURRENCE flows, which run immediately; a scheduled flow takes no inputs, so passing `body` to one is refused. Pass...4 params

Run a flow on demand — the same as the maker portal's "Run flow" button. Works with Request triggers (HTTP request, manual Button, PowerApps) and with scheduled RECURRENCE flows, which run immediately; a scheduled flow takes no inputs, so passing `body` to one is refused. Pass...

Parameters* required
bodyobject
JSON body to POST to the trigger URL. Omit for flows that expect an empty body.
connectionsobject
Only for a flow whose connections are provided by whoever runs it. Map of connection-reference name to the connection id to run it with, e.g. {"shared_office365users":"shared-office365user-…"}. Omi...
environmentName*string
Name of the Power Platform environment.
flowName*string
Name (ID) of the flow.
cancel_live_flow_runCancel a currently running Power Automate flow run via the live PA API. Use after get_live_flow_runs to obtain the run name. Only runs with status "Running" can be cancelled.3 params

Cancel a currently running Power Automate flow run via the live PA API. Use after get_live_flow_runs to obtain the run name. Only runs with status "Running" can be cancelled.

Parameters* required
environmentName*string
Name of the Power Platform environment.
flowName*string
Name (ID) of the flow.
runName*string
Run identifier (name field from get_live_flow_runs).
resubmit_live_flow_runResubmit a failed or cancelled Power Automate flow run via the live PA API, re-using the original trigger payload. Discovers the trigger name from the flow definition automatically — no trigger name parameter needed.3 params

Resubmit a failed or cancelled Power Automate flow run via the live PA API, re-using the original trigger payload. Discovers the trigger name from the flow definition automatically — no trigger name parameter needed.

Parameters* required
environmentName*string
Name of the Power Platform environment.
flowName*string
Name (ID) of the flow.
runName*string
Run identifier (name field from get_live_flow_runs), or "latest" for the most recent run.
set_live_flow_stateStart or stop the flow you name. Reads the current state first and only calls Power Automate if a change is actually needed.3 params

Start or stop the flow you name. Reads the current state first and only calls Power Automate if a change is actually needed.

Parameters* required
environmentName*string
Name of the Power Platform environment.
flowName*string
Name (ID) of the flow.
state*string
Desired state for the flow.one of Started · Stopped
get_live_flowFetch the full native Power Automate flow JSON from the PA API, including the complete flow definition (triggers, actions, parameters, outputs). Returns the raw properties object exactly as the PA API returns it. Use this to inspect the full definition before calling update_li...5 params

Fetch the full native Power Automate flow JSON from the PA API, including the complete flow definition (triggers, actions, parameters, outputs). Returns the raw properties object exactly as the PA API returns it. Use this to inspect the full definition before calling update_li...

Parameters* required
actionsarray
Return only these actions, found at any nesting depth and each reported with the scopes it sits in, plus triggers. Combine with depth:"summary" to get the tree as well.
depthstring
full (default): the whole definition. summary: the action tree — name, type, operation, runAfter, nesting — with no inputs. Use summary on a large flow, then ask for the actions you need.one of summary · full
environmentName*string
Name of the Power Platform environment.
flowName*string
Name (ID) of the flow.
includeTriggerUrlboolean
Also return the HTTP trigger URL. It is a credential: anyone holding it can run the flow.
update_live_flowUpdate or create a flow. Use `dryRun: true` to preview any change without writing. Omit flowName to create: definition and displayName are required. Give flowName to update: displayName and/or definition and/or connectionReferences. SURGICAL EDIT: pass `operations` — an ordere...8 params

Update or create a flow. Use `dryRun: true` to preview any change without writing. Omit flowName to create: definition and displayName are required. Give flowName to update: displayName and/or definition and/or connectionReferences. SURGICAL EDIT: pass `operations` — an ordere...

Parameters* required
connectionReferencesobject
Connection references map copied from get_live_flow. Direct-flow entries use { connectionName, id }. Solution-aware entries also include { connectionReferenceLogicalName, source } and must retain t...
definitionobject
Full flow definition as a JSON object (triggers + actions + parameters + outputs + description). MUST be a JSON object — strings are rejected. Do not JSON.stringify the definition; pass the parsed...
displayNamestring
Display name for the flow. Required when creating.
dryRunboolean
Preview only, on BOTH paths: with flowName, apply the change to the live definition and return the result + what changed; without flowName, return the flow that WOULD be created. Nothing is written...
environmentName*string
Name of the Power Platform environment.
expectedLastModifiedTimestring
With a whole definition: refuse if the flow changed since you read it. Pass get_live_flow's lastModifiedTime.
flowNamestring
Name (ID) of the flow to update. Omit or leave blank to create a new flow.
operationsarray
SURGICAL EDIT of an existing flow (requires flowName; do not combine with definition). An ordered list applied to the LIVE definition. Each item = { op, path, value? }. path is an ARRAY of literal...
list_live_environmentsList all Power Platform environments you belong to, directly from Power Automate. Returns id, displayName, sku, location, and state for each environment. mode=all (default) and mode=member: every environment you are a member of. mode=admin: only those you administer; errors ra...2 params

List all Power Platform environments you belong to, directly from Power Automate. Returns id, displayName, sku, location, and state for each environment. mode=all (default) and mode=member: every environment you are a member of. mode=admin: only those you administer; errors ra...

Parameters* required
modestring
all (default) and member: every environment you belong to. admin: only those where you hold ListAnyFlow; errors rather than returning a shorter list if admin access cannot be determined.one of all · member · admin
topnumber
Max environments to return. Paginates automatically. Omit for all.
list_live_flowsList Power Automate flows in an environment. Returns id, displayName, state, triggerType, and lastModifiedTime for each flow. mode=owner (default): flows you own plus flows shared with you (personal + team), with full definitions. mode=admin: all flows in the environment (requ...7 params

List Power Automate flows in an environment. Returns id, displayName, state, triggerType, and lastModifiedTime for each flow. mode=owner (default): flows you own plus flows shared with you (personal + team), with full definitions. mode=admin: all flows in the environment (requ...

Parameters* required
continuationUrlstring
nextLink value returned by a previous call. Pass to resume pagination from where the last call stopped. Must match the same mode as the original call.
environmentName*string
Name of the Power Platform environment.
includeDeletedboolean
Include soft-deleted flows, which come back with state=Deleted and can be restored with restore_live_flow. Requires mode=admin — the user-scoped listing never returns deleted flows. Off by default.
modestring
owner (default): user-scoped — owned + shared-with-me flows (personal + team), with full definitions. admin: admin-scoped endpoint, all flows.one of owner · admin
searchstring
Optional case-insensitive filter applied to flow displayName.
timeoutSecondsnumber
Stop collecting pages after this many seconds and return a nextLink for the next batch. Default 25. Max 55.
topnumber
Max flows to return. Paginates automatically. Omit for all.
list_live_connectionsList Power Platform connections in an environment directly from Power Automate. Returns id, displayName, connectorName, environment, createdBy (full object), authenticatedUser, statuses, overallStatus, createdTime, expirationTime, and connectionParameters for each connection....3 params

List Power Platform connections in an environment directly from Power Automate. Returns id, displayName, connectorName, environment, createdBy (full object), authenticatedUser, statuses, overallStatus, createdTime, expirationTime, and connectionParameters for each connection....

Parameters* required
environmentName*string
Required. Name of the Power Platform environment (a GUID, or a name like "Default-<tid>"). Call list_live_environments if you do not have one — the platform cannot list connections across environme...
searchstring
Optional case-insensitive substring filter applied to id, displayName, connectorName, and accountName. Adds connectionReferenceTemplate + hostTemplate to each returned connection.
topnumber
Max connections to RETURN, applied after search. Paginates automatically. Omit for all.
describe_live_connectorDescribe a live Power Platform connector/API and its operations. Use mode=summary (default) to get a compact operation catalog. Use operationId to describe one operation, including inputs, outputs, dynamic parameter metadata, nextTool hints to call resolve_live_parameters, and...9 params

Describe a live Power Platform connector/API and its operations. Use mode=summary (default) to get a compact operation catalog. Use operationId to describe one operation, including inputs, outputs, dynamic parameter metadata, nextTool hints to call resolve_live_parameters, and...

Parameters* required
apiNamestring
Alias for connectorName.
connectorNamestring
Connector logical name, for example shared_teams. Either connectorName/apiName is required, unless search is provided for cross-connector operation search.
depthstring
summary (default): compact operation catalog. full: raw OpenAPI metadata.one of summary · full
environmentName*string
Name of the Power Platform environment.
operationIdstring
Optional operation ID to describe with expanded inputs and outputs.
searchstring
Optional operation search text. With connectorName, filters that connector summary. Without connectorName, searches operations across connectors.
topnumber
Max operations to return in connector summary mode, or max top search results to show in cross-connector search. Default 250 for summary, 10 for search display.
typestring
Operation usage to include in summary mode. Default Action.one of Action · Trigger
variantstring
When an operation has multiple authored variants (e.g. shared_teams/PostMessageToConversation has channel/groupchat/flowbot_chat), pass a specific variantKey to get that variant's hint and exampleD...
add_to_solutionAdd a flow or a canvas app to a solution. Pass flowName or app. A flow not yet in a solution moves into `solution`, or into the default solution when it is omitted. A flow or app already in a solution is added to `solution` as well, and stays in the one it is in.4 params

Add a flow or a canvas app to a solution. Pass flowName or app. A flow not yet in a solution moves into `solution`, or into the default solution when it is omitted. A flow or app already in a solution is added to `solution` as well, and stays in the one it is in.

Parameters* required
appstring
The canvas app (ID). Not with flowName.
environmentName*string
Name of the Power Platform environment.
flowNamestring
The flow (ID). Not with app.
solutionstring
The solution: its unique name, or its solutionid GUID. Required for an app, and for a flow already in a solution.
resolve_live_parametersResolve a connector action's inputs the way the flow designer does: dropdown options, list and table columns, folder and file pickers — every input in one call, or one with parameterName. Reads only: it runs the lookups the designer runs, never an action. Pass values you have...16 params

Resolve a connector action's inputs the way the flow designer does: dropdown options, list and table columns, folder and file pickers — every input in one call, or one with parameterName. Reads only: it runs the lookups the designer runs, never an action. Pass values you have...

Parameters* required
actionNamestring
Action (or trigger) name in flowName.
apiNamestring
Alias for connectorName.
browseobject
Open a folder: { "field": "<input>", "id": "<folder value>" }.
connectionNamestring
Connection to run as. Omit to have one chosen.
connectorNamestring
Connector name, e.g. shared_sharepointonline.
detailstring
Column detail. Default compact.one of compact · full
environmentName*string
Name of the Power Platform environment.
flowNamestring
With actionName: take the connector, operation and connection from this flow action.
includearray
Add "outputs" to get the fields this action returns.
matchobject
Exact display name, or the value itself, per input, e.g. { "folderPath": "Inbox" }. Case-insensitive, never fuzzy. Folders also take /path. matchCount 0 answers status "nomatch".
operationIdstring
Operation ID, e.g. PostItem. Not needed with flowName + actionName.
parameterNamestring
Resolve only this input. Omit for every input.
parametersobject
Values already chosen, e.g. { "dataset": "<site url>" }.
searchstring
Narrow long option or column lists by name (a filter, not a pick).
skipnumber
Options to skip, to page through a truncated list (use nextSkip).
topnumber
Max options per dropdown (default 200). A longer list is marked truncated.
test_live_connectionTest a connection, or run one operation on it. Without operationId it runs the connector's own connection test. With operationId it runs that operation and returns the raw reply: a GET operation, or a lookup the connector itself declares for a dropdown, list, schema or folder...6 params

Test a connection, or run one operation on it. Without operationId it runs the connector's own connection test. With operationId it runs that operation and returns the raw reply: a GET operation, or a lookup the connector itself declares for a dropdown, list, schema or folder...

Parameters* required
connectionName*string
The connection, from list_live_connections.
connectorName*string
Connector name, e.g. shared_sharepointonline.
continuationUrlstring
The nextLink from the previous reply, to fetch the next page.
environmentName*string
Name of the Power Platform environment.
operationIdstring
Omit to run the connector's own connection test.
parametersobject
The operation's inputs by name (path, query, header or body).
create_live_connectionCreate a connection, or sign an existing one in again (pass connectionName). Shows a sign-in card where the person signs in; you never sign in for them. Without the card, give the person signInLink to open. Connectors that use a key or account details instead of a sign-in are...3 params

Create a connection, or sign an existing one in again (pass connectionName). Shows a sign-in card where the person signs in; you never sign in for them. Without the card, give the person signInLink to open. Connectors that use a key or account details instead of a sign-in are...

Parameters* required
connectionNamestring
An existing connection to sign in again, instead of creating one.
connectorName*string
Connector name, e.g. shared_sharepointonline.
environmentName*string
Name of the Power Platform environment.
read_live_tableRead rows from a Dataverse table, SharePoint list, SQL table or Excel table. Read-only. Returns rows, columns and nextLink.10 params

Read rows from a Dataverse table, SharePoint list, SQL table or Excel table. Read-only. Returns rows, columns and nextLink.

Parameters* required
connectionstring
The connection name, when you have more than one.
connectorstring
Omit for Dataverse.one of sharepoint · sql · excel
continuationUrlstring
The nextLink from the previous reply, for the next page.
datasetstring
Where the table lives. SharePoint: the site URL. SQL: server,database. Excel: drive,file.
environmentName*string
Name of the Power Platform environment.
filterstring
An OData filter.
selectstring
Comma-separated columns.
skipnumber
SQL and Excel: rows to skip, for the next page.
table*string
Dataverse: the set name, e.g. accounts. SharePoint: the list title or id. SQL or Excel: the table.
topnumber
Rows, 1 to 100. Default 20.
grant_flow_studio_accessShows a sign-in card; the person signs in, or signs in again when expired. Flow Studio keeps the sign-in for later calls.

Shows a sign-in card; the person signs in, or signs in again when expired. Flow Studio keeps the sign-in for later calls.

No parameters. Call it with no arguments.

Sponsors

Readme

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. FlowStudio 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 FlowStudio MCP, the agent sees what you see

When you need this


View the full README on GitHub

Details

Repository
github.com/ninihen1/power-automate-mcp-skills
Website
mcp.flowstudio.app
Category
Automation & Workflows
Transport
HTTP
Auth
Required
Registry
MCP registry, active
Resources
1
Tools verified
Nov 6, 2026

Related Automation & Workflows MCP servers

View all
1thecombatwombat avatarreplicant-mcpthecombatwombat/replicant-mcpAndroid MCP server for AI-assisted development. Build, test, emulate, and automate.13stars
26figr-com avatarJobGPT - Job Search Automation & Auto Apply6figr-com/jobgpt-mcp-serverJob search automation, auto apply, resume builder, application tracking, and recruiter outreach11stars
3mhajder avatarZabbix MCPmhajder/zabbix-mcpMCP server for Zabbix monitoring and automation10stars
4sh6drack avatarZen Mcpsh6drack/zen-mcpMCP server for Zen Browser automation via WebDriver BiDi10stars
5ssembleinc avatarSsemble AI Clippingssembleinc/ssemble-mcp-serverCreate AI-powered short-form video clips from YouTube videos. Supports webhook callbacks.7stars
6vcoder25 avatarVugolavcoder25/vugola-mcpClip videos into captioned shorts, add captions, and schedule posts from AI agents.7stars