Bijay Kumar 
When we create flows in Power Automate, it’s common to receive text that isn’t perfectly formatted, with extra spaces, unwanted characters, or parts of a string you don’t need. Cleaning the text before saving it to SharePoint, sending an email, or creating a file is essential. In this tutorial, I will tell you how to … read more…
In this article, I will explain how to create both a SharePoint list and a document library using the SharePoint Framework (SPFx) web part. To achieve this, we will use the SPHttp client and the web part we will create with No framework. Let’s get started! Create SharePoint List & Library Using SPFx Look at … read more…
When you add a Gallery in Power Apps, it automatically highlights the first item by default. That works in many cases, but it can be unclear if you’d prefer your app to start with nothing selected. Yes, the same thing happened to me as well. In my case, I always want to start with my … read more…
In Power Automate, you may sometimes need to clean or modify text before using it in your flow. Maybe you want to remove extra spaces, change a word, or replace special characters in a file name. In these cases, replace() help us. In this tutorial, I will explain how to use the Replace() function in … read more…
As a beginner in SharePoint Framework, you should know how to implement CRUD operations on a SharePoint list in SPFx. In this article, I will explain the steps to implement CRUD (Create, Read, Update, Delete) operations using the PnP JS library in an SPFx web part. Now, let’s get started! SharePoint Framework CRUD Operations Look … read more…
One of my colleagues recently asked for help with a tricky scenario. He runs a webinar where participants register at different times, and every time a new participant signs up, he wants to send them the meeting link. However, he doesn’t want Outlook to continue emailing all the previously registered attendees repeatedly. Usually, if you … read more…
If you’ve ever needed to compare numbers, dates, or even objects in PowerShell, you’ve probably wondered how to check if one value is greater than or equal to another. In this tutorial, I’ll walk you through the “greater than or equal” operator in PowerShell using examples. PowerShell Comparison Operators Comparing values is at the heart of scripting … read more…
While working on an IT Help Desk product, we needed to get all items from a SharePoint list using Power Automate. The list has more than 10,000 items, and retrieving all of them takes around 38 seconds. To improve the speed, we decided to get only the items created between specific dates. In this tutorial, … read more…
Recently, after I published a post on how to create a Term in the Term Store using Power Automate, one of my clients reached out with another requirement. They liked the automation, but in their team organization, they don’t use Power Automate. Instead, they wanted a way for users to directly add new terms in … read more…
I was working on a document management system for a client where they used the Term Store in SharePoint to manage metadata. The Term Store is useful for keeping tags consistent, but sometimes not everyone has permission to add new terms. This created a problem when users wanted to add missing terms. After some research, … read more…
When I was working on a document management system for one of my clients, they had a particular request: they wanted to add their own custom HTML, CSS, and even a bit of JavaScript to their SharePoint Modern Page. Out of the box, SharePoint doesn’t give you a direct way to drop in custom code, … read more…
When working with a document management system in SharePoint, it is important to keep everything organized. Many times, people use different names for the same thing. For example, one person tags a file as HR, another as Human Resources, and someone else as People Department. This makes search results confusing and slows down work. The … read more…
Last week, one of my customers purchased my small flow “Create List With Different Types of Columns using Power Automate.” After using it, they came back with an additional request: they wanted to automatically add an indexed column whenever a new column is created in SharePoint. If you want to explore more, you can download … read more…
As an administrator, you might need to work with Microsoft Teams using PowerShell. In this tutorial, I will show you how to connect to Teams from PowerShell with some real examples. You can use the Microsoft Teams PowerShell module to manage teams directly from the PowerShell command line. But before that, you need to install … read more…
Enroll now and get access to all 9 academy courses at no extra cost.
Secure your seat before the batch fills up.
Get the live training plus the complete SPGuides.Academy learning library.
This free guide walks you through the 30 most-used Power Apps functions with real business examples, exact syntax, and results you can see.
Learn how to build an invoice management system using SharePoint integration and a repeating table.
📅 2nd September 2026 – 10:00 AM EST | 7:30 PM IST
Download a fully functional Power Apps Canvas App (with Power Automate): User Registration App