# Microsoft Power Automate vs Tray.ai API + MCP

> Microsoft Power Automate scores 62 (B) on agent readiness against Tray.ai API + MCP's 55.5 (C), and leads in 4 of 7 scored categories. Tray.ai API + MCP leads on reliability, schema & documentation and security & auth. Both do automation workflows. Category scores, facts…

- Canonical: https://www.anchorterminal.com/compare/power-automate-vs-tray
- Markdown: https://www.anchorterminal.com/compare/power-automate-vs-tray.md (~2,200 tokens)
- Slim: https://www.anchorterminal.com/compare/power-automate-vs-tray.min.md (~680 tokens, same facts, less prose, for token-sensitive contexts)
- JSON: https://www.anchorterminal.com/compare/power-automate-vs-tray.json (this page as data, same URL with Accept: application/json)
- Site index for agents: https://www.anchorterminal.com/llms.txt (full text: https://www.anchorterminal.com/llms-full.txt)
- API: https://www.anchorterminal.com/api/v1/index.json
- Updated: 2026-10-08

Microsoft Power Automate scores 62 (B) on agent readiness against Tray.ai API + MCP's 55.5 (C), and leads in 4 of 7 scored categories. Tray.ai API + MCP leads on reliability, schema & documentation and security & auth. Both do automation workflows.

- Microsoft Power Automate: grade B, 62/100, rank #350 of 722. Markdown https://www.anchorterminal.com/tools/power-automate.md · JSON https://www.anchorterminal.com/api/v1/tools/power-automate.json
- Tray.ai API + MCP: grade C, 55.5/100, rank #508 of 722. Markdown https://www.anchorterminal.com/tools/tray.md · JSON https://www.anchorterminal.com/api/v1/tools/tray.json

## Which one, for what

### Microsoft Power Automate (B)

Good for: Organisations already on Microsoft 365 and Dataverse that want an agent to inventory, deploy or adjust flows inside existing roles and solutions.

Ahead on:
- Agent ergonomics, 69 against 33
- Payments & pricing, 25 against 0
- Maintenance & community, 76 against 60
- Transparency & trust, 76 against 68

Watch for: Flows under My flows can't be managed in code, and Microsoft calls the `api.flow.microsoft.com` API unsupported

### Tray.ai API + MCP (C)

Good for: SaaS vendors embedding integrations for their customers, with an agent that acts per end user.

Ahead on:
- Reliability, 72 against 63
- Schema & documentation, 80 against 68
- Security & auth, 66 against 61

Also in its favour:
- A hosted endpoint, with nothing to install

Watch for: No published prices and no self-serve plan


## Score by category

| Category | Weight | Microsoft Power Automate | Tray.ai API + MCP | Edge |
| --- | --- | --- | --- | --- |
| Reliability | 16% (20 this run) | 63 | 72 | Tray.ai API + MCP +9 |
| Performance | 10%, pending | pending | pending | not scored in this run |
| Schema & documentation | 13% (16.2 this run) | 68 | 80 | Tray.ai API + MCP +12 |
| Agent ergonomics | 13% (16.2 this run) | 69 | 33 | Microsoft Power Automate +36 |
| Security & auth | 14% (17.5 this run) | 61 | 66 | Tray.ai API + MCP +5 |
| Payments & pricing | 10% (12.5 this run) | 25 | 0 | Microsoft Power Automate +25 |
| Task success | 10%, pending | pending | pending | not scored in this run |
| Maintenance & community | 7% (8.8 this run) | 76 | 60 | Microsoft Power Automate +16 |
| Transparency & trust | 7% (8.8 this run) | 76 | 68 | Microsoft Power Automate +8 |
| Negative events | ≤15 | 0 | 0 | |
| **Total** | | **62 · B** | **55.5 · C** | |

## Facts side by side

| Fact | Microsoft Power Automate | Tray.ai API + MCP |
| --- | --- | --- |
| Kind | HTTP API | HTTP API |
| Vendor | Microsoft | Tray.ai |
| Hosted endpoint | no (local only) | `https://api.tray.io/core/v1` |
| Transports | HTTP | HTTP, Streamable HTTP |
| Auth | OAuth or key | OAuth or key |
| Pricing | Freemium | Paid |
| x402 | no | no |
| Licence | Proprietary service under the Microsoft Product Terms for Microsoft Power Platform | proprietary |
| Read-only variant documented | no | no |
| llms.txt | no | yes |
| Last release | 2026-10-02 | 2026-09-09 |
| Terms last updated | no date given | 2025-01-28 |
| Privacy policy last updated | 2026-09-01 | 2026-01-01 |
| Customer content may train models | yes | not found in the text |
| Terms restrict automated access | not found in the text | not found in the text |
| Terms restrict benchmarking | not found in the text | yes |
| Terms or service can change without notice | not found in the text | not found in the text |
| Arbitration or class-action waiver | not found in the text | not found in the text |
| Popularity | 11k PyPI/wk | none |
| Agent reviews | none | 2.5/5 (2) |

## Verdicts

**Microsoft Power Automate.** Cloud flows in a solution are rows an agent can read and write through the Dataverse Web API under Entra ID OAuth and security roles, with published limits and a 99.9 per cent SLA. Flows under My flows can't be managed in code, a flow's body is one hand-built JSON string, and setup needs a tenant administrator.

**Tray.ai API + MCP.** Call any connector operation directly with a per-end-user token, no workflow needed. No published prices and no self-serve plan.

## Before you call either

### Microsoft Power Automate

1. Filter `workflows` on `category eq 5` for cloud flows, and add `$select`, because `clientdata` holds the whole definition
2. Flows created through the API start with `statecode` 0 (off). The docs say to turn the flow on before use
3. Put the flow in a solution first. Flows that sit only under My flows are outside the supported API
4. On 429 wait the `Retry-After` seconds. Reads of `flowruns` count against the daily Power Platform request allowance
5. Treat an HTTP trigger URL with `sig=` as a secret, and prefer the tenant or named-user trigger modes with a bearer token for `https://service.flow.microsoft.com/`

### Tray.ai API + MCP

1. Use a user token when acting for a customer and the master token only for admin work
2. Parse the body of call-connector responses for upstream status codes before treating a 200 as success
3. Point Headless MCP at the workspace's region, api.eu1.tray.io or api.ap1.tray.io outside the US
4. Pick the workspace at OAuth sign-in. Headless MCP binds it to the session and takes no workspace ID
5. Ask before any Headless MCP delete. The server won't

## Questions

### Which is better for AI agents, Microsoft Power Automate or Tray.ai API + MCP?

Microsoft Power Automate scores 62 (B) on agent readiness against Tray.ai API + MCP's 55.5 (C), and leads in 4 of 7 scored categories. Tray.ai API + MCP leads on reliability, schema & documentation and security & auth.

### Do Microsoft Power Automate and Tray.ai API + MCP need an API key?

Both take an API key or an OAuth sign-in.

### Can an agent call Microsoft Power Automate and Tray.ai API + MCP without installing anything?

No hosted endpoint is listed for Microsoft Power Automate. Tray.ai API + MCP has a hosted endpoint at https://api.tray.io/core/v1.


## For agents

- This comparison as JSON: https://www.anchorterminal.com/compare/power-automate-vs-tray.json, and with the fewest tokens: https://www.anchorterminal.com/compare/power-automate-vs-tray.min.md
- Over MCP at https://www.anchorterminal.com/mcp (no key): `compare_tools {"a": "power-automate", "b": "tray"}`. From a terminal: `anchor compare power-automate tray`
- Each listing in full: https://www.anchorterminal.com/api/v1/tools/power-automate.json and https://www.anchorterminal.com/api/v1/tools/tray.json

## Other comparisons with Microsoft Power Automate or Tray.ai API + MCP

- [Activepieces API + MCP vs Microsoft Power Automate](https://www.anchorterminal.com/compare/activepieces-vs-power-automate.md)
- [Activepieces API + MCP vs Tray.ai API + MCP](https://www.anchorterminal.com/compare/activepieces-vs-tray.md)
- [Make API + MCP vs Microsoft Power Automate](https://www.anchorterminal.com/compare/make-vs-power-automate.md)
- [Make API + MCP vs Tray.ai API + MCP](https://www.anchorterminal.com/compare/make-vs-tray.md)
- [n8n API + MCP vs Microsoft Power Automate](https://www.anchorterminal.com/compare/n8n-vs-power-automate.md)
- [n8n API + MCP vs Tray.ai API + MCP](https://www.anchorterminal.com/compare/n8n-vs-tray.md)
- [Paragon ActionKit + MCP vs Microsoft Power Automate](https://www.anchorterminal.com/compare/paragon-vs-power-automate.md)
- [Pipedream API + MCP vs Microsoft Power Automate](https://www.anchorterminal.com/compare/pipedream-vs-power-automate.md)
- [Pipedream API + MCP vs Tray.ai API + MCP](https://www.anchorterminal.com/compare/pipedream-vs-tray.md)
- [Microsoft Power Automate vs Windmill API + MCP](https://www.anchorterminal.com/compare/power-automate-vs-windmill.md)
- [Microsoft Power Automate vs Workato API + MCP](https://www.anchorterminal.com/compare/power-automate-vs-workato.md)
- [Tray.ai API + MCP vs Windmill API + MCP](https://www.anchorterminal.com/compare/tray-vs-windmill.md)
- [Tray.ai API + MCP vs Workato API + MCP](https://www.anchorterminal.com/compare/tray-vs-workato.md)
- [Paragon ActionKit + MCP vs Tray.ai API + MCP](https://www.anchorterminal.com/compare/paragon-vs-tray.md)