Bijay Kumar 
Recently, I got a requirement to update SharePoint list items from an Excel file using Power Automate. The client had an Excel file and wanted to update these records in a SharePoint Online list. In this tutorial, I will explain how to update SharePoint list items from an Excel spreadsheet using Power Automate. Update SharePoint … Read more >>>
One of my clients asked us to update items in a data table using Power Automate Desktop. It is easy to update the value of a single item. Still, when dealing with multiple items in a data table, there is no direct way to retrieve the row index of a data table that updates the … Read more >>>
One of my clients requested to extract data from a web part to an Excel file using Power Automate Desktop. In this tutorial, I will explain how to extract data from any web page using Power Automate Desktop with two different examples. Extract Data from a Web Page using Power Automate Desktop I wanted to … Read more >>>
You can insert a row or a column in an Excel sheet that is present in your local system by using Power Automate desktop. In this tutorial, I will cover the way to insert a new column as well as a new row in an Excel worksheet using Power Automate desktop. Insert Column to Excel … Read more >>>
Recently, I worked on a SharePoint project where I needed to split and replace the text string values present in a SharePoint list column. We can achieve this using a SharePoint calculated column. This SharePoint tutorial explains how to split strings using a SharePoint calculated column with different text functions, such as: I will also show … Read more >>>
Are you trying to create a hyperlink in SharePoint? Maybe using a SharePoint calculated column. Microsoft officially does not support and blocks the execution of HTML markup in SharePoint calculated fields. Alternatively, you can use JSON Formatting to make the hyperlink clickable as a solution for this requirement. In this tutorial, I will guide you … Read more >>>
Over the past few months, we have developed several helpful apps in Power Apps, including Leave Management, Travel Requests, and User Login. I wanted to display all of them in one place, and cleanly. So, I created a gallery that scrolls automatically and displays each app one by one in a Power Apps canvas app. … Read more >>>
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 >>>
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 >>>
Join this free live session and learn how to build a Quiz application using SharePoint Framework (SPFx).
📅 2nd June 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…