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…
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…
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…
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 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…
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…
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…
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…
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 Share
