microsoft.sharepoint.client.invalidclientqueryexception in SharePoint REST API

microsoft.sharepoint.client.invalidclientqueryexception

In this SharePoint tutorial, we will see how to fix the error: “Microsoft.SharePoint.Client.InvalidClientQueryException” ,”message”:{“lang”:”en-US”,”value”:”The expression \”web/lists/getbytitle(‘Sales’)/items(undefined)\” is not valid.” in SharePoint REST API. We will also discuss why we got this error: “The expression \”web/lists/ getbytitle(‘Sales’)/ items(undefined)\” is not valid.” as well as its solution. Refer to the error image below. Error: Microsoft.SharePoint.Client.InvalidClientQueryException I have … Read more >>>

SharePoint Team Site vs Communication Site

SharePoint Team Site vs Communication Site

SharePoint offers two main types of sites for different needs: team sites and communication sites. These sites serve distinct purposes within organizations using Microsoft 365. Team sites are designed for collaboration, allowing groups to work together on projects and share files. They come with a Microsoft 365 Group, which provides additional tools like a shared … Read more >>>

Unable To Join Microsoft Teams Meeting As Guest

join microsoft teams meeting as a guest

One of my clients recently came with a query; their guest users are unable to join a Teams meeting anonymously. There are some changes and settings you need to make for this. In this tutorial, I will explain how to join a Microsoft Teams meeting as a guest. Basically, you will learn how to enable … Read more >>>

How to Replace Special Characters in a String using Power Automate

Power Automate replace special characters in string

I was recently working with the Replace() function in Power Automate, which allows us to replace characters, substrings, or strings in arrays, multiple objects in JSON format, and more. In this article, I will explain how to replace special characters from a string in Power Automate with the following examples. Replace a Single Special Character … Read more >>>

How to Get Current User using SharePoint Rest API?

sharepoint rest api get current user

I was working on a SharePoint project, where we were required to retrieve the current user using the REST API in SharePoint. I wanted to retrieve the current username, display name, email address, ID, and other relevant information. If you are new to SharePoint REST API, check out the SharePoint REST API Tutorial and Examples. … Read more >>>

SPFx Accordion Webpart Example

spfx sample accordian example

I recently worked on a SharePoint Framework (SPFx) project for a client where we created an accordion webpart. In this tutorial, I will explain how to create an SPFx Accordion Web Part using sample data with the help of @pnp/spfx-controls-react in the React Framework. Accordions are commonly used for displaying frequently asked questions (FAQs). In … Read more >>>

How to Replace String in JSON using Power Automate

Power Automate Replace a String in JSON

A few days ago, I worked with a client to develop a Project Management system utilizing SharePoint lists, libraries, and site pages. The client requires JSON data for each project, and based on the project status, I want to update the Project priority value: replace ‘Low’ with ‘High’ if the status is ‘In Progress’. In … Read more >>>

Filter Array in Power Automate Examples

Filter array equals in Power Automate

I was recently working on the Filter Array in Power Automate, where we can filter the items in the array by using different types of operators in the Filter Array action. This tutorial explains how to use filter query operators in the Filter Array action of Power Automate. Here we will see the following examples: … Read more >>>

>

Live Webinar

Create a SharePoint List & Columns from Excel Using Power Automate

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

Build a High-Performance Project Management Site in SharePoint Online

User registration Power Apps canvas app

DOWNLOAD USER REGISTRATION POWER APPS CANVAS APP

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

Power Platform Tutorial FREE PDF Download

FREE Power Platform Tutorial PDF

Download 135 Pages FREE PDF on Microsoft Power Platform Tutorial. Learn Now…