Microsoft Power Automate for NZ Small Business: Automate Your First Workflow

There's a good chance you're already paying for Power Automate and don't know it. If your business uses Microsoft 365 — and most NZ businesses running on Windows, Outlook, or Teams do — Power Automate is included in your subscription. It's been sitting there, ready to use, while you've been doing things manually.

This article is a practical introduction to Power Automate specifically for NZ small businesses: what it actually does, where it's useful, where it isn't, and how to build your first working automation today.

What Is Power Automate?

Power Automate (formerly called Microsoft Flow) is Microsoft's automation tool. It lets you connect your Microsoft 365 apps — and many external ones — so they work together automatically.

The core concept is simple: you create a "flow" with a trigger and one or more actions. When this happens (trigger), do that (action). The whole thing runs automatically in the background.

For example:

• When a new email arrives with "Invoice" in the subject → save the attachment to a OneDrive folder automatically.
• When someone fills in a Microsoft Form → add their details to an Excel spreadsheet and send them a confirmation email.
• When a SharePoint document is updated → notify the relevant team member in Teams.

None of these require coding. The interface is visual and uses plain language. If you can use Outlook, you can learn Power Automate.

What's Included in Your Microsoft 365 Plan

Before we go further, it's worth checking what you have. Most Microsoft 365 Business plans include Power Automate with standard connectors. Standard connectors cover most Microsoft apps (Outlook, Teams, SharePoint, Excel, OneDrive, Forms, Planner) plus a range of third-party apps.

To access it: go to make.powerautomate.com and sign in with your Microsoft 365 account. If your account has access, you'll land in the flow builder. If you see a prompt to purchase a plan, your current subscription may not include it — check your Microsoft 365 admin centre.

Premium connectors — for apps like Salesforce, ServiceNow, or custom databases — require a paid Power Automate per-user plan, around NZ$20-25/month. For most small businesses, the standard connectors cover the vast majority of what you need.

Why Power Automate Is Particularly Good for Small NZ Businesses

Most small NZ businesses already have Microsoft 365 — it's the default choice for Outlook, Word, Excel, and Teams. Power Automate's strength is deep, native integration with all of these tools. You're not trying to connect apps via workarounds — you're automating within a system that already knows all your data.

Compared to general-purpose automation tools like Zapier or Make, Power Automate has better integration with:

• Outlook email and calendar
• Teams notifications and channel messages
• SharePoint document libraries
• Excel spreadsheets stored in OneDrive or SharePoint
• Microsoft Forms (great for internal processes and client intake)
• Planner (for task management)

If your business already lives in the Microsoft world, Power Automate is often the most natural tool to reach for.

Three Automations You Can Build This Week

Let's get practical. Here are three automations that are commonly useful for NZ small businesses and can be built in under an hour each.

1. Save Email Attachments to OneDrive Automatically

If you regularly receive invoices, signed contracts, or other documents via email and then save them manually to the right folder, this automation will save you genuine daily friction.

How to build it: In Power Automate, create a new automated flow. Set the trigger to "When a new email arrives" in Outlook, with a filter on subject or sender if needed. Add an action: "Create file" in OneDrive or SharePoint, using the email attachment as the file content. Specify the folder path.

Now every time a relevant email arrives, the attachment is automatically saved in the right place. No manual downloading, no forgotten files.

2. Instant Teams Notification When a Form Is Submitted

Do you use Microsoft Forms for anything — client enquiries, internal requests, job applications, feedback? Power Automate can send a Teams message (or an email) the instant someone submits a form.

How to build it: Create an automated flow with the trigger "When a new response is submitted" in Forms. Select your form. Add an action: "Post a message in a chat or channel" in Teams. Include the form responses in the message so you see the details immediately.

This is especially useful for businesses where quick response time matters — service businesses, tradespeople, consultants. Instead of checking a form manually or getting the notification buried in email, it pops up in Teams where you and your team are already working.

3. Weekly Summary Email from a SharePoint List or Excel File

If you maintain a spreadsheet or SharePoint list of open jobs, leads, tasks, or anything else, Power Automate can generate and email a summary of it on a schedule.

How to build it: Create a scheduled flow that runs every Friday at 4 PM. Use the "List rows present in a table" action to pull data from your Excel file or SharePoint list. Use a condition to filter for rows that match your criteria (e.g., status = "Open"). Format the results into an email and send it to yourself or your team.

The first time this arrives automatically in your inbox on a Friday afternoon, having not thought about it all week, is a genuinely satisfying moment.

Using Templates: The Fastest Way to Start

You don't have to build from scratch. Power Automate has a large library of templates — pre-built flows for common scenarios that you can connect to your own accounts in a few minutes.

To browse them: go to make.powerautomate.com → Templates. Search for your use case. You'll find templates for things like:

• Save Office 365 email attachments to OneDrive
• Send a Teams message for a new Microsoft Forms submission
• Get a push notification for important emails from specific senders
• Create a Planner task from an email
• Post a message to Teams when a SharePoint item is created or modified

Most templates require only a few clicks to connect to your own accounts and customise the details. This is the fastest way to get a working automation running.

Power Automate's Limitations: Where It Doesn't Shine

Power Automate is excellent within the Microsoft ecosystem. Outside it, things get more complicated.

If you're trying to connect non-Microsoft apps — like Xero, Shopify, Mailchimp, Hubspot, or a bespoke system — Power Automate may not have the connector you need, or the connector may require a premium plan. In these cases, tools like Zapier or Make often offer more flexibility.

Power Automate's error messages can also be cryptic when something goes wrong — it's not the most beginner-friendly tool when debugging. And the interface, while improving, can feel cluttered compared to simpler automation tools.

For complex automations involving multiple conditions, loops, and custom business logic, it can get unwieldy. That's where it often makes sense to bring in a developer to build something more robust.

Real Scenarios: How NZ Businesses Are Using It

Here are a few practical examples from how businesses similar to yours are using Power Automate:

• Property management firm: When a maintenance request form is submitted by a tenant, a Teams notification goes to the property manager, an email confirmation goes to the tenant, and a task is created in Planner. What used to be a manual three-step process happens automatically.
• Professional services firm: New client intake forms submitted via the website (Microsoft Forms) automatically create a contact record, trigger a welcome email sequence, and notify the assigned account manager.
• Retail business: A daily scheduled flow checks inventory levels in a SharePoint list and sends a Teams alert if any item drops below the reorder threshold.
• Construction company: Subcontractors submit site reports via a form. Power Automate saves the attached photos to the project folder in SharePoint and sends the report to the project manager.

Getting Started: Your Action Plan

Here's how to go from "never opened it" to "first flow running" in an afternoon:

1. Go to make.powerautomate.com and sign in with your Microsoft 365 account.
2. Browse the template library and find something that matches a real problem you have right now.
3. Follow the prompts to connect your accounts and customise the details.
4. Test it. Most flows have a "Test" button that lets you trigger it manually and see what happens.
5. Turn it on and monitor the run history for the first week to make sure it's working as expected.

If you get stuck, Microsoft's support documentation is genuinely good, and there's an active community forum. Most simple flows are achievable without outside help.

For more complex requirements — integrating Power Automate with external systems, building multi-step approval workflows, or connecting it to custom business applications — that's where I can help. Power Automate is a solid foundation, and with the right setup it can handle surprisingly sophisticated processes. Feel free to get in touch if you'd like to explore what's possible for your specific situation.