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.
Learn the basics
Flow types, triggers, dynamic content and your first expressions.
Automate SharePoint
Lists, items, files and the flows most teams need first.
Add approvals and messages
Approvals, reminders, email, Teams and Planner.
Go further
Dataverse, advanced expressions, desktop flows and fixing errors.
Topic 01
Fundamentals and core expressions
Flow types, triggers, dynamic content, conditions and the expressions you'll use in every flow.
72 tutorials- Power Automate If condition
- Power Automate multiple conditions
- Power Automate trigger conditions
- Power Automate Do Until loop
- Power Automate parallel branch
- Power Automate initialize variable
- Power Automate increment variable
- Power Automate conversion of string
- Split a string into an array in Power Automate
- Power Automate split string and get first value
- Convert a string to an array in Power Automate
- Append multiple values to an array in Power Automate
- Append a string to an array in Power Automate
- Count items in an array using Power Automate
- Power Automate filter array action
- Check if array is empty in Power Automate
- Check if an array contains value using Power Automate
- Convert an integer to an array in Power Automate
- Convert an array to a string using Power Automate
- Replace characters in Power Automate
Show all 72 tutorials
- Remove characters from string in Power Automate
- Extract substring from text using Power Automate Desktop
- Convert string to integer in Power Automate
- Convert string to decimal in Power Automate
- Convert float to integer in Power Automate
- Convert a number to rounding up or down in Power Automate
- Format a number as currency in Power Automate
- Format number to percentage in Power Automate
- Format number thousand separator in Power Automate
- Format number without decimal in Power Automate
- Format numbers to decimal places using Power Automate
- Format numbers with leading zeros using Power Automate
- Convert percentage to whole number in Power Automate
- Convert decimal to whole number in Power Automate
- Convert a number to hexadecimal in Power Automate
- Convert number to date in Power Automate
- Convert value to string in Power Automate
- Power Automate number format guide
- Power Automate formatDateTime function
- Power Automate convert time zone
- Power Automate add days to date
- Check if the date is weekend in Power Automate
- DayOfWeek function in Power Automate
- Convert string to date for SharePoint list using Power Automate
- The datetime string must match ISO 8601 format error in Power Automate
- Convert string to GUID in Power Automate
- Generate new GUID in Power Automate
- Convert string to object in Power Automate
- Check if SharePoint list column equals in Power Automate
- Check if field is blank in Power Automate
- Power Automate check if person field empty
- Check if the body is empty in Power Automate
- Power Automate If length expression
- Power Automate condition if string
- Check if the filename contains in Power Automate
- Check if SharePoint list is empty in Power Automate
- Check if SharePoint list already exists in Power Automate
- Check if SharePoint site already exists in Power Automate
- Check if the column is changed in Power Automate
- Power Automate – which exceeds the maximum nesting limit of 8
- Power Automate exception handling using try catch
- What is Microsoft Power Platform?
- Power Automate Dynamic Content
- Schedule Flow in Power Automate
- Power Automate Concatenate Strings
- How to Convert String to Date in Power Automate?
- Check IF Date is Today Using Power Automate
- Check If an Input String Is an Integer Using Power Automate
- How to Convert True to Yes in Power Automate?
- How to Change Connection Reference in Power Automate Flow?
- How to Use Environment Variables in Power Platform?
- Preferred Solution in Power Platform: What It Is and How I Use It
Topic 03
Dataverse and data integration
Add, read, count and export Dataverse rows, and move data between systems.
27 tutorials- Power Automate Dataverse add new row
- Update a row in Dataverse using Power Automate
- Get Dataverse created by in Power Automate
- Get choice column value from Dataverse using Power Automate
- Import CSV data to Dataverse Power Automate
- Convert invoice details to Excel AI Builder Power Automate
- Create an array from an Excel table using Power Automate
- Add rows to Excel in Power Automate
- Copy data from one Excel to another Excel in Power Automate
- Send email from Excel using Power Automate
- Extract data from PDF invoices automatically using Power Automate
- Extract invoice details from SharePoint Power Automate AI Builder
- Entity extraction in Power Automate (AI Builder)
- Extract data from Word documents to Excel using Power Automate Desktop
- Create an HTML table from Excel in Power Automate
- Create an HTML table from an array in Power Automate
- Create an HTML table in Power Automate
- Convert XML to string in Power Automate
- Convert XML to JSON using Power Automate
- Convert XML to array in Power Automate
Show all 27 tutorials
- Loop through XML data and insert into Excel using Power Automate
- SharePoint list data to Power Apps using Power Automate
- SharePoint List to Dataverse: Create a Table (4 Ways)
- How to Count Rows From Dataverse Table Using Power Automate
- Get a Row By ID From Dataverse Using Power Automate
- Export Dataverse Table to Excel Using Power Automate
- How to Detect Text in Dataverse Using AI Builder
Topic 04
Approvals, reminders and notifications
Single and multi-level approvals, reminders and notifications.
32 tutorials- Power Automate approval workflow using Microsoft Forms
- Start and wait for an approval in Power Automate
- Power Automate sequential approval flow
- Set multiple approvers in Power Automate
- Power Automate send approval to Microsoft 365 group
- Power Automate send approval to SharePoint group members
- Power Automate add attachments in approval
- Create custom responses in Power Automate approvals
- Start and wait for an approval text in Power Automate
- Approval timeout in Power Automate
- Send email reminders from a SharePoint list using Power Automate
- Send mobile notification using Power Automate
- Send an email with attachments in Power Automate
- Power Automate shared mailbox
- When a new email arrives subject filter in Power Automate
- Send an email with mention in Power Automate
- Send an email with options in Power Automate
- Send an email with attachments from local folder using Power Automate
- Send birthday wishes using Power Automate
- Send approvals in Microsoft Teams using Power Automate
Show all 32 tutorials
- Power Automate flow with Microsoft Teams
- Power Automate forward meeting invite in Outlook
- Create calendar events from a SharePoint list using Power Automate
- Power Automate get display name from email
- Send email with failed flow run link in Power Automate
- Invalid connection, please choose a connection in Power Automate
- User does not have readaccess on connection reference error in Power Automate
- Attempted to perform an unauthorized operation Power Automate
- The user does not exist or is not unique error in Power Automate
- SharePoint Document Approval Using Power Automate
- Power Automate Leave Request Approval Example
- Power Automate Approval Templates to Automate Business Processes
Topic 05
Outlook, Teams and Planner automation
Email, Teams messages, meetings and Planner tasks.
7 tutorials- Power Automate delete emails older than
- Add new attendee to meeting without email others Power Automate
- Power Automate create a task in Microsoft Planner
- Power Automate Email Body Formatting
- Power Automate save email attachment to SharePoint
- Get Manager Details in Power Automate
- Power Automate wrong time zone
Topic 06
Files, PDFs, Excel and Word automation
Create, copy, move and convert files, PDFs, Excel tables and Word documents.
16 tutorials- Power Automate create PDF
- Create a PDF from SharePoint list items using Power Automate
- Merge PDF files in Power Automate
- Merge PDF files in Power Automate Desktop
- Power Automate Desktop loop through Excel rows
- Create a Word document from a SharePoint list item using Power Automate
- Create a Word document from HTML using Power Automate
- Replace text in a Word document in Power Automate
- How to Copy New Files from Your PC to SharePoint using Power Automate?
- Download Files from SharePoint to Local Drive using Power Automate
- How to Move File from OneDrive to SharePoint using Power Automate?
- Power Automate Copy Folder + Power Automate Copy Folder Structure
- Delete All Files In A SharePoint Folder Using Power Automate
- How to Upload File to SharePoint Document Library using Power Apps?
- How to Create CSV File in SharePoint Using Power Apps?
- How to Extract Invoice Data From PDF or Image Using Power Apps and Power Automate
Topic 07
Arrays, JSON, XML and advanced expressions
Arrays, Select and Filter array, JSON parsing and advanced expressions.
1 tutorialTopic 08
Power Automate Desktop and RPA
Desktop flows for Excel, files, web and legacy apps.
13 tutorials- Power Automate Desktop format date
- Power Automate Desktop concatenate strings
- Power Automate Desktop mathematical operations
- Data table in Power Automate Desktop
- Convert data table columns to list in Power Automate Desktop
- List variables in Power Automate Desktop
- Loop actions in Power Automate Desktop
- Create file in SharePoint using Power Automate Desktop
- Create and delete an item from a SharePoint list using Power Automate Desktop
- Get items from SharePoint list using Power Automate Desktop
- Power Automate Desktop SharePoint get items filter query
- Argument body must be binary in Power Automate Desktop
- Get An Item From A List Using Power Automate Desktop
Topic 09
Real-world scenarios, REST API and Copilot
Complete business solutions, the SharePoint REST API, and agent flows in Copilot Studio.
11 tutorials- Expense reimbursement and approval using Power Automate
- Get weather forecast using Power Automate
- Generate QR code using Power Automate
- Power Automate vs Nintex
- Add Copilot Studio knowledge files Power Automate
- Build a Power Apps IT Help Desk Ticketing System with Batch Record Retrieval
- Create an Agent Flow Using Designer in Copilot Studio
- Create an Agent Flow With Natural Language in Copilot Studio
- Create Autonomous Agents in Copilot Studio
- How to Use SharePoint List as Knowledge in Copilot Studio
- 51 Power Apps Interview Questions and Answers For Experienced Developers
Topic 10
Errors and troubleshooting
Common Power Automate error messages, what causes them and how to fix them.
8 tutorials- Power Automate Flow Not Triggering After Owner Account Deleted
- The template language function ‘length’ expects its parameter to be an array or a string Power Automate
- The execution of template action ‘Switch’ failed – Error in Power Automate
- [Solved] AttachmentContentNotValidBase64String Error in Power Automate
- The resource has changed since the caller last read it usually an etag mismatch in Power Automate
- An entry without a type name was found, but no expected type was specified. to allow entries without type information, the expected type must also be specified when the model is specified
- BadRequest. The property ‘columns’ must be specified unless the ‘from’ property value is an array of objects
- Export key attribute for component must begin with a letter Power Automate
Just published
Newest Power Automate tutorials
SharePoint Document Approval Using Power Automate [Step By Step]
Build a Power Apps IT Help Desk Ticketing System with Batch Record Retrieval
Power Automate Smart Task Reminder System for SharePoint [No Premium Connector]
Create a SharePoint List and Column From Excel Using Power Automate [Download Complete Solution]
Create a Location Column in SharePoint List Using Power Automate REST API
How to Create an Image Column in SharePoint List Using Power Automate REST API
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.
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.
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.
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.