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 >>>
Many people use SharePoint lists to store important data, but sometimes it can be challenging to find exactly what you need when the list is very large, even when using Power Apps as well. This way, you can quickly see only the information that matters most to you, without having to scroll through everything. In … 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 >>>
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…