Microsoft Power Automate is one of the most powerful — and underused — tools available to businesses today. If you have Microsoft 365, you may already have access to it at no extra cost. In this tutorial, you'll go from zero to your first working automation in under 30 minutes.
🎯 What You'll Learn
✅ What Power Automate is and how it works
✅ The 3 types of flows (Cloud, Desktop, Business Process)
✅ How to build your first email automation — step-by-step
✅ 10 practical flow templates to copy today
✅ Common beginner mistakes and how to avoid them
1. What is Microsoft Power Automate?
Power Automate (formerly Microsoft Flow) is a cloud-based automation platform that lets you create workflows — called "flows" — that connect your apps and automate repetitive tasks without writing code.
Think of it like a digital assistant that watches for events (a new email, a form submission, a calendar reminder) and automatically takes action (saves a file, sends a notification, updates a spreadsheet).
Real example: Every time someone fills out your website contact form → Power Automate automatically saves their details to an Excel sheet AND sends them a welcome email AND creates a task in Microsoft Teams for your team. All without you touching anything.
Who uses Power Automate?
- Office workers — automating email responses, approvals, data entry
- IT teams — connecting internal systems without custom development
- Small businesses — automating invoices, customer follow-ups, reporting
- Developers — building complex enterprise-grade automation with desktop RPA
2. The 3 Types of Power Automate Flows
Cloud Flows
Connect web apps and online services. Trigger from events like a new email, form submission, or file upload. Best for everyday business automation.
Example: Email → Save to SharePoint
Desktop Flows (RPA)
Record and replay actions on your Windows computer. Works with any app — even old legacy software with no API. This is robotic process automation (RPA).
Example: Auto-fill a local ERP form
Business Process Flows
Guide users through standard business processes step-by-step. Used in sales pipelines, onboarding, and approval workflows with defined stages.
Example: Lead qualification process
👉 For beginners, start with Cloud Flows. They're the easiest to build and provide immediate value.
3. Getting Started with Power Automate (Free)
Step 1: Access Power Automate
You can access Power Automate three ways:
- Microsoft 365 subscribers: Go to make.powerautomate.com — it's already included
- Free account: Sign up at powerautomate.microsoft.com with any Microsoft account
- Windows users: Power Automate Desktop app is free on Windows 10/11
Free Plan includes: 6,000 flow runs/month, 750+ connectors, Dataverse access (limited). More than enough to get started and build real automations.
Step 2: Understand the Interface
When you open Power Automate, you'll see:
- My Flows — all your created flows
- Create — start a new flow from scratch or template
- Templates — 300+ pre-built flows ready to use
- Connectors — directory of all apps you can connect (1,000+)
- Monitor — see run history and debug errors
4. Build Your First Flow: Auto-Save Email Attachments to OneDrive
This is one of the most useful beginner flows. Every time you receive an email with an attachment, it's automatically saved to a OneDrive folder — organized by date.
📋 Flow Overview
Trigger: New email arrives in Outlook with attachment
Action 1: Check if email has an attachment
Action 2: Save each attachment to OneDrive/Email-Attachments/[Date]
Action 3: Send yourself a Slack/Teams notification
Time to build: ~15 minutes
Step-by-Step Instructions
Step 1 — Create a New Flow
- Go to make.powerautomate.com
- Click Create in the left sidebar
- Choose "Automated cloud flow"
- Give it a name: "Save Email Attachments to OneDrive"
- Search for trigger: "When a new email arrives (V3)" (Outlook)
- Click Create
Step 2 — Configure the Trigger
- In the trigger settings, set Include Attachments: Yes
- Set Only with Attachments: Yes
- You can filter by folder (e.g., Inbox only) or leave it on all mail
Step 3 — Add "Apply to Each" Loop
- Click + New Step
- Search for "Apply to each" (Control)
- In the "Select an Output" field, click Attachments from the trigger
- This creates a loop that handles emails with multiple attachments
Step 4 — Save to OneDrive
- Inside the loop, click Add an action
- Search for "Create file" → choose OneDrive for Business
- Set Folder Path:
/Email-Attachments - Set File Name: click the dynamic content → choose Attachments Name
- Set File Content: click dynamic content → choose Attachments Content
Step 5 — Save and Test
- Click Save (top right)
- Click Test → choose "Manually"
- Send yourself an email with a file attached
- Watch the flow run — green checkmarks = success!
- Check your OneDrive/Email-Attachments folder
Congratulations! You've built your first Power Automate flow. Every email with an attachment will now be saved to OneDrive automatically — forever — without you doing anything.
5. 10 Best Power Automate Templates for Beginners
You don't have to build everything from scratch. Power Automate has hundreds of pre-built templates. Here are the 10 most useful for beginners:
| # | Flow Template | Apps | Time Saved |
|---|---|---|---|
| 1 | Save email attachments to OneDrive | Outlook + OneDrive | ⭐⭐⭐⭐⭐ |
| 2 | Get a push notification when boss emails you | Outlook + Mobile | ⭐⭐⭐ |
| 3 | Post new Twitter/X mentions to Teams channel | Twitter + Teams | ⭐⭐⭐⭐ |
| 4 | Send reminder when task is overdue | Planner + Outlook | ⭐⭐⭐⭐ |
| 5 | Copy new SharePoint files to Teams | SharePoint + Teams | ⭐⭐⭐⭐⭐ |
| 6 | Auto-approve vacation requests under 3 days | Forms + Outlook + SharePoint | ⭐⭐⭐⭐⭐ |
| 7 | Send birthday wishes automatically | Excel + Outlook | ⭐⭐⭐ |
| 8 | Save Microsoft Forms responses to Excel | Forms + Excel | ⭐⭐⭐⭐⭐ |
| 9 | Daily weather report email | MSN Weather + Outlook | ⭐⭐ |
| 10 | Create Planner task from flagged email | Outlook + Planner | ⭐⭐⭐⭐ |
How to use templates: Go to Templates in the left menu → search for any template above → click it → sign in to the required apps → click Create flow. Done in 2 minutes!
6. Pro Tips for Power Automate Beginners
✅ Tip 1: Use Conditions to Make Flows Smarter
A Condition step lets your flow take different paths. Example: "If the email is from @company.com → save to SharePoint. Otherwise → send a notification."
Find it: + New step → Control → Condition
✅ Tip 2: Use Variables to Store Data
Variables let you store and reuse values across your flow. Example: Store a timestamp at the start and use it to name files later.
Find it: + New step → Variables → Initialize variable
✅ Tip 3: Monitor Your Flows
Go to Monitor → Cloud flow activity to see every run, whether it succeeded, and exactly where it failed if there's an error. This is essential for debugging.
✅ Tip 4: Start with Templates, Then Customize
Don't build from scratch unnecessarily. Use a template as your base and modify it. You'll save 80% of the setup time.
✅ Tip 5: Test Before Going Live
Always use the built-in Test button before relying on a flow. Real tests catch issues that look fine on paper.
❌ Common Beginner Mistakes
- Not handling errors: Add a "Run after" configure step to catch failures
- Infinite loops: If an update in SharePoint triggers a flow that updates SharePoint again — infinite loop! Add a condition to prevent it
- Using wrong trigger: "When a file is created or modified" vs "When a file is created" — small difference, big impact
- Too many steps in one flow: Break complex automations into multiple flows that call each other
7. Power Automate vs Zapier — Which Should You Use?
| Feature | Power Automate | Zapier |
|---|---|---|
| Best for | Microsoft 365 users | Everyone else |
| App integrations | ~1,000 | 6,000+ |
| Desktop automation (RPA) | ✅ Yes | ❌ No |
| Free plan | ✅ Good free tier | ✅ Limited (100 tasks/mo) |
| Ease of use | ⭐⭐⭐ | ⭐⭐⭐⭐⭐ |
| AI features | ✅ AI Builder built-in | ✅ AI Zap builder |
Bottom line: If you're a Microsoft 365 user, start with Power Automate — it may be free for you. If you use many non-Microsoft apps, Make.com or Zapier may be better →
8. Power Automate Pricing (2025)
| Plan | Price | Best For |
|---|---|---|
| Free (M365) | $0 (included in M365) | M365 subscribers |
| Free Standalone | $0 | Personal/testing |
| Premium | $15/user/month | Premium connectors (Salesforce, SAP) |
| Process | $150/bot/month | Unattended desktop automation (RPA) |
| Hosted Process | $215/bot/month | Cloud-hosted RPA without physical machine |
Key insight: If your company has Microsoft 365 Business Basic ($6/user) or higher, Power Automate cloud flows are already included. Check with your IT admin before purchasing a separate plan.
Also compare: Power Automate vs Zapier — Full Comparison →