Bijay Kumar

Hey! I’m Bijay Kumar, founder of SPGuides.com and a Microsoft Business Applications MVP (Power Automate, Power Apps). I launched this site in 2020 because I truly enjoy working with SharePoint, Power Platform, and SharePoint Framework (SPFx), and wanted to share that passion through step-by-step tutorials, guides, and training videos. My mission is to help you learn these technologies so you can utilize SharePoint, enhance productivity, and potentially build business solutions along the way.

Exception calling ExecuteQuery with 0 argument(s): Unable to connect to the remote server error in PowerShell SharePoint Online

by
Exception calling ExecuteQuery with 0 argument(s) Unable to connect to the remote server

Recently, I was trying to insert items to the SharePoint online list through the PowerShell command. The error came in the below line while calling the ExecuteQuery() method. The error comes as an Exception calling “ExecuteQuery” with “0” argument(s): “Unable to connect to the remote server” $Context.ExecuteQuery(). Exception calling “ExecuteQuery” with “0” argument(s): “Unable to connect … read more…

Windows PowerShell ISE [Complete Tutorial]

by
powershell ise

Windows PowerShell ISE is used to create and run PowerShell scripts. It offers a user-friendly interface that makes it easy for both beginners and experts to work with PowerShell commands. The Integrated Scripting Environment (ISE) combines a script editor, console, and debugging tools in one application. PowerShell ISE allows users to write, test, and run … read more…

SharePoint Online Management Shell

by
SharePoint Online Management Shell

SharePoint Online Management Shell is very useful for administrators in managing their SharePoint Online environments. It provides a set of PowerShell cmdlets that allow users to control various aspects of SharePoint sites and settings in Microsoft 365. It saves time and effort by automating tasks requiring manual input through the web interface. The SharePoint Online … read more…

How to Create a File in PowerShell if it Doesn’t Exist?

by
powershell create file if not exists

In this tutorial, I will explain how to create a file using PowerShell if it doesn’t already exist. As a PowerShell user, I’ve encountered situations where I needed to ensure a file was created only if it wasn’t present. I’ll walk you through different methods to achieve this with examples. Check File Existence with Test-Path … read more…

PowerShell Get-date Add Days Examples

by
powershell get-date add days

Recently, I got a scenario where I needed to calculate future dates based on a specific number of days. The Get-Date cmdlet in PowerShell provides the adddays() method to achieve this. In this tutorial, I will explain how to add days to a date using the PowerShell Get-Date cmdlet. PowerShell Add Days to Date The … read more…

3 Easiest Ways to Concatenate Text Strings in Power Apps

by
powerapps concatenate multiple values

A few days ago, I developed an employee leave management application. To generate a unique request ID, I was required to concatenate the employee name with the current date in a text format. Also, I need to notify the employee by their name when submitting the leave request. I achieved all these requirements with different … read more…

How to Create a Log File using PowerShell?

by
powershell create log file

As an IT professional managing servers for a US-based company, I recently encountered a situation where I needed to track the execution of a critical PowerShell script. To ensure easier troubleshooting, I implemented logging functionality in my script. In this tutorial, I will explain how to create a log file using PowerShell. By analyzing log … read more…

How to Compare Dates in PowerShell?

by
powershell compare dates

Recently, to analyze a log, I was required to compare two dates in PowerShell. PowerShell provides powerful built-in cmdlets and operators that make comparing dates easy. In this tutorial, I will show you how to compare dates in PowerShell. Let me show you different methods with practical examples. Compare Dates Using PowerShell Comparison Operators PowerShell … read more…

How to Check If a Date Is Older Than 30 Days in PowerShell?

by
powershell if date is older than 30 days

In this tutorial, I will explain how to check if a date is older than 30 days using PowerShell. Recently, I helped my team troubleshoot an issue where we needed to identify files in a directory created more than 30 days ago to archive them. Let me explain how we fixed it. PowerShell If Date … read more…

PowerShell Copy-Item with Folder Structure

by
PowerShell Copy-Item with Folder Structure

In this tutorial, I will explain how to use PowerShell’s Copy-Item cmdlet to copy files and folders while maintaining their original structure. This is a common task for system administrators and developers who need to manage file systems efficiently. You will learn here how to use the PowerShell Copy-Item cmdlet to efficiently copy files and … read more…

Get-ChildItem Sort By Date in PowerShell

by
get-childitem sort by date

As an IT administrator, I recently needed to find the most recent log files in a directory to troubleshoot an issue. Using the Get-ChildItem cmdlet combined with the Sort-Object cmdlet, I quickly sorted the files by date and identified the relevant logs. In this tutorial, I will explain how to use the Get-ChildItem cmdlet in … read more…

PowerShell Copy-Item Cmdlet to Copy Files and Folders

by
powershell copy-item

The PowerShell Copy-Item is a useful cmdlet that allows you to copy files and folders. In this tutorial, I will explain how to use the PowerShell Copy-Item cmdlet to copy files and folders efficiently with some examples. PowerShell Copy-Item PowerShell Copy-Item is used to copy files and directories from one location to another. Whether you … read more…

How to Create a Dropdown With Other Option in Power Apps?

by
create power apps dropdown with other option

Recently, I was required to create a Power Apps form from SharePoint named Employee Leave Requests, which has a leave type choice column. While submitting the leave requests, employees might have other leave-type reasons, which I haven’t included in the choice column. So, in the Power Apps form, I was required to create an “Other” … read more…

⏰ LIMITED-TIME OFFER

Join the SharePoint & Power Platform Developer Live Training

📅 Live training starts October 5, 2026
✓ SharePoint Development
✓ Power Apps & Power Automate
✓ Copilot Studio
🎁
FREE 1-Year Access to SPGuides.Academy

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.

Enroll Now & Get Your FREE 1-Year Academy Access → View live training details and schedule
Power Apps functions free pdf

30 Power Apps Functions

This free guide walks you through the 30 most-used Power Apps functions with real business examples, exact syntax, and results you can see.

Live Webinar

SharePoint Integration Power Apps Form With Repeating Table [Invoice Management System]

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

Reserve My Spot (Free)
Download User registration canvas app

DOWNLOAD USER REGISTRATION POWER APPS CANVAS APP

Download a fully functional Power Apps Canvas App (with Power Automate): User Registration App