12 Power Automate examples for small businesses on Microsoft 365

I'm Managing Partner of a two-office law firm with around 30 people, where I've built task hand-offs with one-click sign-off and a live reporting dashboard. So I judge every example here on one thing: would a busy team keep using it?

What is Power Automate?

Power Automate is Microsoft's automation tool. You build a flow: when something happens, such as a form being submitted or an email arriving, it carries out the steps you set, like saving details, sending a message or asking for approval. It works across Microsoft 365 and many other apps, with little or no code.

Microsoft splits it into three kinds of flow. Cloud flows run online and link your apps, and they're what this guide is about. Desktop flows repeat the clicks and typing a person does in desktop programs. Generative actions, still in preview, let AI pick the steps from a description.

You sign in with a work or school account, so a home Personal or Family plan won't do. Microsoft's introduction to Power Automate covers the basics.

Source: Microsoft Learn, overview of cloud flows.

How does a Power Automate flow work?

Every flow has one trigger and one or more actions. The trigger is the event that starts it, such as a new email. Actions are the steps that follow, such as saving an attachment or posting in Teams. Connectors link the flow to each app, so it can read from one and write to another.

You can start from a blank flow, from one of Microsoft's templates, or by describing what you want to Copilot in plain English. Copilot works in the new designer, is tuned for English, and can be switched off by your administrator. However you start, check every step yourself before the flow goes live.

In the examples below, When is the trigger and Then is each action. Names in quotes are what you'll see in the designer, so you can search for them. All 12 use standard connectors, which Microsoft 365 business plans include.

12 Power Automate examples for a small business

These are ordinary jobs, not showpieces, built from apps that come with Microsoft 365. Swap in your own list names and email addresses.

1. Enquiry form to a list, a reply and a Teams alert

Every enquiry lands in one place, and the customer hears back straight away.

If your website form sends you an email instead, start with Outlook “When a new email arrives (V3)” and filter on the subject line.

2. Supplier invoices from email to SharePoint

Invoice attachments are filed the moment they land.

Microsoft notes this trigger skips emails over 50 MB and may skip protected ones, so check the mailbox now and then.

3. Spending approvals in Teams

A short form, a yes or no from Teams or email, and a record of the decision.

Approvers can answer from an Outlook email, a Teams card or Power Automate itself. For a one-off request with no follow-up steps, the Approvals app in Teams works without building a flow at all.

4. Holiday requests that find the right manager

The flow looks up each person's manager in Microsoft 365, so there's no list of approvers to maintain.

This only works if each person's manager is filled in on their Microsoft 365 profile. Check that before you build it.

5. Renewal reminders from a simple list

Insurance, vehicle MOTs, subscriptions and certificates go in one list, and the right person is reminded in good time.

Recurrence lets you set the frequency and the time zone.

6. New starter checklist

One new row sets up the jobs that tend to get forgotten before someone's first day.

7. Weekly summary email

Last week's enquiries in your inbox every Monday, without opening anything.

Microsoft's guide to data operations shows the table step.

8. Flagged emails become tasks

When an email is really a job, flagging it puts it on the team's task board.

For your own list rather than the team's, use Microsoft To Do “Add a to-do (V3)” instead.

9. Customer feedback with a low-score alert

Every answer is logged, and a poor score reaches you the same day.

10. New booking to a job list

If customers book through Microsoft Bookings, each booking sets up its own admin.

11. Site checks or timesheets straight into Excel

A form on the phone instead of a pile of paper.

The action writes to a table, so format the range in your spreadsheet as a table first.

12. Finished quotes saved as PDFs

Drop a finished Word quote in one folder, and a PDF appears in another.

Is Power Automate included in Microsoft 365?

Yes, on the business plans. Microsoft 365 Business Basic, Standard and Premium include Power Automate with standard connectors, which cover Outlook, SharePoint, Teams, Forms, Excel, OneDrive and Planner. Premium connectors, such as Salesforce or filling in Word templates, need a Power Automate Premium licence per person or a Process licence per flow.

A common mix-up: Business Premium is the name of a Microsoft 365 plan. It still only gives you standard connectors in Power Automate.

Tiers taken from Microsoft's lists of standard connectors and premium connectors on 30 September 2026. Microsoft can move a connector between tiers, so check before you build.

Two limits are worth knowing. Each person on a Microsoft 365 licence gets 6,000 actions a day. And a flow that hasn't been triggered for 90 days may be switched off, with a warning 30 days before, unless its owner has a premium licence. To see what you have, open Power Automate and go to Settings, then “View my licenses”.

How do you keep Power Automate flows reliable?

Treat each flow like a member of staff with a job description. Give it a second owner, point it at shared mailboxes and team sites rather than one person's inbox, test it with real examples, and add an alert that tells someone when a step fails. Then write down what it does and how to switch it off.

• Owners. Add a second owner, or a group. If the builder leaves, steps that use their connections can fail until someone updates them. Microsoft's licensing FAQ on leavers explains how a co-owner takes over.
• Error alerts. Use “Configure run after” so a failed step emails someone. A flow that fails continuously for 14 days is switched off.
• Testing. Run Flow Checker, then Test with a real form or email. Try the awkward cases too: a blank answer, two attachments, a rejection.
• No personal accounts. Build in your business Microsoft 365, never a personal Microsoft account. If you want a shared account to own flows, read Microsoft's guidance first: it prefers a service principal, and one premium licence can't be shared across many users.
• Filters in the trigger. Filter by sender, folder or subject in the trigger itself, so the flow only runs when it should.
• Personal data. Move only the details the job needs, and keep them inside your own Microsoft 365. UK GDPR still applies. This is general information, not legal advice, so check your set-up with your data protection adviser.

Common pitfalls

• Automating a muddle. If nobody agrees the steps, the flow does the wrong thing faster. Write them down first.
• Premium surprises. Adding a Word template or a CRM halfway through can change the licence you need. Check each connector's tier before you start.
• Ten flows at once. Build one, let it settle, then add the next. Otherwise nobody knows which one caused a problem.
• Nothing written down. A flow nobody can explain is a flow nobody dares switch off.

What to do next

1. Check your licence. In Power Automate, go to Settings, then “View my licenses”. Business Basic, Standard and Premium give you standard connectors.
2. Pick one job. Choose something that happens every week and follows the same steps each time.
3. Write it as When and Then. One trigger, each action in order, and who needs to check anything.
4. Build it on test data. Use a test list and your own email address, then run Test with real examples.
5. Add an owner and an alert. A second owner, a failure email and a note of how to switch it off.
6. Watch it for a fortnight. Check the run history, fix anything odd, then pick the next job.

How I can help

If you'd like help choosing and building your first flows, that's what my business automation service for Sussex businesses is for. I start with how the work gets done, build one flow at a time with your team, and write down what runs and how to stop it.

Not sure which job to start with? The AI audit maps your week and ranks the options. Weighing up other tools too? Read my plain-English comparison of Zapier, Make and Power Automate.

Questions people ask

Is Power Automate free?

It's included, rather than free, with Microsoft 365 Business Basic, Standard and Premium for flows that use standard connectors. Microsoft also offers a free Power Automate licence for work accounts, which covers cloud flows with standard connectors but not sharing them. Premium connectors cost extra.

Do I need coding skills for Power Automate?

No. You choose a trigger and actions from lists and fill in the boxes. Some steps need a simple formula, for example to work out a date, and Copilot can help you set steps up. If you can describe the job as When and Then, you can build most of the examples here.

Can Power Automate connect to Xero or my CRM?

Sometimes, but usually through premium connectors. On 30 September 2026, Microsoft's list showed Salesforce, Mailchimp and a third-party Xero connector as premium. If your main systems aren't Microsoft ones, compare the cost of Power Automate Premium with other tools before you decide.

What happens if the person who built a flow leaves?

Steps that use their connections can stop working. Add a co-owner now, so someone else can update the connections or take the flow over. If nobody acts, Microsoft says the flow can be slowed and then switched off after 14 days.

Can Copilot build a flow for me?

It can draft one. In the new designer you describe what you want in plain English, and Copilot suggests the trigger and actions. It's tuned for English, and your administrator can turn it off. Always check each step and test the flow before you rely on it.

What's the difference between Power Automate and Zapier?

Both link apps with triggers and actions. Power Automate is built into Microsoft 365, so it's the natural place to start if that's where your work lives. Zapier is a separate subscription that charges by the tasks it completes. My Zapier vs Make comparison covers both, plus Make.

Related guides