How to Use Power Automate: A Beginner's Guide for Microsoft 365

What Is Microsoft Power Automate?

Microsoft Power Automate is a cloud-based automation tool included with Microsoft 365 that lets you connect apps and services and automate repetitive tasks — without writing any code. If something in your workday follows a predictable pattern (receive this, do that, notify someone), Power Automate can handle it automatically.

It works on a simple principle: triggers and actions. A trigger is the event that starts a workflow — a new email arrives, a form is submitted, a file is saved to SharePoint. An action is what happens next — a Teams message is sent, a row is added to Excel, an approval request goes to a manager. Chain several actions together, and you have a flow that replaces minutes of manual work every time it runs.

Power Automate connects to over 900 apps and services through pre-built connectors. On the Microsoft side: Outlook, Teams, SharePoint, Excel, OneDrive, Planner, Dynamics 365. Outside Microsoft: Salesforce, Slack, Google Drive, Dropbox, Trello, HubSpot, and dozens more. If your business tools are on that list, there is almost certainly a useful automation waiting to be built.

How to Use Power Automate: Getting Started

If your organization uses Microsoft 365, you already have access to Power Automate. Open the app launcher in Microsoft 365 and look for Power Automate, or go directly to make.powerautomate.com and sign in with your Microsoft 365 account.

Understanding the Interface

When you first open Power Automate, the left navigation shows your key starting points:

• Home: Recent flows, suggested templates, and shortcuts
• Create: Build a new flow from a template or from scratch
• My Flows: All flows you have created or that have been shared with you
• Templates: A library of pre-built flows organized by category (notifications, approvals, data collection, social media)
• Connectors: Browse all available app integrations

For a first-time user, start with Templates. Microsoft has built thousands of ready-to-use flows. Many require nothing more than connecting your accounts — the logic is already done. Browsing templates also teaches you what Power Automate can do far faster than any documentation.

Building Your First Flow From a Template

1. Click Templates in the left navigation.
2. Search for something relevant to your work — "save email attachments," "send approval," "notify Teams," or "add to spreadsheet."
3. Click a template that looks useful. You will see the trigger, actions, and connectors it uses.
4. Click Use this template.
5. Sign in to each connector the template needs (Outlook, SharePoint, Teams, etc.). Power Automate will prompt you.
6. Fill in any required fields — folder paths, email addresses, channel names.
7. Click Save. The flow is now live and will run automatically when triggered.

That is genuinely all it takes for most templates. The first time you see an email attachment automatically appear in a SharePoint folder you did not have to open, the value of the tool becomes immediately obvious.

Building a Flow From Scratch

When no template fits your exact need, build from scratch:

1. Go to Create and select the type of flow: Automated cloud flow (triggered by an event), Instant cloud flow (triggered manually), or Scheduled cloud flow (runs on a timer).
2. Choose your trigger — search for the app and select the event that should start the flow.
3. Click New step to add an action. Search for the app and select what should happen.
4. Use dynamic content — data from the trigger — to make actions contextual. For example, use the email sender's name in the Teams notification body.
5. Add conditions (if/else branching), loops, or parallel branches for more complex logic.
6. Click Test in the top right corner to run it manually and verify it works.
7. Click Save when the test passes.

Looking to get more from your Microsoft 365 subscription? Our guide on how to use Microsoft Copilot to save time covers another powerful M365 productivity tool that pairs naturally with Power Automate.

5 Power Automate Flows Every Small Business Should Set Up

The fastest way to understand Power Automate's value is to see it in action with workflows that matter to a real business. These five flows are widely applicable, easy to build, and deliver visible time savings from day one.

1. Save Email Attachments to SharePoint Automatically

Trigger: New email arrives in Outlook with an attachment
Actions: Save attachment to a specific SharePoint folder; optionally send a Teams notification

This is the most commonly used beginner flow. Instead of manually downloading invoices, contracts, or reports and uploading them to SharePoint, Power Automate does it the moment the email arrives. The template is called "Save Office 365 email attachments to SharePoint" and requires no configuration beyond connecting your accounts and specifying the destination folder.

2. Approval Workflow for Documents or Requests

Trigger: A file is added to a SharePoint folder (or a form is submitted)
Actions: Send an approval request to the designated approver; if approved, notify the requester and move the document; if rejected, send feedback

Manual approval chains — emailing something back and forth with a manager waiting to sign off — are one of the biggest workflow bottlenecks in small businesses. Power Automate's built-in Approvals connector handles the entire process. Approvers get a notification in Teams or Outlook with Approve/Reject buttons. The response triggers the next step automatically. No chasing, no follow-up emails.

3. Onboarding Checklist Trigger

Trigger: A new row is added to an Excel spreadsheet (or a new contact is added in your HR system)
Actions: Send a welcome email from Outlook; create a Planner task for each onboarding step; post a notification to the team in Microsoft Teams

Every time someone new joins the team, the same set of tasks needs to happen. Building this once in Power Automate means it happens consistently, automatically, without anyone having to remember. The flow can also be adapted for client onboarding.

4. Daily or Weekly Summary Report

Trigger: Scheduled (e.g., every Monday at 8:00 AM)
Actions: Query data from Excel, SharePoint, or a connected CRM; compile into a formatted email; send to your team or management

Scheduled flows are ideal for recurring reporting. Instead of someone manually pulling numbers and building an email every Monday morning, the flow runs automatically and delivers the summary before anyone arrives at their desk.

5. Lead Notification From Website Forms

Trigger: A new response is submitted in Microsoft Forms (or a connected form like Typeform or Gravity Forms)
Actions: Send an instant email notification to the sales team; add the lead's details to a SharePoint list or Excel tracker; optionally post to a Teams channel

Many small businesses lose response speed on new leads because the notification process is manual. This flow routes every form submission directly to whoever needs to act on it, in real time, with the lead's information already formatted and logged.

Power Automate Licensing: What Comes With Microsoft 365

One of the most confusing aspects of Power Automate is its licensing structure. Here is the practical version for Microsoft 365 users.

Standard connectors are included with Microsoft 365. All five flows described above use standard connectors — Outlook, SharePoint, Teams, Excel, Planner, Forms, OneDrive. If your flows only use Microsoft's own apps, you will not pay anything extra beyond your existing Microsoft 365 subscription.

Premium connectors require a paid plan. Connectors for Salesforce, Dynamics 365, SQL Server, SAP, Stripe, and hundreds of other business applications are classified as premium. Using them requires either Power Automate Premium ($15/user/month) or Power Automate Process ($150/flow/month for unattended desktop automation). For most small businesses just getting started, standard connectors cover the most valuable use cases.

Power Automate Desktop is included with Windows 10/11. This is the tool for automating desktop applications — clicking through legacy software, filling web forms, copying data between systems that do not have APIs. It is significantly more powerful and requires more setup, but it is available at no additional cost for Windows users.

For context on how Power Automate fits into the Microsoft 365 security and identity framework, see our guide on what is Azure Active Directory — the identity system that governs access to Power Automate and all Microsoft 365 apps.

Power Automate + Copilot: Building Flows in Plain English

Starting in late 2023, Microsoft integrated Copilot directly into Power Automate. Instead of browsing connectors and manually adding steps, you can describe what you want in plain language and Copilot will build the flow for you.

On the Create page, you will see a text box that says "Describe what you'd like to automate." Type something like: "When a new row is added to my Excel order tracker, send an email to the customer with their order confirmation." Copilot generates the flow structure, pre-fills the trigger and actions, and presents it for your review. You make any adjustments, connect your accounts, and save.

This dramatically lowers the barrier for non-technical users. You do not need to know which connector to use or how to structure conditional logic — you describe the outcome, and Copilot handles the construction. For small businesses without dedicated IT resources, this is the fastest path from "I have a repetitive task" to "that task is now automated."

According to Microsoft's Power Automate documentation, the Copilot feature is available to Microsoft 365 commercial subscribers in supported regions and continues to expand with each product update.

Frequently Asked Questions

Is Power Automate the same as Power Automate Desktop?

No, they are different products that often work together. Power Automate (cloud flows) automates tasks between cloud apps and services — Outlook, SharePoint, Teams, Salesforce, etc. It runs in the cloud and does not require a computer to be on. Power Automate Desktop automates tasks on your local computer — clicking through applications, extracting data from websites, filling legacy software forms. Desktop is included free with Windows 10 and 11. Cloud Power Automate is included with Microsoft 365 for standard connectors.

How many flows can I create with Microsoft 365?

Microsoft 365 business plans include access to Power Automate with standard connectors and a limit of 6,000 flow runs per user per month (a "run" is one execution of a flow). For most small businesses automating typical workflows, this limit is more than sufficient. If you have high-volume automations running hundreds of times per day, you may need a standalone Power Automate plan.

Can Power Automate work with non-Microsoft apps?

Yes — over 900 connectors are available, many of them for non-Microsoft services. Standard (free) connectors include services like Twitter/X, RSS feeds, and some basic integrations. Most business applications like Salesforce, SAP, Workday, DocuSign, HubSpot, and Zendesk are classified as premium connectors and require a paid Power Automate plan. You can check whether a specific connector is standard or premium in the Microsoft connector reference.

What is the difference between Power Automate and Zapier?

Both tools automate workflows between apps, but they serve different audiences. Power Automate is deeply integrated with Microsoft 365 — it has first-class connectors for Outlook, Teams, SharePoint, and the entire Microsoft stack that Zapier cannot replicate at the same depth. It is also included with your Microsoft 365 subscription, so there is no additional cost for standard connectors. Zapier is broader in its third-party app coverage and has a simpler setup experience, but it is a paid-only product with costs that scale with usage. For businesses already on Microsoft 365, Power Automate is almost always the better starting point.

Start Automating This Week

The most valuable thing about Power Automate is that it is already included in your Microsoft 365 subscription, waiting to be used. Every repetitive task your team handles manually — forwarding emails, copying data between spreadsheets, chasing approvals, sending status updates — is a candidate for automation. Starting with a single template takes under 15 minutes and delivers visible results from the first run.

At Always Beyond, helping businesses get more from their Microsoft 365 investment is part of what we do every day — from setting up Power Automate workflows to managing your entire Microsoft environment. If you want help identifying what to automate first or building flows that match your specific processes, reach out to Always Beyond and let us show you what your M365 subscription can actually do.