Have you ever needed to update just one field in a SharePoint list based on a specific condition? I recently had to handle this in an Employee Records SharePoint list. The task was straightforward: when the Employee Status needed to change to “Inactive,” it should happen only when the End of Contract date was updated—without … Read more >>>
While working on automation scenarios in Power Automate, you might often need to retrieve data from a SharePoint list or library using the Get items action. However, you might notice that this action only fetches up to 100 items by default. What if your list has thousands of items? Don’t worry—Power Automate has built-in options … Read more >>>
When working with SharePoint lists, duplicate records can become an issue, especially when managing multiple entries like support tickets, employee onboarding, or customer information. These duplicates can lead to confusion and errors in your workflows. To avoid this, we must check if an item exists before creating a new one. In this tutorial, I’ll show … Read more >>>
In this tutorial, I will show you how to create dynamic hyperlinks in Power Automate to make your workflows more efficient and interactive. We’ll cover two examples: first, sending an email notification with a hyperlink to a SharePoint list item, and second, generating a dynamic link to a blog post based on its title. Create … Read more >>>
While working on an employee leave application process, I encountered a situation where I needed to send emails to multiple recipients based on data stored in a SharePoint list. Whether it was notifying HR, the employee’s manager, or other team members, the challenge was to automate the process efficiently. After researching, I discovered various ways … Read more >>>
One of my team members recently asked If you could add this value to a string in Power Automate. I replied, Yes, first you need to initialize the variable and then use the Set variable action. But they clarified, No, I want to add value at different times. If I use the Set variable action, … Read more >>>
One of my clients recently asked me how to convert HTML to PDF in Power Automate. Initially, I suggested using the Convert – HTML to PDF action from Encodian, a premium connector. However, they mentioned that they couldn’t use premium connectors. After some research, I found an alternative approach that doesn’t require any premium connectors! … Read more >>>
While working on automating Excel data management, I faced the challenge of deleting all rows in an Excel table without affecting the table’s structure. After researching various approaches, I discovered two effective methods using Power Automate. In this tutorial, I will show you how to delete all rows in Excel using Power Automate. We’ll cover … Read more >>>
Recently, during a product development, I faced a scenario where I had to combine data from multiple sources into a single array. In Power Automate, merging arrays is frequently needed when dealing with dynamic content like SharePoint lists, Excel rows, or API responses. Whether you’re aggregating data for reports, combining multiple lists, or preparing JSON … Read more >>>
Last week, I worked on a Power Automate scenario where a client needed to extract data from a SharePoint list and organize it into an Excel file for reporting purposes. The goal was to create a fully automated process that retrieves all items from the list, generates an Excel workbook, and populates it with the … Read more >>>
Download a fully functional Power Apps Canvas App (with Power Automate): User Registration App
Download 135 Pages FREE PDF on Microsoft Power Platform Tutorial. Learn Now…