If your inbox looks like a filing cabinet that exploded and half your job is copying things from one tab to another, Microsoft Power Automate is built for you. It sits quietly inside your Microsoft 365 subscription and handles the repetitive bits so you don’t have to — and once you know how to use it, it gives you hours back every week.
What is Microsoft Power Automate?
Microsoft Power Automate (previously called Microsoft Flow) is a cloud-based automation tool that lets you build workflows between the apps and services you already use — with no coding required. If you have a Microsoft 365 subscription at work, you almost certainly have access to it already.
It sits inside the Microsoft Power Platform alongside Power Apps, Power BI and Copilot Studio, and its job is simple: handle the predictable, repetitive tasks that eat into your week.
In practical terms, Power Automate can:
Trigger actions when something happens — an email arrives, a file is uploaded, a form is submitted
Move data between apps you already use — Outlook, SharePoint, Teams, Excel, OneDrive
Run on a schedule — every morning, every Monday, at the end of each month
Automate desktop-only tasks on your machine using Power Automate Desktop
Use AI to pull information out of documents, categorise emails, or generate responses
Think of it as the world’s most patient assistant: not particularly creative, but reliably good at doing the same thing, the same way, every time. The full product overview is on Microsoft’s Power Automate documentation.
The three types of Power Automate flows
Before you start building, it helps to know what kind of automation Power Automate can actually do. There are three main types.
1. Cloud flows
These run in the cloud and connect your online apps. There are three sub-types:
Automated flows — triggered by an event (e.g. “when an email with ‘invoice’ arrives, save the attachment to SharePoint”)
Instant flows — triggered manually via a button (e.g. “send a Teams message to my manager when I click this”)
Scheduled flows — run on a timer (e.g. “every Friday at 4pm, send me a summary of pending approvals”)
2. Desktop flows (Power Automate Desktop)
These run on your actual computer and can automate tasks inside desktop applications — pulling data out of legacy software that has no API, or repeating clicks in a web portal that resists modern automation. This is often called RPA (Robotic Process Automation).
3. Business process flows
These guide users through a defined process — think of them as a structured checklist that lives inside apps like Dynamics 365. Less relevant for everyday office work; more for larger organisations with structured processes.
For most people getting started, cloud flows are where 90% of the value is. That’s where we’ll focus for the step-by-step walk-through.
How to use Microsoft Power Automate, step by step
Here’s the shortest route from “I’ve never used Power Automate” to “I have a working flow running in the background”.
Step 1 — Sign in
Go to make.powerautomate.com and sign in with your work or school account. A personal Microsoft account will get you in, but some features and connectors are limited outside of a Microsoft 365 business plan.
Step 2 — Start from a template (it’s faster)
Microsoft offers thousands of pre-built templates. Browse them by app (Outlook, Teams, SharePoint) or by task (approvals, notifications, data collection). Templates are the fastest way to see how a flow is put together — tweak one rather than building from zero.
Step 3 — Pick your trigger
Every flow starts with a trigger: the event that kicks things off. Common triggers include:
When a new email arrives in a specific folder
When a file is created in OneDrive or SharePoint
When a Microsoft Form is submitted
At a scheduled time
Choose the trigger that matches what you want to automate.
Step 4 — Add your actions
After the trigger, add the actions you want to happen — in the same app or across different ones. A typical flow might:
Receive a form submission (trigger)
Save the response to SharePoint (action 1)
Send a notification to a Teams channel (action 2)
Create a calendar event for the person who submitted it (action 3)
You drag, drop and fill in the fields. No code.
Step 5 — Test before you trust
Use the “Test” button to run your flow with a real or simulated event. Check it did what you expected — and check it didn’t do what you didn’t expect. Then turn it on and let it run.
Step 6 — Monitor and refine
Every flow has a run history. If something breaks (a connector expires, a field changes name), you’ll see it there. Fix, save, move on. Most flows need a tiny bit of tidying in the first fortnight — after that they tend to run quietly in the background.
Use Copilot to build flows in plain English
If the designer feels fiddly, try Copilot in Power Automate. You describe the flow you want (“when an email with an invoice attachment arrives in my shared mailbox, save the attachment to the Finance SharePoint library and post a message in the Finance channel”) and it builds a first draft for you. It won’t always get it right the first time, but it gets you past the blank-canvas problem.
Five use-cases worth setting up today
1. Auto-save email attachments to SharePoint or OneDrive
If your job involves chasing invoices, contracts or forms in your inbox, this is the quickest win. Set up a cloud flow that watches a mailbox or folder, and when an attachment comes in, it’s saved straight to the right SharePoint library with a tidy filename.
2. Approval workflows
Instead of emailing a manager and waiting for “yep go ahead” in a reply, use Power Automate’s built-in approvals. The request appears in Teams or email with Approve/Reject buttons, and the flow continues based on the response.
3. Scheduled summary reports
A Monday-morning flow that pulls yesterday’s numbers from Excel, formats them into an email, and sends them to your inbox before you’ve made the coffee. It replaces half an hour of manual prep most weeks.
4. Teams notifications from other apps
Whenever a new lead comes in via a form, or a support ticket gets flagged as urgent, post it into the right Teams channel automatically. Great for small teams who don’t want to keep five tabs open.
5. Document processing with AI Builder
Power Automate includes AI Builder, which can read information out of invoices, receipts and structured documents. Point it at an invoice PDF and it extracts supplier, date, amount and line items — ready to save, forward or reconcile. It’s genuinely useful for finance, operations and HR workflows.
How Power Automate compares to AI agents
Power Automate is Microsoft’s answer to tools like Zapier and Make, and — more recently — a sibling to AI agents like Claude. If you live inside Microsoft 365, Power Automate is the obvious starting point because it’s already included in most business plans.
Where it shines: Microsoft app integration, structured approvals, desktop RPA, and enterprise governance controls your IT team will actually allow.
Where it struggles: anything requiring fluid reasoning or creative output. It can move data; it can’t really think about it.
For tasks that need reasoning — summarising a batch of documents, drafting personalised emails, responding to varied content — AI agents are stronger. That’s where tools like Claude come in. We’ve written about Claude’s agent tools in What is Claude Cowork? We Put it to the Test and What is Claude Dispatch? We Put it to the Test if you want to compare approaches.
In practice, the winning setup for most people is a mix: Power Automate for predictable, rules-based plumbing; AI agents for the thinking work.
FAQs: How to use Microsoft Power Automate
Do I need a separate licence for Power Automate?
If you have a Microsoft 365 work subscription, you’ll usually have access to Power Automate’s standard features as part of it. Premium connectors (like SQL Server, custom APIs, and some AI Builder features) require a paid add-on. Check with your IT team before building anything business-critical.
Is Power Automate the same as Microsoft Flow?
Yes — Microsoft Flow was renamed to Power Automate back in 2019. If you come across older tutorials referring to Flow, the product is the same one, just with a lot of new features on top.
Can Power Automate work with non-Microsoft apps?
Yes. Power Automate has 1,000+ pre-built connectors for services like Gmail, Slack, Dropbox, Salesforce and many more. For in-house systems, you (or your IT team) can build custom connectors pointing at any REST API.
What’s the difference between Power Automate Cloud and Desktop?
Cloud flows run in the cloud and connect online services. Desktop flows run on your machine and automate actions inside desktop applications — useful for older software without an API. Most people start with cloud flows and only add desktop flows when they really need them.
Is Power Automate hard to learn?
No — if you’re comfortable with Outlook and Excel, you can build a basic flow in an afternoon. The harder part is spotting which workflows are worth automating in the first place. That’s where structured learning with someone who’s done it pays back quickly.
Ready to put Power Automate to work?
Microsoft Power Automate is one of those tools that pays back the time you invest in it many times over — but only once you’ve found the right workflows to hand over. The first few flows feel fiddly. The fiftieth feels like magic.
If you want help identifying which parts of your week are worth automating — and learning the broader AI and automation skills that are reshaping how work gets done — ivee is built for people like you. We run practical, hands-on programmes designed for returners, career-changers, and anyone who wants these skills in their day-to-day work without spending months self-teaching.
