If you are working with SharePoint calculated columns, this tutorial will be very helpful. In this tutorial, I will explain how to use an if statement in a SharePoint list calculated column. I will show you seven useful examples related to SharePoint calculated column if statement, including SharePoint calculated column if contains text. The IF … Read more >>>
Recently, while working on one of the client’s requirements, I encountered a problem adding the lookup column value to the JSON Code while formatting the SharePoint list. So, I thought I would share my experience in this blog post. In this tutorial, I will explain how to add a lookup value to the SharePoint column … Read more >>>
You can use the concatenate() function to combine two or more text strings or characters in a SharePoint calculated column. This is useful when you want to join two list/library columns in SharePoint. Syntax: Parameters: Output Returned: Additional Notes: SharePoint Calculated Column Concatenate() Examples Let’s see some examples of the concatenate() function in a SharePoint calculated … Read more >>>
Recently, while working on a Project Management solution, I received a requirement from one of our clients based in Canada. They wanted to customize the SharePoint list form into a two column layout using JSON code. I thought I would share my experience on configuring a custom SharePoint list form in this tutorial. In this … Read more >>>
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 >>>
Recently, I worked on a SharePoint project where I needed to calculate the length of a SharePoint list column. We can achieve this using a SharePoint calculated column. Basically, the LEN() function in SharePoint can be used to calculate the length of a string. This is useful when you want to get the total number … 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 >>>
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…