Power Automate Tutorial: Build Your First Flow Step by Step

Picture the same chore every morning: saving attachments into a folder, copying numbers into a spreadsheet, then sending a quick confirmation. That’s time you’d rather spend on real work.

Power Automate can take it over with a flow, a set of steps that runs on its own once something triggers it.

This tutorial covers what Power Automate is, how cloud flows differ from desktop flows, what the free and paid plans offer, and how to build and monitor your first flow.

We’ll keep it practical, with a home office lens on the chores you can hand off today.

Beginner Flows in This Power Automate Tutorial

On Windows, Power Automate is Microsoft’s tool for building flows, which handle the repetitive clicking and copying you already do by hand.

Your first flow in under 15 minutes

You can get started in under 15 minutes, and Windows 10 users get it free. Microsoft Learn’s beginner training introduces workflow concepts and walks you through making your first flow.

Making your first flow means choosing a trigger, which starts it, then adding actions, the steps it takes. Picture a home office bookkeeper who retypes invoice details into a spreadsheet every Friday.

A starter flow can take that step over and hand back the hour.

Common uses include:

• moving attachments to cloud storage
• sending reminders
• filling in forms

Where you can open Power Automate

You can open Power Automate from three places:

• Microsoft 365. Handy if your mail and documents already live there.
• SharePoint. Useful when your shared files sit in a SharePoint library.
• OneDrive. A good entry point for files you keep on your own.

The navigation menu then links your flows, templates, and connectors (the links to other apps). Pick the route closest to your files, not the one that merely seems fastest.

Start flows from templates or from scratch

• Create flow from templates. A template is a prebuilt flow you adjust, so it’s the quickest start.
• Create flow manually. You choose each trigger and action yourself.
• Create flow from scratch. An empty canvas gives full control, but you’ll do more building and less borrowing.

A cloud flow runs in the cloud and starts when something happens, on a schedule, or with a button press. Pick one annoying task and start there.

The Parts Every Flow Is Built From

Cloud flows connect online services, while desktop flows automate your own computer. Either way, every flow is built from the same few parts.

How triggers, conditions and actions connect apps

• Triggers start the flow, like a new email.
• Conditions check a rule and split the flow into paths.
• Actions do the work, like saving a file.
• Integrations are connectors that link each step to an app.

Picture a bookkeeper working from home who gets client invoices by email. A trigger catches each attachment, a condition checks the subject line, and two actions save the invoice file and log the amount. No retyping.

A condition doesn’t do the work; it decides which work gets done.

Storing data with variables, no coding needed

A variable is a labeled container that holds a piece of information while the flow runs. Give it a clear name, like InvoiceCount, and any later step can read or update it, no code required.

Variables let a flow remember things between steps, which makes them essential for non-programmers. To handle one:

1. initialize it with a starting value,
2. update it where it should change, and
3. name it so it makes sense next month.

Checking flow runs and fixing failures

Power Automate logs each run, showing every step and whether it succeeded. Check that history now and then so quiet failures don’t slip by. When one breaks, work through these steps:

1. Open the run history and select the failed run.
2. Click the red step and read its error message.
3. Fix the cause, like an expired sign-in.
4. Rerun the flow to confirm it works.

For our bookkeeper, a renamed folder caught early is a quick fix, not a month-end scramble.

Desktop Automation with Power Automate for Desktop

Not every repetitive chore lives in the cloud. Plenty happens on the desktop, and we’ll cover three common areas.

Clicking buttons and windows like a person

A desktop flow can click any user interface (UI) element, meaning a button, field, or menu, and maximize or minimize windows.

Picture a home office bookkeeper who sets up a flow to open the bank portal each morning, click through to the statement, and size the window before the day starts. The flow copies what you click, not how the app is built. Your hands stay on the keys.

Downloading browser files and a link workaround

Downloading files from a browser can be a stumbling block. The click download link action doesn’t always behave as expected, and if the file never lands, every step that needs it stalls.

What matters is the file on disk, not the click that’s meant to get it there. A working workaround exists, so set it up before a flow depends on the download.

Editing text and dates across Excel rows

Spreadsheets are where text and dates drift out of shape:

• Replace and split text. Swap out unwanted characters or break one cell into two.
• Convert datetime to text. Turn a datetime (a date and time value) into plain text in the format another system expects.
• Loop through Excel rows. Repeat the same edits on every row so none gets skipped.
• Text and date consistency. Run these together so the sheet matches before it goes anywhere.

Consider a home office admin whose monthly export mixes real dates with typed text. A loop walks every row, converts each date to one format, and splits the names, so nothing needs manual cleanup. Every row, every time.

Plans, Updates, and Sharing Your Flows

Plans and updates shape what you can build, so check both first.

How licensing works and what’s free

Is Power Automate free? A free tier exists, but free doesn’t mean unlimited.

A Microsoft Fabric Community thread notes that the free tier has significant limits on how often flows run and which connectors (links to other apps) they can use. Read the fine print.

A freelance bookkeeper who wants a flow to save invoice attachments every few minutes could hit those limits fast, so check them before you build.

Licensing gets complicated fast, since your plan decides what your flows can do.

Nothing in our research says Power Automate is being replaced, so if its limits feel tight, compare AutoHotkey (a Windows automation tool) and Shortcuts (Apple’s built-in automation app).

Power Automate connects apps, while AutoHotkey drives your keyboard and mouse.

Feature updates from 2021 and 2022

Four updates stand out:

• SharePoint connector actions (August 2022). New actions let flows work with SharePoint directly.
• Unified recorder (December 2021). Use it to capture your own clicks and keystrokes as a starting point.
• Script editor syntax highlighting. Color-coding makes scripts easier to scan when you tweak a flow by hand.
• Entity recognition action. It picks out named details, such as names and dates, from text.

Consider a remote admin who sorts dozens of order emails each morning. Entity recognition can pull out the customer names and dates, so that daily sort takes care of itself.

Three ways to share desktop flows

Sharing a desktop flow (one that runs on your own computer) is the next step, and there are three ways to do it. We don’t have those steps here, so check Microsoft’s current documentation before you start.

Before you share one, confirm the recipient’s plan covers it, since licensing decides what they can run.

You now know what Power Automate is, how cloud and desktop flows differ, and how to build and monitor your first one. Start small with a single chore, like the attachment routine from the intro, and watch it run for a week.

Hand off the repetitive tasks, and your attention goes back to the work that needs you. Keep your flows simple, check them now and then, and they’ll keep handling the boring parts while you focus on what matters most.

References

1. Build your first Power Automate for desktop flow - Training — learn.microsoft.com
2. Solved: Power Automate is free with Power BI Pro Licence — community.fabric.microsoft.com (2026)