Live training: next batches coming soon. Join the waitlist:Waitlists open:Developer Training →Developer →Copilot Studio Training →Copilot Studio →
View Courses
Tutorial hub · free, step by step

Power Automate tutorials

Step-by-step Power Automate tutorials from real projects: cloud flows, expressions, SharePoint and Dataverse automation, approvals, files and documents, desktop flows, and fixes for common flow errors.

244 tutorials10 topicsBy a 13-times Microsoft MVP
Topics

Jump to a topic

Fundamentals and core expressions72SharePoint automation64Dataverse and data integration27Approvals, reminders and notifications32Outlook, Teams and Planner automation7Files, PDFs, Excel and Word automation16Arrays, JSON, XML and advanced expressions1Power Automate Desktop and RPA13Real-world scenarios, REST API and Copilot11Errors and troubleshooting8
Learning path

New to Power Automate? Follow these steps

Already working with Power Automate? Skip ahead to the topic you need.

  1. Learn the basics

    Flow types, triggers, dynamic content and your first expressions.

    Fundamentals and core expressions

  2. Automate SharePoint

    Lists, items, files and the flows most teams need first.

    SharePoint automationFiles, PDFs, Excel and Word automation

  3. Add approvals and messages

    Approvals, reminders, email, Teams and Planner.

    Approvals, reminders and notificationsOutlook, Teams and Planner automation

  4. Go further

    Dataverse, advanced expressions, desktop flows and fixing errors.

    Dataverse and data integrationArrays, JSON, XML and advanced expressionsPower Automate Desktop and RPAErrors and troubleshooting
Topic 01

Fundamentals and core expressions

Flow types, triggers, dynamic content, conditions and the expressions you'll use in every flow.

72 tutorials
Show all 72 tutorials
Topic 02

SharePoint automation

Automate SharePoint lists, items, columns, sites and permissions.

64 tutorials
Show all 64 tutorials
Topic 03

Dataverse and data integration

Add, read, count and export Dataverse rows, and move data between systems.

27 tutorials
Show all 27 tutorials
Topic 04

Approvals, reminders and notifications

Single and multi-level approvals, reminders and notifications.

32 tutorials
Show all 32 tutorials
Topic 05

Outlook, Teams and Planner automation

Email, Teams messages, meetings and Planner tasks.

7 tutorials
Topic 06

Files, PDFs, Excel and Word automation

Create, copy, move and convert files, PDFs, Excel tables and Word documents.

16 tutorials
Topic 07

Arrays, JSON, XML and advanced expressions

Arrays, Select and Filter array, JSON parsing and advanced expressions.

1 tutorial
Topic 08

Power Automate Desktop and RPA

Desktop flows for Excel, files, web and legacy apps.

13 tutorials
Topic 09

Real-world scenarios, REST API and Copilot

Complete business solutions, the SharePoint REST API, and agent flows in Copilot Studio.

11 tutorials
Topic 10

Errors and troubleshooting

Common Power Automate error messages, what causes them and how to fix them.

8 tutorials
Just published

Newest Power Automate tutorials

Want a structured path?

Automate approvals, notifications and SharePoint processes with cloud flows, expressions, AI Builder and Power Automate Desktop. Or see the Power Automate career roadmap with the skills, certification and pay for the role.

Power Automate course
More tutorial hubs

Keep learning across Microsoft 365

SharePoint Online167 tutorials · Sites, lists, libraries, pages, permissions and governance.SharePoint Framework (SPFx)75 tutorials · Web parts, extensions, React, Fluent UI and Microsoft Graph.Power Apps369 tutorials · Canvas and model-driven apps, Power Fx, galleries, forms and Dataverse.Dataverse36 tutorials · Tables, columns, views, solutions and Dataverse in apps and flows.Power BI148 tutorials · Reports, Power Query, DAX, visuals and security.Copilot Studio29 tutorials · AI agents, knowledge sources, agent flows and publishing.Power Pages9 tutorials · Business websites, forms, multistep forms and sign-in.Microsoft Teams109 tutorials · Teams, channels, meetings and working with SharePoint.PowerShell51 tutorials · SharePoint Online and PnP PowerShell, scripts and automation.
Bijay Kumar, 13-times Microsoft MVP
Who writes these tutorials

Bijay Kumar

13-times Microsoft MVP · Founder, TSinfo Technologies

Bijay has more than 18 years of hands-on experience with Microsoft technologies, specializing in SharePoint, the Power Platform, SPFx and Microsoft 365. He has trained thousands of developers and IT professionals through SPGuides, wrote “SharePoint Online Modern Experience Practical Guide”, co-wrote “Microsoft Power Platform: A Deep Dive”, and runs the SPGuides YouTube channel. Every lesson comes from real client projects.

MVP profileLinkedInAbout BijaySPGuides YouTube
FAQ

Frequently asked questions

What is Power Automate used for?

Power Automate automates repetitive work across Microsoft 365 and other apps: approvals, reminders, notifications, file handling, data sync and document generation. Cloud flows run in Microsoft's cloud; desktop flows automate apps on a Windows PC.

Which flow type should I use?

Automated flows start from an event, like a new SharePoint item. Instant flows start from a button, and scheduled flows run on a timetable. Desktop flows automate apps and websites that don't have connectors.

Do I need a premium licence?

Many SharePoint, Outlook and Teams flows use standard connectors included with Microsoft 365. Premium connectors, such as Dataverse and HTTP, need a Power Automate premium licence. Our tutorials say when a solution needs premium.

How do I fix a flow that fails or doesn't trigger?

Open the run history to see which action failed and why. The Errors topic on this page covers the most common messages, including flows that stop after an owner's account is deleted.

Is there a Power Automate certification?

PL-900 covers Power Automate fundamentals. For deeper skills, AB-410 (which replaced PL-200) and AB-400 (replacing PL-400) include Power Automate.