Learn how to automate your business processes in your organization using Microsoft Power Automate tutorials.
Do you know how to check if a given input is an integer in Power Automate? Imagine you are working in a flow where a user inputs or SharePoint list values, and you need to validate whether a string contains a whole number before proceeding to the next steps. If the value is not a … read more…
Suppose you are in the middle of creating a Power Automate flow, and you need to check whether an array contains a specific value. Sounds simple, right? But looking into it, you find multiple ways to achieve this. After some research and testing, I found three effective methods to check if an array contains a … read more…
Last week, I worked for a client who needed to process API responses in Power Automate. The challenge? Sometimes, the API would return an empty body, and the flow required to handle it gracefully without breaking. If you have ever encountered this issue, you know how frustrating it can be when your flow fails because … read more…
A few days ago, I worked with a client who needed to check if a field was blank in Power Automate. The requirement was simple before proceeding with certain actions. They wanted to ensure that a specific field wasn’t empty. If it was blank, the flow should take a different path. I will explain how … read more…
Have you ever needed to remind someone about a task deadline or clean up old files without doing it manually? With Power Automate, you can easily automate these tasks. In this tutorial, we will explore how to use dates in Power Automate to automate reminders and file management. Whether you need to check if a … read more…
Last week, while working on creating a SharePoint list and column from Excel flow, I needed to create a lookup column using Power Automate dynamically. At first, it seemed tricky since there’s no direct action for creating lookup columns. However, after some research and testing, I found a way to make it work using the Send an HTTP … read more…
A few days ago, while working on a client project, I needed to create multiple columns in a SharePoint list using Power Automate. Everything went smoothly until I realized the Include Time option was enabled by default when I made a Date and Time column. However, the client specifically wanted only the date without the time. Now, … read more…
Have you noticed that the Title column is mandatory by default when you create a SharePoint list using Power Automate? If you try to set it as non-required by directly adding “Required”: false in the HTTP request while creating the list, you’ll likely run into an error because there’s no direct property for that! But … read more…
A few weeks ago, I developed a Power Automate flow for a client that used SharePoint lists as data sources. There were ten lists, each with more than 30 fields. Due to permission issues, the client had to create all the lists and columns manually. To make this easier, I needed to fetch each SharePoint … read more…
In our leave management application, I needed to calculate leave days while ensuring weekends were excluded from the total count. Since weekends shouldn’t be considered leave days, I had to find a way to check if a given date falls on a Saturday or Sunday. After some research, I found an efficient way to identify … read more…
While working on a Create SharePoint Online List and Columns from Excel flow in Power Automate, I needed to create a SharePoint list with a specific internal name. Initially, I attempted to specify the InternalName while creating the list, but I encountered the following error: After checking the SharePoint list properties, I found that there … read more…
I encountered an interesting requirement last week when working with a client. They wanted to automate a process based on the day of the week in Power Automate. Precisely, they needed to trigger different actions depending on whether it was a weekday or a weekend. Luckily, Power Automate provides built-in functions that make it easy … read more…
While working with Power Automate, you often need to check if a column in a SharePoint list equals a specific value before taking further actions. For example, you might want to send an email notification when the Status column in a SharePoint list equals Approved. In this tutorial, I will explain different ways to check … read more…
Recently, while working on a Send Birthday Wishes flow for a client, I needed to retrieve employee birthdays from Office 365 and check if today was someone’s birthday. However, when I ran the flow, it didn’t match anyone’s birthday because none of the employees had a birthday that day. That’s when I thought, why not … read more…
This free guide walks you through the 30 most-used Power Apps functions with real business examples, exact syntax, and results you can see.
Download a fully functional Power Apps Canvas App (with Power Automate): User Registration App