Power Automate Training: How a Business Owner Should Actually Learn It

When an owner asks me about Power Automate training, the question underneath is rarely about training. It is usually this: can I learn this myself in the evenings, or do I have to send someone on a £1,500 course before anything in this business gets automated?

I hear it most from people who already pay for Microsoft 365 and have noticed the Power Automate icon sitting unopened in the app launcher. My honest answer is that most of you can teach yourselves, for nothing, and should.

The catch is order. The free route works if you learn it the right way round, and the course sellers who fill this search have no reason to tell you what that is. So this is the path I would give a business owner who is not a developer and has no wish to become one, including the point where paying for a course, or switching tool, genuinely makes sense.

Can you learn Power Automate for free?

Yes. Microsoft publishes a complete beginner learning path on Microsoft Learn, and you can practise on the Microsoft 365 licence you probably already have, so the real cost is your time.

The path is called Automate a business process using Power Automate. It is rated beginner, runs to seven modules, and assumes only that you have used SharePoint and Excel before. Get started with Power Automate is the module to do tonight. Build approval flows comes next, and approvals are what most small businesses end up using.

Not every module earns your evening. The admin centre module is for whoever runs your Microsoft tenant, and process advisor is aimed at larger organisations mapping work across departments. Skip both on the first pass.

Prefer a person talking you through it? Microsoft also runs free instructor led workshops called Automation in a Day, listed on the Power Automate training hub. For plenty of people that does the job a paid introduction day would.

What do you need before you start?

Two things: a Microsoft 365 business licence, and one real process you are sick of doing by hand. Then, before lesson one, find out which connectors that licence actually covers.

That last point matters more than any module. Microsoft 365 plans include Power Automate with standard connectors only, which covers Outlook, SharePoint, OneDrive, Teams, Excel Online, Forms and Planner. Anything marked premium, such as the HTTP connector or the Salesforce connector, needs a Power Automate Premium licence.

Tutorials rarely flag which is which. You follow along happily, reach step nine, and meet a licence prompt.

If you want to practise with premium connectors without paying, sign up for Microsoft’s free Developer Plan. It includes premium connectors and allows 750 flow runs a month, but it needs a work or school account, it is strictly for building and testing, and it is switched off after 30 days without use. Treat it as a sandbox. Never let a real business process live there.

How should a business owner learn Power Automate, step by step?

Build one real flow first and let the modules fill the gaps. Finishing a syllabus and then hunting for something to automate is the slow way round. Spread this over a few weeks of evenings.

1. Pick the process before the course. Write one sentence describing a job you repeat, such as “every supplier invoice that lands in the accounts inbox gets saved to the Finance folder in SharePoint”. If you cannot write the sentence, you are not ready to automate the job. If you are unsure which job to pick, the free AI Opportunity Scorecard takes two minutes and estimates where automation would give you the most hours back.
2. Do the Get started module. An hour or two. You only need the vocabulary: trigger, action, connector, run.
3. Build the attachment flow yourself. At make.powerautomate.com, create an automated cloud flow using the Outlook trigger “When a new email arrives”, set it to only fire on emails with attachments, and add the SharePoint action “Create file”. Every piece is a standard connector, so your Microsoft 365 licence covers it.
4. Ask Copilot to build the same flow, then compare. Describe the job in plain English and put its version next to yours. Reading a flow somebody else built is the skill you will use most.
5. Add an approval. Work through the approvals module, then extend your flow so any invoice over a set amount posts an approval request in Teams before it is filed.
6. Break it on purpose. Send an email with no attachment. Rename the SharePoint folder. Then open the run history and read exactly where it failed, which teaches you more than any module on expressions.

Where do beginners get stuck?

In the same few places, and almost none of them appear on course sales pages.

Apply to each. The moment your flow handles email attachments, Power Automate wraps your next action in an Apply to each loop without asking. Beginners delete it, the flow breaks, and they assume they did something wrong. They did not. One email can carry several attachments, so the flow has to loop through them. Once that clicks, a surprising amount of odd designer behaviour starts to make sense.

Expressions. Dynamic content, the fields you click to insert, gets you a long way. Expressions are the small formulas for jobs like turning a date into a file name, and they are where most self taught learners stall. The classic mistake is wrapping an expression in quotation marks, which quietly turns it into plain text.

Flows owned by one person. Every flow and every connection belongs to a named user. Microsoft’s licensing FAQ says that when an owner leaves, ownership has to be moved to someone else, and a flow whose owner loses their Premium licence is slowed down and then switched off after 14 days. Add a second owner to anything the business relies on.

The per user licence trap. For automated and scheduled flows that use premium connectors, only the flow owner needs Premium. For instant flows, the kind someone starts with a button, every person who runs the flow needs Premium. That one detail can multiply a budget by the headcount of your team.

No error handling. A flow that fails at two in the morning tells nobody unless you told it to. The usual fix is to put your actions inside a Scope, then add a step configured to run after that Scope fails, which sends you a Teams message. It is a few minutes of work, and most beginner tutorials skip it entirely.

Is a paid Power Automate course worth it?

Sometimes, but rarely for the introduction. UK prices range from a few hundred pounds for a day to nearly £2,000 plus VAT for two, and the beginner syllabuses cover much the same ground as Microsoft’s free path.

A course does earn its fee in two situations. One is training several staff at once, because a trainer fielding five people’s questions in one room beats five people separately stuck on the same expression. The other is the advanced material. Arrays and error handling are genuinely easier to learn with someone who can look at your screen.

What I would skip is the paid introduction. Do the free path, build the attachment flow, and book an advanced day only once you have hit a wall you can name. You will arrive with real questions, and you will get far more from the day.

Do you need a Power Automate certification?

For running your own business, no. Your working flows are the proof that matters.

If you want a credential anyway, know that the landscape moved this year. The Power Platform Fundamentals exam is still live, takes 45 minutes, and was updated in July 2026 to include Copilot Studio agents among its assessed areas. The Power Automate RPA developer exam was retired at the end of June 2026, so ignore any course still selling preparation for it.

The better fit for an owner is Microsoft’s Applied Skills credential, Create and manage automated processes by using Power Automate. Instead of multiple choice questions, it drops you into an interactive lab where you build a working flow with conditional logic and an approval, then share it. It tests the work itself rather than your memory of the menus.

Can Copilot build flows so you can skip the training?

Partly. Copilot in Power Automate drafts a cloud flow from a plain English description over a short conversation, and Microsoft switches it on by default for UK tenants. What it cannot do is tell you whether the flow it built is the right one.

That is why step four above exists. Copilot saves real time on the skeleton of a flow, yet someone still has to check the details, say a file saving to the wrong folder or a loop you never asked for, before it runs against live invoices. The skill worth training in 2026 is reading a flow that a machine drafted and spotting what it got wrong.

Most of the Copilot features for desktop flows are still in preview. If your job means clicking through an old Windows application, expect to build more of it by hand.

When should you learn something other than Power Automate?

When the job leaves the Microsoft world, or the logic outgrows boxes on a canvas. Power Automate is at its best moving files and messages between Outlook, SharePoint and Teams. It gets painful quickly when you need to talk to a system with no connector, or apply rules with a dozen exceptions.

You can tell you have crossed the line when a flow has grown to dozens of actions and nested conditions, and nobody but its author dares open it. At that point you are no longer learning automation. You are learning to wrestle a designer.

This is where I point people at Claude Code instead. You describe the job in plain English, it writes and runs the code, and you end up owning a file you can read and change yourself, with no connector tier to budget for. The underlying skill is identical: describing a process precisely enough that software can do it. Many of the owners I work with end up using both, Power Automate for the Microsoft plumbing and Claude Code for the awkward jobs in between. I have written more about why I teach it that way on my about page.

So where should you start?

If you have Microsoft 365, I would start tonight with the free Get started module and the attachment flow, and I would not spend a penny on a course until you have built something and hit a wall you can describe. Then add a second owner to that flow before you forget. That one habit will save you more grief than any certificate.

If you would rather skip the trial and error of choosing what to automate first, that is what my AI Opportunity Audit is for. It is a £500 fixed fee, 60 minute session where I go through your business processes, find the highest impact places to apply automation, build one live in Claude Code so you can watch it run, and hand you a prioritised roadmap. There is a free 15 minute intro call first, so you can check I am the right person before spending anything. Either way, my aim is the same: you finish owning the skill.