Power Automate

The version bundled free with Microsoft 365 only supports standard connectors — the moment a flow needs Salesforce or SQL Server, it stops working entirely. One team wanting 4 parallel unattended bots found themselves at $600/month before counting user licenses.

Automation · Workflow Automation, Task Automation · 4.2 ★

What is Power Automate?

Power Automate is Microsoft's workflow and robotic process automation platform, deeply embedded across the Microsoft 365 and Power Platform ecosystem, letting users build "flows" that handle tasks like data collection, sending notifications, and routing approval requests across more than 300 connected services including Teams, SharePoint, Salesforce, and Google Drive. Its 2026 evolution has followed the same agentic direction as much of the industry: Release Wave 1 (rolling out April through September 2026) introduced agent-based features for authoring, optimization, and self-healing that apply to both desktop flows and Copilot Studio-driven cloud flow actions, alongside advanced governance, multi-agent orchestration, and evaluation capabilities in Copilot Studio itself. One genuinely impressive real customer example captures what that combination can deliver: Unifi, North America's largest aviation ground handling services provider, used Copilot Studio and Power Platform together to automate legal contract review by combining AI agents with deterministic workflows — breaking the process into coordinated steps that extract, classify, and validate key terms rather than relying on a single all-purpose agent — reducing contract processing time from days down to minutes, at a level of performance comparable to expensive, industry-specific off-the-shelf legal tools.

The genuinely important, honest thing worth understanding clearly before assuming your existing Microsoft 365 subscription already covers what you need: the Power Automate version bundled into Microsoft 365 only supports standard connectors, and the moment a flow needs to reach Salesforce, SAP, ServiceNow, SQL Server, or any other premium connector, it simply stops working — you're pushed into paid territory. One detailed pricing analysis puts it bluntly: "this trips up more teams than any other part of Power Automate licensing." From there, the licensing genuinely gets layered: the Premium plan runs $15 per user per month for unlimited cloud flows and premium connector access, but it's licensed per user — meaning if a flow built by one licensed person needs to run on behalf of other people in the organization, processing their data, those other people typically need their own licenses too. Unattended automation switches to an entirely different, per-bot pricing model: the Process plan runs $150 per bot per month, and Hosted Process (cloud-hosted, Azure-managed) runs $215 per bot per month — priced per CONCURRENT bot, not per user. One real, concrete example from an independent pricing analysis captures how quickly this compounds: an operations team wanting four parallel unattended processes found themselves looking at $600 a month before anyone had even counted the per-user Premium licenses required underneath those bots. It's also worth flagging a real operational risk: additional Dataverse storage costs roughly $40 per GB per month, and exceeding your allocation can cause flows to fail outright rather than simply prompting a billing notice.

🔒
M365-included version: standard connectors only
Salesforce, SAP, or SQL Server access requires an immediate upgrade to paid
💰
$600/month for 4 bots, before user licenses
A real example of how per-bot and per-user costs stack on top of each other
📄
Unifi: contract review, days to minutes
Coordinated AI agents plus deterministic workflows, not a single do-everything agent
⚠️
Exceeding Dataverse storage can fail flows
A real operational risk, not just an extra line on the invoice

The premium-connector "gotcha" and the concrete $600/month bot example are drawn directly from two independent, detailed 2026 pricing analyses (Zapier's own comparative guide and Automation Atlas, the latter quoting operations consultant Rafal Fila). The Unifi case study and 2026 agentic feature rollout are drawn from Microsoft's own official Copilot Studio blog and Cloud Wars' independent coverage of the Release Wave 1 announcement.

Key features

🔌

300+ connectors

Deep integration across Microsoft 365, Salesforce, SAP, and more.

🤖

Agent-based authoring & self-healing

2026 Release Wave 1 features applying to both desktop and cloud flows.

👥

Attended & unattended RPA

Human-present desktop flows alongside fully autonomous background bots.

🎛️

Copilot Studio integration

Multi-agent orchestration, governance, and evaluation for custom agents.

🔍

Process Mining

Analyze existing processes before automating them, included on Premium.

🛡️

Advanced Connector Policies (GA June 2026)

Governs which actions and MCP servers AI tools can actually use, not just connectors.

Available models

Copilot Studio agents Multi-agent orchestration combined with deterministic workflows, billed via Copilot Credits

Integrations & platforms

Microsoft 365, Dynamics 365 Salesforce, SAP, ServiceNow (premium) Azure-hosted bots

Pros, cons & best for

👍

Pros

  • Genuinely deep, native integration across the Microsoft 365 and Dynamics 365 ecosystem
  • Real, current agentic capabilities backed by concrete customer results like Unifi's
  • Combines attended, unattended, and cloud automation in one platform
👎

Cons

  • The free, M365-included version drops premium connector access entirely, a real surprise for many teams
  • Per-user and per-bot licensing stack on top of each other, compounding cost quickly
  • Exceeding Dataverse storage can fail flows outright, not just trigger a billing alert
🎯

Best for

  • Organizations already deeply invested in Microsoft 365 and Dynamics 365
  • Teams needing both cloud workflow automation and desktop RPA in one platform
  • Not the pick if you need external premium connectors on a purely M365-included budget

Take a look inside

Our verdict

4.2 / 5

Power Automate's genuine strength is native depth across the Microsoft ecosystem — organizations already living in Microsoft 365 and Dynamics 365 get real, meaningful value from that integration, and the 2026 agentic push (backed by concrete results like Unifi's days-to-minutes contract review) reflects real, current product investment rather than a superficial rebrand. The honest, important thing worth planning around carefully: the free, M365-included tier is far more limited than many teams initially assume, dropping premium connector access entirely and pushing anyone needing Salesforce, SAP, or similar integrations straight into paid licensing, and the layered per-user-plus-per-bot cost structure can compound quickly — a real, concrete example of $600 a month for just four parallel bots, before user licenses, is worth taking seriously when budgeting. For organizations deeply invested in the Microsoft stack needing both workflow automation and desktop RPA together, Power Automate remains a genuinely strong, well-integrated choice; for automation needs centered on non-Microsoft enterprise systems, UiPath or Automation Anywhere deserve a direct look first.

FAQ

Does my Microsoft 365 subscription already include full Power Automate access?

Only partially — the bundled version supports standard connectors only, so the moment a flow needs to reach Salesforce, SAP, ServiceNow, SQL Server, or any other premium connector, it stops working and requires a paid Premium license.

How much can unattended automation actually cost on Power Automate?

It compounds quickly — one real example found an operations team wanting four parallel unattended bots (Process plan, $150/bot/month) facing $600 a month before even counting the separate per-user Premium licenses required underneath.

Is Power Automate's Premium license per user or per flow?

Per user — if a flow built by one licensed person needs to run on behalf of other people in the organization, processing their data, those other people typically need their own Premium license too.

What happens if I exceed my Dataverse storage allocation?

Flows can fail outright rather than simply triggering a billing notice — additional storage costs roughly $40 per GB per month, and it's worth monitoring usage proactively rather than discovering the limit through a failed automation.

What did Unifi achieve using Power Automate and Copilot Studio?

By combining AI agents with deterministic workflows — breaking contract review into coordinated steps that extract, classify, and validate key terms — Unifi reduced contract processing time from days to minutes, matching the performance of expensive, industry-specific off-the-shelf legal tools.

What's the difference between the Process and Hosted Process plans?

Process ($150/bot/month) runs unattended automation on infrastructure you manage, while Hosted Process ($215/bot/month) runs on a virtual machine managed by Microsoft and hosted on Azure — both are priced per concurrent bot rather than per user.