Bijay Kumar 
Recently, while working with our client on the Project Management portal, I was assigned to validate the SharePoint date and time column so that weekends are selected instead of weekdays. This can be achieved by using the WEEKDAY() function in SharePoint. In this tutorial, I will explain the functionality and syntax of the SharePoint WEEKDAY() … Read more >>>
While developing a client requirement, I struggled to create items manually in a SharePoint list because I wanted large data sets. After researching, I found that we can create a single or multiple items in a SharePoint list using Power Automate. In this article, I will tell you how to create SharePoint list items using … Read more >>>
A few days ago, I was required to schedule a meeting with a client in a time zone different from ours using Power Automate flow. This seems a bit confusing to me. After some research, I discovered that we can convert time zones according to our needs using Power Automate Convert time zone action. I … Read more >>>
While working on an Employee Leave Request App application, I had to delete the empty folders in the document library using Power Automate. Unfortunately, the Delete folder action is not present in Power Automate. After some research, I found two ways to delete a folder in the SharePoint document library using Power Automate. Such as: In this … Read more >>>
While working on Power Automate flows, you can use the If() expression to validate the condition in a single line instead of taking multiple conditional branches. In this tutorial, I will describe how to use the Power Automate If contains expressions with a few examples. Power Automate If Contains Text I will show you how … Read more >>>
When working with files in Power Automate, sometimes the trigger or previous actions only provide metadata like the file’s full path, display name, or unique identifier but not the actual content. However, we need the file content to process or use the file further (such as sending it in an email or saving it to … Read more >>>
Last week, while working with a client, I got an interesting requirement: they needed to check if a string contained any numbers in Power Automate. At first, it seemed like a simple task, but as I explored different approaches, I found two interesting ways to achieve this. In this tutorial, I will tell you how … Read more >>>
A few days before, I was required to send an email containing project names and serial numbers. To achieve this, I used the range() function in Power Automate, which generates an array of integers. In this tutorial, I will explain how to provide a sequential serial number for a list of SharePoint items using the … Read more >>>
I ran into an unexpected issue while working on a Power Automate flow. I needed to compare two dates: today’s date and a date five days in the future. I used the formatDateTime() function to format the dates, but when I applied the condition to check if today’s date was greater than today + 5 … Read more >>>
While working on a project named Employee Satisfaction Survey, I encountered a requirement to replace commas with new lines in Power Automate. Initially, I thought this could be easily achieved using the replace() function, which follows this format: However, when I tried using \n, char(10), or even HTML <br> tags as the newText Value, they … Read more >>>
Join our upcoming live sessions and learn how to build a real SharePoint Permission Checker Agent using Copilot Studio.
📅 1st July 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…