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.
- Start from blank
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.
- 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.
- 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
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.
| Tutorials | Descriptions |
|---|---|
| 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 UiPath | Differences between Power Automate vs. UiPath. |
| Power Automate vs Nintex | Learn what are the differences between Power Automate vs. Nintex. |
| Scheduled cloud flow in Power Automate | We 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 Automate | Learn how to initialize a variable in Power Automate. |
| Get Display Name From Email in Power Automate | This 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 Automate | This 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 Automate | Learn 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 Automate | Learn 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.
| Tutorials | Descriptions |
|---|---|
| Power Automate create sharepoint site | Download the complete flow to know how to create a sharepoint site using Power Automate. |
| Auto generate SharePoint column value using Power Automate | Learn how to auto-generate SharePoint list column values using Power Automate. |
| Create SharePoint Group using Power Automate | This Power Automate tutorial explains how to create a SharePoint group using Power Automate. |
| Get items in Power Automate | Use Power Automate “get items” flow action to get all items from a SharePoint Online list. |
| Power Automate save email attachment to SharePoint | Learn 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 Automate | This 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 Automate | Check out how to send email reminders from a SharePoint list using Power Automate. |
| Power Automate get items filter query contains | Learn how to implement the get items filter query contains in Power Automate. |
| delete all files in a SharePoint folder using Power Automate | By using Microsoft Power Automate, we can easily delete all files in a SharePoint folder. |
| Start and wait for an approval Power Automate | Here 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 email | Learn how to export SharePoint list items to Excel using Power Automate and send emails. |
| Power Automate SharePoint list multiple choice column | This 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 Automate | Download a complete flow on how to create a SharePoint list and columns from Excel using Power Automate. |
| Create SharePoint List Views using Power Automate | Learn how to create SharePoint list views using Power Automate. |
| Delete a SharePoint list view using Power Automate | This Power Automate tutorial explains how to delete a list view in SharePoint using Power Automate. |
| Create Calendar Events from a SharePoint list using Power Automate | Here, 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 Automate | By using Power Automate, we can add site columns to the SharePoint content type. |
| Update SharePoint List Field with today’s date in Power Automate | Learn how to update the SharePoint list field with today’s date in Power Automate. |
| Power Automate check if file exists | This 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 Automate | Learn how to convert XML to a SharePoint list using Power Automate. |
| Send an Email with Attachments in Power Automate | This 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 Automate | Learn how to send an email with attachments from local folders using Power Automate. |
| Create Multiple Sites in SharePoint Online using Power Automate from Excel | Learn 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 Automate | Learn 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 Automate | This tutorial explains how to delete all SharePoint list items using Power Automate. |
| Move File from OneDrive to SharePoint using Power Automate | Learn 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 Automate | This 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.
| Tutorials | Descriptions |
|---|---|
| Power Automate if expression | This tutorial explains how to use if expression Power Automate. |
| Power Automate Trigger Conditions | Learn about the trigger conditions in Power Automate. |
| dynamic content in Power Automate | Learn how to add dynamic content in Power Automate. |
| Rest API in Power Automate | This Power Automate tutorial explains how to use Rest API in Power Automate. |
| Create an HTML Table in Power Automate | This Power Automate tutorial explains how to create an HTML table in Power Automate. |
| Create an HTML Table from an Array in Power Automate | This Power Automate tutorial explains how to create an HTML table from an array. |
| Create an HTML Table from Excel in Power Automate | Learn how to create an HTML table from Excel in Power Automate. |
| Power Automate formatdatetime | Learn how to use formatdatetime() in Power Automate. |
| Apply Filter Between Dates in Power Automate | Learn how to apply filter between dates in Power Automate. |
| Power Automate Exception handling using Try Catch Block | Learn how to do exception handling using Try Catch Block in Power Automate. |
| Convert Decimal to Number in Power Automate | Learn how to convert a decimal to a number in Power Automate. |
| Power Automate format number as currency | Learn how to format a number as currency in Power Automate. |
| Concatenate String in Power Automate | Learn how to concatenate strings in Power Automate using concat() method. |
| Convert time zone in Power Automate | In 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 Automate | Learn how to convert a string to float in Power Automate. |
| Power Automate increment variable | Learn how to increment a variable in Power Automate. |
| adddays in Power Automate | We can use the adddays() in Power Automate to add days to a date. |
| do until in Power Automate | Learn how to use do until in Power Automate. |
| Power Automate email body formatting | Learn how to format email body in Power Automate. |
| Power Automate multiple conditions | This tutorial explains how to use multiple conditions in Power Automate. |
| Power Automate split string into array | This Power Automate tutorial explains how to split a string into an array in Power Automate. |
| Append a string to an array in Power Automate | This tutorial explains how to append a string to an array in Power Automate. |
| Power Automate remove characters from string | This tutorial explains how to remove characters from string in Power Automate. |
| Power Automate Filter Array | Learn how to filter array in Power Automate with a few examples. |
| Power Automate append to array variable | Learn how to append to array variable in Power Automate. |
| Create an array from an Excel table using Power Automate | This Power Automate tutorial explains how to create an array from an Excel table. |
| Copy Data from One Excel to Another Excel in Power Automate | This Power Automate tutorial explains how to copy data from one Excel to another Excel in Power Automate. |
| Insert XML data into Excel using Power Automate | Learn how to loop through XML data and insert it into Excel using Power Automate. |
| Convert XML to JSON using Power Automate | This tutorial explains how to convert XML to JSON using Power Automate. |
| Convert XML to Array in Power Automate | This tutorial explains how to convert XML to an array in Power Automate. |
| Convert XML to string in Power Automate | Learn how to convert XML to string in Power Automate. |
| Convert Array to String using Power Automate | This Power Automate tutorial explains how to convert an array to a string using Power Automate. |
| Convert True to Yes in Power Automate | Learn how to convert True to Yes in Power Automate. |
| Convert Float to Integer in Power Automate | This tutorial explains how to convert float to integer in Power Automate. |
| Format Numbers with Leading Zeros Using Power Automate | This tutorial explains how to format numbers with leading zeros using Power Automate. |
| Convert String to Date for SharePoint list using Power Automate | This tutorial explains how to Convert String to Date for SharePoint list using Power Automate. |
| Format Number to Percentage in Power Automate | Learn how to format a number to a percentage in Power Automate. |
| Format Numbers to Decimal Places Using Power Automate | This tutorial explains how to Format Numbers to Decimal Places Using Power Automate. |
| format number in Power Automate | Check how to use the formatnumber() function in Power Automate. |
| Convert Value to String in Power Automate | Check how to convert a value to a string in Power Automate. |
| Convert an Integer to an Array in Power Automate | This tutorial explains how to convert an integer to an array in Power Automate. |
| Power Automate wrong time zone | Learn how to fix the wrong time zone issue in Power Automate. |
| Convert a Number to Rounding UP or Down in Power Automate | This tutorial explains how to Convert a Number to Rounding UP or Down in Power Automate. |
| Format Number Thousand Separator in Power Automate | This Power Automate tutorial explains how to Format Number Thousand Separator in Power Automate? |
| Convert String to Decimal in Power Automate | Learn how to convert a string to a decimal number in Power Automate. |
| Convert String to Object in Power Automate | This tutorial explains how to convert string to object in Power Automate. |
| Convert a String to an Array in Power Automate | Learn how to convert a string to an array in Power Automate. |
| Convert String to Integer in Power Automate | This tutorial explains how to convert string to integer in Power Automate. |
| Convert String to Float in Power Automate | This 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.
| Examples | Descriptions |
|---|---|
| Expense Reimbursement and Approval using Power Automate | Download and use a Power Automate flow on “Expense Reimbursement and Approval using Power Automate”. |
| Leave Request Approval Flow using Power Automate | This is a leave request approval for using Microsoft Power Automate; check out the complete tutorial. |
| Upload PowerApps Attachments to SharePoint | This tutorial explains how to upload Power Apps attachments to the SharePoint document library. |
| Power Automate Shared Mailbox | Learn how to automate “when a new email arrives in a shared mailbox in Power Automate”. |
| Create PDF in Power Automate | Learn how to create a PDF in Power Automate. |
| Power Automate Copy Files | This tutorial explains how to copy files from one folder to another using Power Automate. |
| Power Automate Copy Folders | Learn how to copy folders using Power Automate, including copy folders and subfolders. |
| Create a task in Microsoft Planner using Power Automate | By 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 Examples | Learn how to use parallel branch in Power Automate with examples. |
| Power Automate OData filter query with examples | Learn with examples how to use odata filter query in Power Automate. |
| Get Dataverse List Rows Count Using Power Automate | This tutorial explains how to get Dataverse list rows count using Power Automate. |
| Get Row by ID From Dataverse Table | Learn how to get row by id from Dataverse table in Power Automate. |
| Detect Text in Dataverse Using AI Builder | Learn how to detect text in Dataverse using AI Builder in Power Automate. |
| Add a new row dataverse using Power Automate | Learn how to add a new row in Dataverse using Power Automate. |
| Get Dataverse Created by in Power Automate | Learn how to get Dataverse created by in Power Automate. |
| Update a Row in Dataverse Using Power Automate | Learn how to update a row in Dataverse using Power Automate. |
| Save Microsoft Forms Responses and Attachments to SharePoint Lists using Power Automate | This Power Automate tutorial explains how to save Microsoft Forms responses and attachments to SharePoint lists using Power Automate. |
| Add Rows to Excel in Power Automate | This Power Automate tutorial explains how to add rows to Excel. |
| Merge PDF files in Power Automate | This Power Automate tutorial explains how to merge PDF files in Power Automate. |
| Power Automate delete emails older than | Here is an example of deleting emails older than in Power Automate. |
| Power Automate replace text in word document | This Power Automate tutorial explains how to replace text in a Word document. |
| Create a Word Document from HTML using Power Automate | Learn how to create a Word document from HTML using Power Automate. |
| Send an email with options in Power Automate | Learn how to send an email with options in Power Automate. |
| Power Automate send excel file in email | Learn how to send an Excel file by email using Power Automate. |
| When a New Email Arrives Subject Filter in Power Automate | Learn 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.
| Tutorials | Description |
|---|---|
| Create a teams meeting using Power Automate | We 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:
| Tutorials | Description |
|---|---|
| Extract Data from Word Documents to Excel using Power Automate Desktop | This tutorial explains how to extract data from Word documents to Excel using Power Automate Desktop. |
| List variables in Power Automate Desktop | Check out the list of variables in Power Automate Desktop. |
| Data table in Power Automate Desktop | Learn how to work with a data table in Power Automate Desktop. |
| Loop through Excel rows in Power Automate Desktop | This tutorial explains how to loop through Excel rows in Power Automate Desktop. |
| Extract substring from text using Power Automate Desktop | Learn how to extract a substring from text using Power Automate Desktop. |
| Power Automate Desktop Mathematical Operations | Check out various Mathematical operations using Power Automate Desktop. |
| Concatenate Strings in Power Automate desktop | This Power Automate tutorial explains how to concatenate strings. |
| Loop actions in Power Automate Desktop | Check out various loop actions in Power Automate Desktop. |
| Get an item from a SharePoint list using Power Automate Desktop | Learn how to get an item from a SharePoint list using Power Automate Desktop. |
| Merge PDF files in Power Automate Desktop | Check out how to merge PDF files in Power Automate Desktop |
| Create File in SharePoint using Power Automate Desktop | This tutorial explains how to create a file in SharePoint using Power Automate Desktop. |
| Convert Data Table Columns to List in Power Automate Desktop | This tutorial explains how to convert data table columns to a list in Power Automate Desktop. |
| Get items from SharePoint List using Power Automate Desktop | Learn how to get items from a SharePoint list using Power Automate Desktop. |
| Create and Delete an Item from a SharePoint List using Power Automate Desktop | This 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 Desktop | Learn how to update items in a SharePoint list using Power Automate. |
| Power Automate Desktop SharePoint Get items Filter Query | Learn 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.
| Errors | Descriptions |
|---|---|
| The execution of template action ‘Switch’ failed: The result of the evaluation of ‘scope’ action expression ‘@triggerBody()?[‘ApprovalStatus’] is not valid | This 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 Automate | This tutorial explains how to fix the error “Invalid Connection. Please Choose a Connection Power Automate”. |
| attempted to perform an unauthorized operation. power automate error | Learn 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 Automate | Learn how to remove unwanted properties from an object using Power Automate. |
| ‘The user does not exist or is not unique’ error in Power Automate | Learn 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 objects | Learn 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 error | Learn 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 Automate | This 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 specified | This 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 Automate | Learn 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.