Power Automate Tutorials

Welcome! If you’re looking to learn about Microsoft Power Automate and how to use it effectively, then you’re in the right place. We offer comprehensive tutorials that take you through every step of the process, from understanding what Power Automate is, to getting your first automated processes up and running. Let’s dive in!

Introduction to Microsoft Power Automate

Microsoft Power Automate, previously known as Microsoft Flow, is a service that helps you create automated workflows between your favorite apps and services to synchronize files, get notifications, collect data, and more. It’s a powerful tool that allows you to automate business processes, reducing manual effort and improving efficiency and accuracy.

Advantages of Using Power Automate

Power Automate offers many advantages, including:

  • Automation: Power Automate allows you to automate routine tasks, which saves time and reduces the likelihood of human error.
  • Integration: Power Automate can connect to various services and applications, including Office 365, SharePoint, SQL Server, and many more, making it incredibly flexible.
  • Efficiency: By automating processes, your business can function more smoothly and efficiently, leading to increased productivity.
  • No Coding: The visual interface of Power Automate allows you to create workflows without writing a single line of code.
  • Control: Power Automate includes features for managing and controlling flows, which help ensure processes work correctly and securely.

Getting Started with Power Automate

Before creating your flows, you’ll need to sign up for Power Automate.

  1. Sign up for a Power Automate account – Go to the Power Automate website (https://powerautomate.microsoft.com) and sign up. If you already have a Microsoft 365 account, you can use that to sign in.
  2. Explore the Power Automate interface – The main elements of the interface are the left-hand navigation pane, the action bar, and the main content area. Familiarize yourself with these areas to understand where to find different features and options.

Power Automate Tutorials for Beginners

If you are a beginner to Microsoft Power Automate, check out the beginner’s tutorials on Power Automate.

TutorialsDescriptions
How to Use Power Automate Prebuilt TemplatesCheck out the various predefined templates available in Power Automate and their uses with various examples.
Create an Instant Cloud Flow in Power AutomateAs a beginner to Power Automate, you should know how to create an instant cloud flow in Power Automate.
Create a Scheduled Cloud Flow in Power AutomateThis tutorial explains how to create a scheduled cloud flow in Power Automate.
Power Automate send an email (v2)This tutorial explains how to use the Power Automate send an email (V2) flow action to send emails in Power Automate.
Build a Parallel Approval in Power AutomateThis Power Automate tutorial explains how to build a parallel approval in Power Automate.
Send Email Using If Condition in Power AutomateThis Power Automate tutorial explains how to send an email using if condition in Power Automate.
Initialize A Variable in Power AutomateFrom this tutorial, you will learn how to initialize a variable in Power Automate.
Initialize Array Variable in Power AutomateLearn how to initialize an array variable in Power Automate.
How to Initialize a Date Variable in Power AutomateLearn how to initialize a date variable in Power Automate.
Initialize Integer Variable in Power AutomateThis Power Automate tutorial explains how to Initialize an Integer Variable in Power Automate.
Initialize String Variable in Power AutomateLearn how to initialize a string variable in Power Automate.
Initialize Float Variable in Power AutomateThis tutorial explains how to initialize a float variable in Power Automate.
Initialize Boolean Variable in Power AutomateThis Power Automate tutorial explains how to initialize a boolean variable in Power Automate.
Initialize Object Variable in Power AutomateLearn how to initialize an object variable in Power Automate.
Set Variable Based on Condition in Power AutomateThis Power Automate tutorial explains how to set a variable based on the condition in Power Automate.
How to Use Power Automate Delay ActionThis Power Apps tutorial explains how to use delay action in Power Automate.
Convert UTC to Local Time Zone in Power AutomateCheck out this Power Automate post to learn how to convert UTC to local time zone in Power Automate.

Power Automate advanced tutorials

Here is the list of Power Automate advanced tutorials. All these tutorials are explained practically with examples and screenshots.

TutorialsDescriptions
Send Birthday Emails from Excel using Power AutomateThis Power Automate tutorial explains how to send birthday emails from Excel using Power Automate.
Update SharePoint Person Field in Power AutomateLearn how to update the SharePoint person field in Power Automate.
Update Lookup Field in SharePoint List in Power AutomateLearn how to update lookup field in SharePoint list in Power Automate.
Power Automate odata date filter last 30 days examplesLearn how to filter the last 30 days’ record using the oData filter in Power Automate.
Send an Email Notification When an Item is Deleted via Power AutomateLearn how to send an email notification when an item is deleted via Power Automate.
Convert String to Integer in Power AutomateCheck out this Power Automate tutorial to learn how to convert a string to an integer in Power Automate.
Get Current Date in Power AutomateLearn how to get the current date in Power Automate.
How to Get Current Year in Power Automate?You will get to know how to get the current year in Power Automate and also how to get the previous and next year in Power Automate.
Get Current and Previous Month in Power AutomateLearn how to get the current and previous month using Power Automate with various examples.
Get start and end of month in Power AutomateThis tutorial explains how to get start and end of month in Power Automate.
Get current user email address in Power AutomateThis Power Automate tutorial explains how to get current user email address in Power Automate.
Update SharePoint List Date and Time Column in Power AutomateLearn how to update the SharePoint list date and time column in Power Automate.
Update SharePoint Choice Column in Power AutomateThis tutorial explains how to update the SharePoint list choice column in Power Automate.
Power Automate Get items Filter QueryLearn with an example about the Power Automate get items filter query.
Power Automate Get Items Filter Query DateLearn how to use Power Automate Get Items filter query date with examples.
Power Automate OData Filter Query Yes/No (Boolean) ColumnThis Power Automate tutorial explains how to use the Power Automate OData filter query yes/no column with examples.
Power Automate Odata Filter Query StartswithLearn how to use Power Automate Odata filter query Startswith with examples.
Power Automate get items filter query equals nullThis tutorial helps to learn the Power Automate get items filter query equals null and the Power Automate get items filter query not equal null.
Get All SharePoint List Items in Power AutomateLearn how to get all SharePoint list items using Power Automate.
Power Automate get SharePoint list items countThis tutorial explains everything about Power Automate get sharepoint list items count.
Power Automate Get items Order ByLearn with an example about Power Automate Get Items order by.
Create HTML Table in Power AutomateThis Power Automate tutorial explains how to create an HTML table in Power Automate.
Create an HTML Table from Microsoft Form in Power AutomateLearn how to create an HTML table from a Microsoft form using Power Automate.
Format HTML Table in Power AutomateCheck out this tutorial to learn how to format an HTML table in Power Automate.
Import CSV to SharePoint List in Power AutomateThis Power Automate tutorial explains how to import a CSV file to a SharePoint list in Power Automate.
Get First Item ID from SharePoint List in Power AutomateLearn how to get the first item ID from a SharePoint list using Power Automate.
Get Last Item ID from SharePoint List in Power AutomateThis Power Automate tutorial explains how to get the last SharePoint list item id in Power Automate.
How to Use Switch Action in Power AutomateLearn how to use the Switch action in Power Automate.
Convert CSV to Array in Power AutomateLearn how to convert a CSV to an array 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 in Power Automate.
Convert CSV to Array in Power AutomateThis Power Automate article explains how to convert CSV to array.
Convert CSV to Excel in Power AutomateLearn how to convert CSV to Excel in Power Automate.

Power Automate Functions List

Here is the list of Power Automate functions and how to use these functions inside flows.

TutorialsDescriptions
Length Function in Power AutomateThis tutorial explains how to use the len() function in Power Automate
Power Automate startswith FunctionIn this Power Automate tutorial, I have explained how to use the Power Automate startsWith function with a few examples.
Power Automate LastindexOf() FunctionThis tutorial explains how to use the Power Automate lastindexof() function with examples.
Power Automate IndexOf() FunctionHere, you will learn about the Power Automate indexof() function with examples.
Power Automate toLower()You can use the toLower() function in Power Automate to convert a string to lowercase.
Power Automate Contains() FunctionThis tutorial explains using the contains() function in Power Automate.
Power Automate Chunk()This Power Automate tutorial explains using the Power Automate chunk() function.
Power Automate toUpper()Learn how to use the Power Automate toUpper() function with a few examples.
Power Automate substring()This tutorial helps how to use the substring() function in Power Automate.
Power Automate slice() FunctionThis Power Automate tutorial explains the slice() function with two examples.
Power Automate endsWith() FunctionThis tutorial explains how to work with the endsWith() function in Power Automate.
Power Automate formatNumber() FunctionThis Power Automate tutorial explains how to use the formatNumber() function in Power Automate with a few real examples.
Power Automate isFloat() FunctionThis tutorial explains how to use the isFloat() function in Power Automate.
Power Automate addDays() FunctionLearn how to use the addDays() function in Power Automate.
Power Automate addHours() FunctionLearn how to use the addHours() function in Power Automate.
Power Automate addMinutes()Learn how to use the addMinutes() function in Power Automate.
Power Automate getPastTime()Learn how to work with the getPastTime() function in Microsoft Power Automate.
Power Automate addToTime()Power Automate addToTime() function is designed to add specific time of units to a given timestamp.
Power Automate dayOfMonth()The dayOfMonth() function in Power Automate enables the extraction of the day of a month from a provided timestamp in a flow.
Power Automate dayOfWeek()Power Automate dayOfWeek() is useful to get and know the day of a week from the given time stamp in the form of an integer.
Power Automate dateDifference()Learn how to find the time difference between two timestamps by subtracting the start date from the end date in Power Automate.
Power Automate dayOfYear() FunctionLearn how to use the dayOfYear() function in Power Automate.
Power Automate getFutureTime() FunctionCheck out this article to learn how to use Power Automate’s getFutureTime() function.
Power Automate startOfDay() FunctionThis article helps you learn how to use the startOfDay() function in Power Automate.
Power Automate add() FunctionThis article helps you learn how to use the startOfDay() function in Power Automate.
Power Automate formatDateTime() FunctionThis tutorial assists you in knowing what is formatDateTime() and how to use it in Power Automate.
Power Automate startOfHour() FunctionLearn how to use the add() function in PowerAutomate with different examples.
Power Automate startOfMonth() FunctionPower Automate startOfMonth() function retrieves the exact start time of a month.
Power Automate convertFromUtc() FunctionMicrosoft Power Automate convertFromUtc() function will be useful to convert the UTC zone to the destination timezone.
Power Automate trim() FunctionPower Automate trim() Function is used to remove leading and trailing whitespaces from a text string.
Power Automate concat() FunctionCheck out various examples of how to use the concat function in Power Automate.
Power Automate utcNow() FunctionThe current date and time are provided in UTC format by the Power Automate utcNow() function.
Power Automate subtractFromTime() FunctionPower Automate subtractFromTime() function can subtract different time units—such as seconds, minutes, hours, days, weeks, months, or years—from a specified timestamp.
Power Automate first() FunctionCheck out this post to learn how to use the first() function in Power Automate.
Power Automate length() FunctionThis Power Automate post will assist you in how to work with the length function using a simple example.
Power Automate div() FunctionLearn what the div() function in Power Automate is and how to use the Power Automate div() function, with various examples.
Power Automate skip() FunctionCheck out how to use the skip() function in Power Automate with examples.

Power Automate Errors and Solutions

TutorialsDescriptions
the ‘inputs parameters’ of workflow operation ‘Send_an_email_(V2)’ of type ‘openapiconnection’ is not validHere is how to fix the error “the ‘inputs parameters’ of workflow operation ‘Send_an_email_(V2)’ of type ‘openapiconnection’ is not valid”.
Unable to process template language expressions in action inputs at line ‘0’ and column ‘0’ in Power AutomateLearn how to fix the error “Unable to process template language expressions in action inputs at line ‘0’ and column ‘0’ in Power Automate”.