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 >>>
When working in Power Automate, one of my team members recently asked, “How can we convert a CSV file into an XML format automatically?” This got me thinking about how common this requirement is, especially when working with integrations between systems or applications that rely on XML data structures. In this tutorial, I will tell … Read more >>>
I worked with a client who needed to process a large amount of data stored in XML format and convert it into a more user-friendly format like CSV for reporting and analysis. They wanted an automated solution that didn’t require manual intervention or third-party tools. In this tutorial, I will tell you how to convert … Read more >>>
In my recent task, I encountered an interesting scenario where a user wanted to set up an automated email reminder for tasks due in the current month. The idea was to send a single, consolidated email to each assigned person, listing all their tasks with expiry dates within the month. In this tutorial, I will … Read more >>>
When working in Power Automate, one of my team members recently asked, “How can I automatically create a sharing link for a file or folder in SharePoint?” This is a common need when teams want to share files easily without creating links manually every time. Luckily, Power Automate has a simple solution! We can use … Read more >>>
Automatically filling in the details when logging into an application frequently can be useful for quick access. This is possible by using the Remember Me feature/option during Power Apps login. In this Power Apps article, I will show you how to create a login page using SharePoint and the Remember Me option, step by step. Look … Read more >>>
While working on Power Automate, one of my clients needed a solution to check if a specific column exists in a SharePoint list. This was important because the workflow required handling different actions depending on whether the column was present. In this tutorial, I will show you how to check if a field exists in … Read more >>>
Learn how to automatically create a SharePoint Online list and all its columns from an Excel file using Power Automate—without using any Premium connectors.
📅 4th AUG 2026 – 10:00 AM EST | 7:30 PM IST
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…