Bijay Kumar 
I was recently working on a project where I had to create a custom ID column in a SharePoint list with a specific format like yyyyMMdd-[ID]. But we can’t directly change or customize the default ID column of a SharePoint list. After researching, I figured out a way to customize the ID column of a … Read more >>>
In SharePoint, calculated columns allow you to perform mathematical operations and formatting on data. When you need to round up numbers to specific decimal places, SharePoint provides the ROUNDUP function. In this tutorial, I will explain how to use the ROUNDUP() function to round up values to decimal places using a SharePoint calculated column. For … Read more >>>
As a SharePoint developer, I have frequently been required to work with calculated columns, particularly those involving date fields. In this tutorial, I will provide various examples related to SharePoint calculated column dates. All these calculated examples are related to SharePoint date column types. If you are new to calculated columns in SharePoint Online, you … Read more >>>
Calculated columns in SharePoint allow you to generate values automatically based on other columns in your list. As a SharePoint developer, I have created calculated columns in SharePoint lists and libraries many times when we want to display column values based on formulas. The formulas for SharePoint calculated columns are based on Microsoft Excel functions … Read more >>>
I was recently working on string manipulations in Power Automate, where we wanted to replace apostrophes with double quotes. You can do it easily. In this tutorial, I will show you how to replace an apostrophe character in a string in Power Automate. Additionally, I will cover the following examples. Replace Apostrophe in String Variable … Read more >>>
While working on a client’s requirement, I was assigned a task to extract the file name from the file path that is stored locally on the desktop. This is similar to getting a substring from a string in Power Automate Desktop. Power Automate desktop provides a set of text functions that enable you to perform … Read more >>>
A few days ago, I was working on a Power Platform project that required me to extract data from an Excel file based on a specific condition using Power Automate Desktop. You can achieve this using PAD. In this tutorial, I will explain how to extract the data from an Excel Worksheet using Power Automate … Read more >>>
Most of us commonly work with data on a daily basis, where the data is arranged in columns. One of the everyday tasks is to create data tables to store data in Power Automate Desktop. In this tutorial, first, I will show you how to create a data table in Power Automate desktop flow, along … Read more >>>
Recently, I was working on a project where I needed to schedule Power Automate desktop flows that run on a daily basis. The issue is… There is no built-in way to schedule the Power Automate desktop flows. To schedule the desktop flow, you have to connect a Schedule cloud flow in Power Automate to the … Read more >>>
Recently, while working on a SharePoint project for a client, we had one Employee ID column in a SharePoint list containing values such as 5, 45, 254, etc. However, the client wanted the Employee ID to be 0005, 0045, 0234, etc., in this format. This is easily achieved by using a SharePoint calculated column to … 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…