Learn how to automate your business processes in your organization using Microsoft Power Automate tutorials.
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…
Recently, a client who hosts many corporate events each year asked me for help with a special request. They wanted to create a QR code for every event participant automatically. When someone scans the code, it should quickly display their basic information, such as their name, registration ID, and event details, to speed up the … read more…
When you create flows in Power Automate for one of my clients, many processes require decisions based on multiple conditions. For example, you might want to send an email only if a document is approved and its value exceeds $ 50,000 or trigger a different action if an item’s status is either “Pending” or “In … read more…
In this tutorial, I will describe how to use the Do Until action in Power Automate and how to configure its key parameters, such as Count and Timeout. While working on a Leave Management App approval process, I needed to wait until multiple conditions were met, such as the leave request being marked as approved … read more…
While I was working on a Power Automate flow for our client that uploads policy documents from SharePoint to a Copilot Studio Agent’s Knowledge base, everything worked well until I uploaded a file that had spaces in the name, like: As soon as I did that, I received the following error in my flow: This … read more…
Our HR team regularly updates policy documents, including leave policies, codes of conduct, and remote work guidelines, and stores them in a SharePoint library. We use a chatbot called Policy Assistant Bot, built in Copilot Studio, to answer employee questions based on these documents. However, every time we update a file, we must manually upload … read more…
Do you want to add trigger conditions in Power Automate? In this Power Automate tutorial, I will explain everything about “Power Automate trigger conditions“, Power Automate trigger conditions syntax, and various Power Automate trigger conditions examples, etc. Trigger Conditions in Power Automate are like rules that you set for your automated tasks. They make sure … read more…
When working with SharePoint lists in Power Automate, a common task is to check whether a Person or Group field is empty. Maybe you have an approval process that shouldn’t start until someone is assigned to the task, or you’re sending an email only if a specific person is assigned. Whatever the case, Power Automate … 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