Tutorial hub · Power Automate

Power Automate Tutorials: Learn Cloud Flows, Expressions and Desktop Flows

Every Power Automate tutorial on EnjoySharePoint in one place: cloud flows for SharePoint, Outlook, Teams and Excel, approvals, the expressions you need inside them, and desktop flows for Windows. Every flow is built and run in a real Microsoft 365 tenant.

Bijay Kumar Microsoft MVPPreeti Sahu Microsoft MVPWritten and tested by Bijay Kumar and Preeti Sahu
Updated October 4, 2026
318Power Automate tutorials
18topics, from triggers to expressions
2Microsoft MVP authors
Browse by topic

Pick a Power Automate topic

Jump straight to the connector, expression or task you’re working on. Each topic lists every tutorial we have on it.

Get started with Power AutomateYour first cloud flows, triggers and error handling10 tutorials Variables, loops and flow designVariables, Compose, Apply to each and child flows12 tutorials SharePoint list itemsGet items, filter queries, create and update items22 tutorials SharePoint files and foldersCreate, copy, move and rename files14 tutorials SharePoint sites, columns and attachmentsSites, columns, attachments and choice fields23 tutorials Approval flowsParallel, multilevel, reminders and reassign12 tutorials Outlook email and notificationsSend an email (V2), HTML tables and reminders21 tutorials Teams, Forms, Planner and calendarTeams messages, Forms responses and calendar events18 tutorials Excel, CSV, Word and PDF filesExcel rows, CSV, Word templates and PDF33 tutorials String functionsconcat, substring, split, contains25 tutorials Replace and clean textreplace(), special characters and line breaks16 tutorials Arrays and JSONFilter array, Parse JSON, union and sort23 tutorials Numbers and conversionsint(), float() and number formats16 tutorials Date and time functionsutcNow, formatDateTime, addDays and time zones27 tutorials Conditions and OData filter queriesIF, switch, empty checks and OData filters9 tutorials Power Automate for desktopDesktop flows for Excel, web and PDF19 tutorials Dataverse, Power BI and comparisonsDataverse, Power BI and Logic Apps6 tutorials Power Automate errors and fixesCommon errors and how to fix them11 tutorials
The basics

What is Power Automate?

Power Automate is Microsoft’s service for automating tasks and business processes across apps and services. You can build a flow from scratch, or describe it in plain language and let Copilot build it in the new designer; see how to use Copilot in Power Automate.

The four kinds of flows

  • Automated cloud flows start when something happens, such as a new email or a new SharePoint item.
  • Instant cloud flows start when someone selects a button, for example on a SharePoint item.
  • Scheduled cloud flows run on a timetable you set, such as a report every morning.
  • Desktop flows automate web and desktop apps on Windows, run by you or called from a cloud flow.

Limits you should know

These limits explain most “why did my flow stop?” questions.

  • 30 days
    Maximum flow run durationIncluding steps that wait for an approval.
  • 28 days
    How long an approval can waitAfter that the flow fails, but the approval stays in the action center.
  • 1 to 50
    Apply to each concurrencyLoops run one item at a time by default; turn on concurrency control to run up to 50 in parallel.
  • 60 / 5,000
    Do until iterations60 by default, up to 5,000.
  • 90 days
    Inactive flowsA cloud flow that hasn’t triggered for 90 days may be turned off, unless the owner has a premium or Process license.
  • Licenses
    Free vs PremiumThe free plan for work accounts runs cloud flows with standard connectors. Premium and custom connectors, attended bots and process mining need Power Automate Premium.
Where to start

A Power Automate learning path

New to Power Automate? Work through these in order. Each step builds on the one before.

  1. Create an automated cloud flowRun a flow when something happens
  2. Create an instant cloud flowStart a flow with a button
  3. Create a scheduled cloud flowRun a flow on a timetable
  4. Get SharePoint items with a filter queryOnly the items you need
  5. Loop through items with Apply to eachWork with every item
  6. Send an email with Send an email (V2)The most used action
  7. Build an approval flowApprove and reject
  8. Add error handlingTry, catch and finally
Every tutorial

All 317 Power Automate tutorials, by topic

Every Power Automate tutorial on the site, grouped by task. The expression topics cover text, arrays, numbers, dates and conditions.

SharePoint list items

22 tutorials

Create, get, update and delete SharePoint list items, with Get items filter queries and lists of more than 100 items.

Back to all topics

SharePoint sites, columns and attachments

23 tutorials

Create sites, lists, columns and content types, and work with attachments, choice and multi-select columns.

Back to all topics

Outlook email and notifications

21 tutorials

Send and process email: Send an email (V2), HTML tables, attachments, shared mailboxes and reminders.

Send email

Process email and attachments

Back to all topics

Excel, CSV, Word and PDF files

33 tutorials

Read and write Excel tables, convert CSV and XML, fill Word templates and create PDF files.

Excel

CSV, XML and text files

Word, PDF, HTML and images

Back to all topics

Replace and clean text

16 tutorials

Replace characters, remove line breaks and special characters, and clean up strings.

Back to all topics

Date and time functions

27 tutorials

Work with dates: utcNow, formatDateTime, addDays, time zones and the difference between two dates.

Back to all topics
Fresh

Recently updated Power Automate tutorials

We update tutorials when Microsoft changes something. These are the latest ones, including new tutorials.

Power AutomateUpdated Nov 2, 2026

Fix “Could not find a property named” on type Microsoft.Dynamics.CRM in Power Automate

Power AutomateUpdated Nov 2, 2026

Power Automate trim() Function: Remove Extra Spaces from Text

Power AutomateUpdated Nov 2, 2026

How to Check If a Row Exists in Excel Using Power Automate (Update or Add)

Power AutomateUpdated Nov 2, 2026

How to Check If a String Contains Text in a Power Automate Condition

Power AutomateUpdated Oct 27, 2026

Power Automate chunk() Function: Split a String or Array Into Equal Parts

Power AutomateUpdated Oct 27, 2026

Power Automate substring() Function: Syntax, Examples and Errors

Keep learning

Official docs and more tutorial hubs

For the full reference, go to Microsoft’s documentation. Our other hubs cover SharePoint, Power Apps and the rest of Microsoft 365.

Types of flows in Power AutomateMicrosoft's overview of cloud flows, desktop flows and when to use each
Limits of automated, scheduled and instant flowsRun duration, loops, concurrency, request limits and more, from Microsoft
SharePoint tutorialsSites, lists, libraries, JSON formatting and REST
Power Apps tutorialsCanvas apps, galleries, forms and Power Fx
Power BI tutorialsDAX measures, visuals, slicers and dashboards
Career roadmapRoles, skills and the order to learn them

Get the free Power Automate Expressions Cheat Sheet

122 copy-paste formulas with real business examples, from dates and JSON to SharePoint and error handling. An 86-page PDF, free.

Send me the cheat sheet

Frequently asked questions

What are the types of flows in Power Automate?

There are cloud flows and desktop flows. Cloud flows are automated (they run on an event), instant (they run when someone selects a button) or scheduled (they run on a timetable). Desktop flows automate web and desktop apps on Windows.

How long can a Power Automate flow run?

A flow run can last up to 30 days, including steps that are waiting for approvals. An approval itself can wait for 28 days; after that, the flow fails.

Is Power Automate free?

There’s a free license for work or school accounts that runs cloud flows with standard connectors, without sharing, and desktop flows on your own PC. Premium and custom connectors need Power Automate Premium or another premium license.

What is the default concurrency of Apply to each?

Apply to each processes one item at a time by default. You can turn on concurrency control and run between 1 and 50 iterations in parallel.

Is Power Automate for desktop included in Windows?

Yes. Windows 11 comes with Power Automate for desktop preinstalled. You can build and run desktop flows locally; triggering them from cloud flows needs a work or school account and the right license.