Microsoft 365 Business Basic vs Standard vs Premium
A straightforward guide to the Microsoft 365 business plans: what Basic, Standard and Premium each include, when the extra security in Premium is worth it, and where E3 fits.
Power Automate is included with most Microsoft 365 business plans and can take repetitive admin off your team. Here are practical examples, what the licence covers and how to keep automations under control.
Every small business has jobs that follow the same steps every time. An email arrives with an invoice attached and someone saves it to the right folder. A member of staff asks for a day off and waits for a manager to reply. A customer fills in a form and someone copies the details into a spreadsheet. None of these tasks is difficult, but together they eat hours every week.
Microsoft Power Automate is designed to take that kind of repetitive work off your hands. If your business uses Microsoft 365, you probably already have access to it. This guide explains what it does, walks through practical examples that suit small teams, and covers the licensing and governance points worth knowing before you start.
Power Automate lets you build flows. A flow is a simple recipe made of a trigger and one or more actions: when this happens, do that. For example, when an email arrives with an attachment, save the attachment to SharePoint. When a form is submitted, add a row to a list and send a Teams message.
Flows connect apps using connectors. There are connectors for Microsoft services such as Outlook, Teams, SharePoint, OneDrive, Excel and Forms, and for many third party services too. You build flows in a web browser using a visual designer, starting from a blank flow or one of Microsoft's many templates, and newer versions let you describe what you want in plain English to generate a starting point. No programming knowledge is needed for simple flows, although a little patience helps.
Staff fill in a Microsoft Form requesting time off or submitting an expense. The flow sends an approval request to their manager, which they can approve or reject directly from Outlook or Teams. The result is recorded in a SharePoint list and the requester gets an automatic email. Managers no longer lose requests in their inbox and there is a clear record of every decision.
Supplier invoices arriving in a shared mailbox such as accounts@ can be saved straight into a SharePoint folder, organised by month. The finance team works from one place instead of hunting through emails. Be careful to limit this to a trusted mailbox and to file types you expect, and remember that saving an attachment does not make it safe: the usual caution about invoice fraud still applies.
Website enquiries, internal IT requests, health and safety reports or event registrations collected in Microsoft Forms can be added automatically to a Microsoft List. Lists give you a shared, sortable view with columns for status and owner, which is far easier to manage than a spreadsheet passed around by email.
A scheduled flow can check a list each morning and send reminders: contracts due for renewal in 30 days, certificates expiring, equipment due for testing, or client follow ups that are overdue. It turns a calendar note that someone has to remember into a reliable nudge.
When HR adds a new starter to a list, a flow can create a checklist of tasks in Planner, notify the IT provider and remind the manager to book an induction. It will not replace a proper new starter IT checklist, but it makes sure the process starts on time.
Licensing is where many businesses get caught out, so it is worth understanding the basic split.
| Connector type | Examples | Licence needed |
|---|---|---|
| Standard | Outlook, SharePoint, OneDrive, Teams, Forms, Excel Online, Planner and many common third party services | Generally included with Microsoft 365 business plans such as Business Basic, Standard and Premium |
| Premium | SQL Server, HTTP requests, Dataverse, Azure services, custom connectors and some third party services | An additional Power Automate licence, such as Power Automate Premium for each user who runs the flow |
The key rule is that if a flow uses even one premium connector, the flow and its users need premium licensing. Microsoft also applies usage limits to flows and occasionally reclassifies connectors, so check Microsoft's current licensing documentation, or ask your IT provider, before you build anything the business will depend on. Our guide to Microsoft 365 plans explains what each business plan includes more broadly.
For most small businesses, the good news is that the examples above can usually be built with standard connectors alone.
Automation is only helpful if it is reliable. A flow built by one enthusiastic person can quietly become something the whole business depends on, and then break when that person leaves. A few simple habits prevent that.
We help businesses across Sunderland and the North East make better use of the Microsoft 365 tools they already pay for, including Power Automate, Forms, Lists and SharePoint. If you have a process that feels like it should be automatic, we can help you decide whether a flow is the right answer and set it up so it keeps working. A free IT review is a good way to start the conversation.
Yes, most Microsoft 365 business plans include Power Automate with standard connectors such as Outlook, SharePoint, OneDrive, Teams, Forms and Excel Online. Flows that use premium connectors need an additional Power Automate licence.
No. Simple flows are built in a visual designer by choosing a trigger and actions, and Microsoft provides many ready made templates. More complex flows benefit from some technical knowledge, particularly around handling errors and data.
If the flow runs under that person's account and the account is disabled, the flow is likely to stop working. Using a shared or service account for important flows and adding co owners avoids this.
A premium connector links Power Automate to services Microsoft classes as premium, such as SQL Server, HTTP requests, Dataverse and some third party apps. Using one in a flow means the flow and its users need premium licensing.
Our guides are written by the team who support businesses across the North East every day. If anything here raises a question about your own setup, ask us.
Microsoft 365
A straightforward guide to the Microsoft 365 business plans: what Basic, Standard and Premium each include, when the extra security in Premium is worth it, and where E3 fits.
Productivity
Getting a new starter productive on day one, and making sure a leaver's access ends on their last day, both depend on a simple, repeatable checklist. Here is one you can adapt.
Productivity
AI assistants can save real time, but only if they are used with care. This guide covers data protection, what never to paste into an AI tool, tidying SharePoint permissions before Copilot, and a simple acceptable use policy.
Book a free, no obligation IT review. We will look at your setup, tell you honestly what needs attention and give you a clear fixed monthly price.