Power Automate Tutorials [Beginners + Advanced]

If you want to learn Power Automate, check out our Power Automate tutorials for beginners to advanced levels. Once you go through all the Power Automate tutorials, you will learn how to use Power Automate.

What is Microsoft Power Automate?

Power Automate, formerly known as Microsoft Flow, is a cloud-based workflow service by Microsoft that enables users to automate day-to-day repetitive tasks across multiple applications and services.

Power Automate offers a wide range of automation capabilities, from simple tasks like sending automated email notifications to more complex operations like capturing data, syncing files, etc.

Organizations use Power Autoamte to streamline repetitive tasks and business processes, increasing efficiency and reducing costs.

By using Microsoft Power Automate, you will be able to connect to various Microsoft and non-Microsoft applications and services. A few are like Microsoft Teams, Microsoft Forms, Planner, SQL Server, Power BI, Azure DevOps, Gmail, Twitter (X), Trello, Dropbox, Slack, GitHub, YouTube, Salesforce, etc. This way, you can connect to more than 500 services in Power Automate.

There are 3 ways to make a flow in Microsoft Power Automate.

  1. Start from blank
power automate tutorial

Microsoft allows you to create a custom flow from scratch based on your business requirements. Here are a few flows to start:

  • Automated cloud flow
  • Instant cloud flow
  • Scheduled cloud flow
  • Desktop flow, etc.
  1. Start from a template

Microsoft provides more than 500 premade templates that you can use directly; it also allows us to do customizations. A few template examples are:

  • Create a Planner task when a channel post starts with TODO
  • Notify a team when Planner tasks change status
  • Send an email for new Tweets about a certain keyword
  • Send an email to responder when response submitted in Microsoft Forms
  • Send an email when a new item is created in SharePoint, etc.
microsoft power automate tutorial
  1. Start with a connector

We can also start a flow from a connector. Connectors are nothing but the apps that we are using day to day. There are more than 500 connectors available that we can start. A few examples are:

  • Office 365 Outlook
  • SharePoint
  • Microsoft Dataverse
  • OneDrive for Business
  • Planner
  • SQL Server
  • Power BI
  • Microsoft Teams
  • Trello
  • Salesforce
  • Asana
  • Azure Data Lake
power automate tutorial for beginners

Power Automate Tutorial For Beginners

Simple methods to begin using Power Automate to automate your life and work. Refer to this Power Automate tutorial to learn more about constructing flows at the beginning level.

This comprehensive guide will explain how to use Power Automate, the differences between it and UI Path, how to collaborate with Microsoft Teams when using Power Automate, and much more.

TutorialsDescriptions
What is Microsoft Power Platform?Before reading about Power Automate, have a look at what is Microsoft Power Platform and how it works.
Power Automate vs UiPathDifferences between Power Automate vs. UiPath.
Power Automate vs NintexLearn what are the differences between Power Automate vs. Nintex.
Scheduled cloud flow in Power AutomateWe can create a scheduled cloud flow that will trigger on a specific schedule; check out the complete tutorial with an example.
Initialize Variable in Power AutomateLearn how to initialize a variable in Power Automate.
Get Display Name From Email in Power AutomateThis tutorial explains how to get the display name from email in Power Automate.
Send a Customized email when a new item is created in a SharePoint list using Power AutomateThis tutorial explains how to Send a Customized email when a new item is created in a SharePoint list using Power Automate.
Get Manager Details in Power AutomateLearn how to get manager details like email address in Power Automate.
When an item is created in SharePoint list send approval and create item using Power AutomateLearn how to use the “When an item is created in SharePoint list, send approval and create an item using Power Automate” flow template.

SharePoint Power Automate Tutorials

SharePoint and Power Automate are tightly connected. Start with any of the more than 100 SharePoint templates, or use the procedure to build your own unique template.

We will learn how to use Power Automate with the SharePoint List and Document Library in this Power Automate SharePoint lesson.

TutorialsDescriptions
Power Automate create sharepoint siteDownload the complete flow to know how to create a sharepoint site using Power Automate.
Auto generate SharePoint column value using Power AutomateLearn how to auto-generate SharePoint list column values using Power Automate.
Create SharePoint Group using Power AutomateThis Power Automate tutorial explains how to create a SharePoint group using Power Automate.
Get items in Power AutomateUse Power Automate “get items” flow action to get all items from a SharePoint Online list.
Power Automate save email attachment to SharePointLearn how to create a flow in Power Automate that will save email attachments to a SharePoint document library.
Copy list items to another list SharePoint using Power AutomateThis SharePoint tutorial explains how to copy list items to another list in SharePoint using Power Automate.
Send Email Reminders from a SharePoint List using Power AutomateCheck out how to send email reminders from a SharePoint list using Power Automate.
Power Automate get items filter query containsLearn how to implement the get items filter query contains in Power Automate.
delete all files in a SharePoint folder using Power AutomateBy using Microsoft Power Automate, we can easily delete all files in a SharePoint folder.
Start and wait for an approval Power AutomateHere is a complete example of Start and wait for an approval in Power Automate.
How to export SharePoint List items to excel using Power Automate and send emailLearn how to export SharePoint list items to Excel using Power Automate and send emails.
Power Automate SharePoint list multiple choice columnThis Power Automate tutorial shows how to convert SharePoint multiple choice column to string using Power Automate.
Create SharePoint Online List and Columns from Excel Using Power AutomateDownload a complete flow on how to create a SharePoint list and columns from Excel using Power Automate.
Create SharePoint List Views using Power AutomateLearn how to create SharePoint list views using Power Automate.
Delete a SharePoint list view using Power AutomateThis Power Automate tutorial explains how to delete a list view in SharePoint using Power Automate.
Create Calendar Events from a SharePoint list using Power AutomateHere, I have explained how to create a calendar event from a SharePoint list using Power Automate.
Add Site columns to SharePoint content type using Power AutomateBy using Power Automate, we can add site columns to the SharePoint content type.
Update SharePoint List Field with today’s date in Power AutomateLearn how to update the SharePoint list field with today’s date in Power Automate.
Power Automate check if file existsThis Power Automate tutorial explains how to check if a file exists in the SharePoint document library in Power Automate.
Convert XML to SharePoint List using Power AutomateLearn how to convert XML to a SharePoint list using Power Automate.
Send an Email with Attachments in Power AutomateThis Power Automate tutorial explains how to send an email with an attachment in Power Automate.
Send an Email with Attachments from Local Folder using Power AutomateLearn how to send an email with attachments from local folders using Power Automate.
Create Multiple Sites in SharePoint Online using Power Automate from ExcelLearn how to create bulk sites in SharePoint Online using Power Automate from Excel. Download the complete flow.
Download files from SharePoint to Local Drive using Power AutomateLearn how to download files from a SharePoint document library to a local folder using Power Automate.
delete all items from a SharePoint list using Power AutomateThis tutorial explains how to delete all SharePoint list items using Power Automate.
Move File from OneDrive to SharePoint using Power AutomateLearn how to move files from OneDrive to the SharePoint document library using Power Automate.
Create a Word Document from a SharePoint list item using Power AutomateThis tutorial explains how to Create a Word Document from a SharePoint list item using Power Automate.

Power Automate Advanced Tutorials

Your mind will be stretched as we look into a range of ideas and develop some original flows for either our own usage or to satisfy business requirements.

With the help of the Power Automate Advanced Tutorial, we were able to comprehend how to create some unique Power Automate flows and seamlessly integrate them into our system.

TutorialsDescriptions
Power Automate if expressionThis tutorial explains how to use if expression Power Automate.
Power Automate Trigger ConditionsLearn about the trigger conditions in Power Automate.
dynamic content in Power AutomateLearn how to add dynamic content in Power Automate.
Rest API in Power AutomateThis Power Automate tutorial explains how to use Rest API in Power Automate.
Create an HTML Table in Power AutomateThis Power Automate tutorial explains how to create an HTML table in Power Automate.
Create an HTML Table from an Array in Power AutomateThis Power Automate tutorial explains how to create an HTML table from an array.
Create an HTML Table from Excel in Power AutomateLearn how to create an HTML table from Excel in Power Automate.
Power Automate formatdatetimeLearn how to use formatdatetime() in Power Automate.
Apply Filter Between Dates in Power AutomateLearn how to apply filter between dates in Power Automate.
Power Automate Exception handling using Try Catch BlockLearn how to do exception handling using Try Catch Block in Power Automate.
Convert Decimal to Number in Power AutomateLearn how to convert a decimal to a number in Power Automate.
Power Automate format number as currencyLearn how to format a number as currency in Power Automate.
Concatenate String in Power AutomateLearn how to concatenate strings in Power Automate using concat() method.
Convert time zone in Power AutomateIn Power Automate, we can easily convert time zone, like from UTC to local time, Pacific time to UTC, etc.
Convert string to float in Power AutomateLearn how to convert a string to float in Power Automate.
Power Automate increment variableLearn how to increment a variable in Power Automate.
adddays in Power AutomateWe can use the adddays() in Power Automate to add days to a date.
do until in Power AutomateLearn how to use do until in Power Automate.
Power Automate email body formattingLearn how to format email body in Power Automate.
Power Automate multiple conditionsThis tutorial explains how to use multiple conditions in Power Automate.
Power Automate split string into arrayThis Power Automate tutorial explains how to split a string into an array in Power Automate.
Append a string to an array in Power AutomateThis tutorial explains how to append a string to an array in Power Automate.
Power Automate remove characters from stringThis tutorial explains how to remove characters from string in Power Automate.
Power Automate Filter ArrayLearn how to filter array in Power Automate with a few examples.
Power Automate append to array variableLearn how to append to array variable in Power Automate.
Create an array from an Excel table using Power AutomateThis Power Automate tutorial explains how to create an array from an Excel table.
Copy Data from One Excel to Another Excel in Power AutomateThis Power Automate tutorial explains how to copy data from one Excel to another Excel in Power Automate.
Insert XML data into Excel using Power AutomateLearn how to loop through XML data and insert it into Excel using Power Automate.
Convert XML to JSON using Power AutomateThis tutorial explains how to convert XML to JSON using Power Automate.
Convert XML to Array in Power AutomateThis tutorial explains how to convert XML to an array in Power Automate.
Convert XML to string in Power AutomateLearn how to convert XML to string in Power Automate.
Convert Array to String using Power AutomateThis Power Automate tutorial explains how to convert an array to a string using Power Automate.
Convert True to Yes in Power AutomateLearn how to convert True to Yes in Power Automate.
Convert Float to Integer in Power AutomateThis tutorial explains how to convert float to integer in Power Automate.
Format Numbers with Leading Zeros Using Power AutomateThis tutorial explains how to format numbers with leading zeros using Power Automate.
Convert String to Date for SharePoint list using Power AutomateThis tutorial explains how to Convert String to Date for SharePoint list using Power Automate.
Format Number to Percentage in Power AutomateLearn how to format a number to a percentage in Power Automate.
Format Numbers to Decimal Places Using Power AutomateThis tutorial explains how to Format Numbers to Decimal Places Using Power Automate.
format number in Power AutomateCheck how to use the formatnumber() function in Power Automate.
Convert Value to String in Power AutomateCheck how to convert a value to a string in Power Automate.
Convert an Integer to an Array in Power AutomateThis tutorial explains how to convert an integer to an array in Power Automate.
Power Automate wrong time zoneLearn how to fix the wrong time zone issue in Power Automate.
Convert a Number to Rounding UP or Down in Power AutomateThis tutorial explains how to Convert a Number to Rounding UP or Down in Power Automate.
Format Number Thousand Separator in Power AutomateThis Power Automate tutorial explains how to Format Number Thousand Separator in Power Automate?
Convert String to Decimal in Power AutomateLearn how to convert a string to a decimal number in Power Automate.
Convert String to Object in Power AutomateThis tutorial explains how to convert string to object in Power Automate.
Convert a String to an Array in Power AutomateLearn how to convert a string to an array in Power Automate.
Convert String to Integer in Power AutomateThis tutorial explains how to convert string to integer in Power Automate.
Convert String to Float in Power AutomateThis Power Automate tutorial explains how to convert a string to float in Power Automate.

Power Automate Examples

You can develop unique document templates, automate the approval process for leave requests, and much more for your organization with the help of these useful Power Automate examples.

ExamplesDescriptions
Expense Reimbursement and Approval using Power AutomateDownload and use a Power Automate flow on “Expense Reimbursement and Approval using Power Automate”.
Leave Request Approval Flow using Power AutomateThis is a leave request approval for using Microsoft Power Automate; check out the complete tutorial.
Upload PowerApps Attachments to SharePointThis tutorial explains how to upload Power Apps attachments to the SharePoint document library.
Power Automate Shared MailboxLearn how to automate “when a new email arrives in a shared mailbox in Power Automate”.
Create PDF in Power AutomateLearn how to create a PDF in Power Automate.
Power Automate Copy FilesThis tutorial explains how to copy files from one folder to another using Power Automate.
Power Automate Copy FoldersLearn how to copy folders using Power Automate, including copy folders and subfolders.
Create a task in Microsoft Planner using Power AutomateBy using Microsoft Power Automate, we can create a task in Panner. This tutorial also explains how to create planner tasks from email in Power Automate.
Power Automate Parallel Branch with ExamplesLearn how to use parallel branch in Power Automate with examples.
Power Automate OData filter query with examplesLearn with examples how to use odata filter query in Power Automate.
Get Dataverse List Rows Count Using Power AutomateThis tutorial explains how to get Dataverse list rows count using Power Automate.
Get Row by ID From Dataverse TableLearn how to get row by id from Dataverse table in Power Automate.
Detect Text in Dataverse Using AI BuilderLearn how to detect text in Dataverse using AI Builder in Power Automate.
Add a new row dataverse using Power AutomateLearn how to add a new row in Dataverse using Power Automate.
Get Dataverse Created by in Power AutomateLearn how to get Dataverse created by in Power Automate.
Update a Row in Dataverse Using Power AutomateLearn how to update a row in Dataverse using Power Automate.
Save Microsoft Forms Responses and Attachments to SharePoint Lists using Power AutomateThis Power Automate tutorial explains how to save Microsoft Forms responses and attachments to SharePoint lists using Power Automate.
Add Rows to Excel in Power AutomateThis Power Automate tutorial explains how to add rows to Excel.
Merge PDF files in Power AutomateThis Power Automate tutorial explains how to merge PDF files in Power Automate.
Power Automate delete emails older thanHere is an example of deleting emails older than in Power Automate.
Power Automate replace text in word documentThis Power Automate tutorial explains how to replace text in a Word document.
Create a Word Document from HTML using Power AutomateLearn how to create a Word document from HTML using Power Automate.
Send an email with options in Power AutomateLearn how to send an email with options in Power Automate.
Power Automate send excel file in emailLearn how to send an Excel file by email using Power Automate.
When a New Email Arrives Subject Filter in Power AutomateLearn how to create a flow that will trigger when a new email arrives with subject filter in Power Automate.

Power Automate Microsoft Teams Tutorials

Here is a list of Power Automate tutorials with Microsoft Teams.

TutorialsDescription
Create a teams meeting using Power AutomateWe can easily create a teams meeting using Power Automate in Microsoft Teams.

Power Automate Desktop Tutorials

Using the Power Automate desktop, you can connect old and new systems and reduce repetitive tasks using UI-based automation with desktop flows—the robotic process automation (RPA) capability in Power Automate.

If you are using Microsoft Power Automate Desktop, check out the list of tutorials below:

TutorialsDescription
Extract Data from Word Documents to Excel using Power Automate DesktopThis tutorial explains how to extract data from Word documents to Excel using Power Automate Desktop.
List variables in Power Automate DesktopCheck out the list of variables in Power Automate Desktop.
Data table in Power Automate DesktopLearn how to work with a data table in Power Automate Desktop.
Loop through Excel rows in Power Automate DesktopThis tutorial explains how to loop through Excel rows in Power Automate Desktop.
Extract substring from text using Power Automate DesktopLearn how to extract a substring from text using Power Automate Desktop.
Power Automate Desktop Mathematical OperationsCheck out various Mathematical operations using Power Automate Desktop.
Concatenate Strings in Power Automate desktopThis Power Automate tutorial explains how to concatenate strings.
Loop actions in Power Automate DesktopCheck out various loop actions in Power Automate Desktop.
Get an item from a SharePoint list using Power Automate DesktopLearn how to get an item from a SharePoint list using Power Automate Desktop.
Merge PDF files in Power Automate DesktopCheck out how to merge PDF files in Power Automate Desktop
Create File in SharePoint using Power Automate DesktopThis tutorial explains how to create a file in SharePoint using Power Automate Desktop.
Convert Data Table Columns to List in Power Automate DesktopThis tutorial explains how to convert data table columns to a list in Power Automate Desktop.
Get items from SharePoint List using Power Automate DesktopLearn how to get items from a SharePoint list using Power Automate Desktop.
Create and Delete an Item from a SharePoint List using Power Automate DesktopThis tutorial explains how to create and delete an item from a SharePoint list using Power Automate Desktop.
Update Items in a SharePoint List in Power Automate DesktopLearn how to update items in a SharePoint list using Power Automate.
Power Automate Desktop SharePoint Get items Filter QueryLearn how to use get items filter query to filter SharePoint list items using Power Automate.

Power Automate Errors & Solutions

There may be a great number of errors or issues with Power Automate that were made during the development process. Since we are the ones who created the issue in the first place, we must address it and fix it.

This article on Power Automate faults and fixes may help you match up a number of flow errors and their fixes.

ErrorsDescriptions
The execution of template action ‘Switch’ failed: The result of the evaluation of ‘scope’ action expression ‘@triggerBody()?[‘ApprovalStatus’] is not validThis Power Automate tutorial explains how to fix the error: “The execution of template action ‘Switch’ failed: The result of the evaluation of ‘scope’ action expression ‘@triggerBody()?[‘ApprovalStatus’] is not valid”.
Invalid Connection. Please Choose a Connection Power AutomateThis tutorial explains how to fix the error “Invalid Connection. Please Choose a Connection Power Automate”.
attempted to perform an unauthorized operation. power automate errorLearn how to fix the error “attempted to perform an unauthorized operation. power automate error”
Power Automate which exceeds the maximum nesting limit of ‘8’Learn how to fix the error, Power Automate which exceeds the maximum nesting limit of ‘8’.
Remove unwanted properties from an object using Power AutomateLearn how to remove unwanted properties from an object using Power Automate.
‘The user does not exist or is not unique’ error in Power AutomateLearn how to fix the error ‘The user does not exist or is not unique’ error in Power Automate.
BadRequest. The property ‘columns’ must be specified unless the ‘from’ property value is an array of objectsLearn how to fix the error BadRequest. The property ‘columns’ must be specified unless the ‘from’ property value is an array of objects.
Argument ‘Body’ must be ‘Binary’ – Power Automate Desktop errorLearn how to fix the error Argument ‘Body’ must be ‘Binary’ – Power Automate Desktop error.
The DateTime String must match ISO 8601 format error in Power AutomateThis tutorial explains how to fix the Power Automate error “The DateTime String must match ISO 8601 format”.
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 specifiedThis tutorial explains how to fix the Power Automate error 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.
The resource has changed since the caller last read it usually an etag mismatch in Power AutomateLearn how to fix the Power Automate error “The resource has changed since the caller last read it usually an etag mismatch” in Power Automate”.

Conclusion

I hope you enjoyed these Power Automate tutorials. I hope you can learn Power Automate step by step by following these Power Automate examples.

>