Learn how to automate your business processes in your organization using Microsoft Power Automate tutorials.
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…
I encountered an interesting requirement while working with a client a few days ago. They wanted an automated birthday reminder system in Power Automate. The goal was simple: After receiving this requirement, I explored different ways to implement it. I found two approaches to getting employees’ birth dates: Both methods achieve the same goal of … read more…
Have you ever needed to check if an attachment exists before taking action in Power Automate? I faced this requirement in an Expense Management System product, where I had to ensure receipts were attached before processing expense claims. In this tutorial, I will show you how to check if attachment exists using Power Automate in three … read more…
A few weeks ago, I encountered an interesting scenario while working with strings in Power Automate. That’s when I thought sharing how to handle different string conditions in Power Automate would be helpful. In this article, we’ll explore Power Automate Condition If String, such as checking if a string is empty, verifying if it contains … read more…
In this tutorial, I will explain how to use the length() function in Power Automate to check the number of characters in a string or the number of items in an array. Additionally, I will cover scenarios such as checking if a string length is greater than a certain value before triggering an action, handling … read more…
One of my subscribers reached out a few days ago with an interesting query. They were working on a Power Automate flow and needed to check if the Body of a response or action was empty before proceeding. This is a common scenario, especially when dealing with APIs and HTTP requests where data may or … read more…
A few weeks ago, they had a specific requirement while working on a Project Status Tracker for a client. Whenever the Status column changed in a SharePoint list, they wanted to send an email notification. But they needed to know the previous status before the change. After researching, we could achieve this using the Get changes for an … read more…
While working on a Create List with Different Types of Columns flow in Power Automate, I encountered a situation where I needed to check if a SharePoint list with a specific display name already existed. If the list doesn’t exist, the flow should create one. But if it already exists, the flow should send a notification instead … read more…
Enroll now and get access to all 9 academy courses at no extra cost.
Secure your seat before the batch fills up.
Get the live training plus the complete SPGuides.Academy learning library.
This free guide walks you through the 30 most-used Power Apps functions with real business examples, exact syntax, and results you can see.
Learn how to build an invoice management system using SharePoint integration and a repeating table.
📅 2nd September 2026 – 10:00 AM EST | 7:30 PM IST
Download a fully functional Power Apps Canvas App (with Power Automate): User Registration App