Learn how to automate your business processes in your organization using Microsoft Power Automate tutorials.
While managing automation processes for an internal business system, I set up more than 200 Power Automate flows, each responsible for handling different parts of operations, such as approvals, notifications, and data updates. Everything worked great until one day, a few important flows failed silently. I didn’t even realise it until someone from another department … read more…
When I was working on a Document Management System, I noticed that every time a column was updated in a SharePoint document library, it automatically created a new version of the item. In my case, this wasn’t necessary because I was only updating metadata fields and didn’t want to increase the version count. After some … read more…
Yesterday, one of my subscribers reached out with an interesting requirement: they needed to create a SharePoint list and its columns using Power Automate and have that list automatically show up in the SharePoint site’s left-hand navigation (the quick launch menu). In this tutorial, I will tell you how to add a SharePoint list link … read more…
When we create flows in Power Automate, it’s common to receive text that isn’t perfectly formatted, with extra spaces, unwanted characters, or parts of a string you don’t need. Cleaning the text before saving it to SharePoint, sending an email, or creating a file is essential. In this tutorial, I will tell you how to … read more…
In Power Automate, you may sometimes need to clean or modify text before using it in your flow. Maybe you want to remove extra spaces, change a word, or replace special characters in a file name. In these cases, replace() help us. In this tutorial, I will explain how to use the Replace() function in … read more…
One of my colleagues recently asked for help with a tricky scenario. He runs a webinar where participants register at different times, and every time a new participant signs up, he wants to send them the meeting link. However, he doesn’t want Outlook to continue emailing all the previously registered attendees repeatedly. Usually, if you … read more…
While working on an IT Help Desk product, we needed to get all items from a SharePoint list using Power Automate. The list has more than 10,000 items, and retrieving all of them takes around 38 seconds. To improve the speed, we decided to get only the items created between specific dates. In this tutorial, … read more…
I was working on a document management system for a client where they used the Term Store in SharePoint to manage metadata. The Term Store is useful for keeping tags consistent, but sometimes not everyone has permission to add new terms. This created a problem when users wanted to add missing terms. After some research, … read more…
Last week, one of my customers purchased my small flow “Create List With Different Types of Columns using Power Automate.” After using it, they came back with an additional request: they wanted to automatically add an indexed column whenever a new column is created in SharePoint. If you want to explore more, you can download … read more…
I received a client requirement to retrieve data from a SharePoint list into Power Apps using a Power Automate flow. Although it is possible to fetch SharePoint list data directly in Power Apps, there are scenarios where using a flow is a more effective approach. For example, handling delegation issues when working with large datasets … read more…
While working on a document management system, I set up a Power Automate flow to generate a custom ID for every file that gets uploaded. The ID creation worked exactly as expected, but I encountered an issue when attempting to create a document from a template. Power Automate showed an error: In this tutorial, I’ll … read more…
Recently, one of my clients asked if it’s possible to automatically extract key information from an invoice, such as Name, Amount, Item Description, Date, and Summary, as soon as the invoice file is uploaded to a SharePoint Document Library. After exploring a few options, I found a simple and effective solution using Power Automate and … read more…
In Power Automate, there are many situations where you need to split a string and retrieve a specific part, such as the first, last, or any specific n-th value. For example, suppose you have a string like this: “123 Main Street, Springfield, IL, 62704.” Now, you want to extract only the city (Springfield) or the … read more…
While working with Power Automate for one of my clients, there are many situations where you might need to split a string into an array. For example, you might receive a list of values separated by commas, spaces, or even line breaks. In such cases, you can use the split() function to break the string … 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