Bijay Kumar 
When working with custom tables in Dataverse, the Primary Name column is often set as a required text field. But entering values like TKT-1000, REQ-2025-001, or INV-000123 manually can be repetitive and prone to errors. Dataverse now allows you to change the Primary Name column to Autonumber, letting the system generate unique, consistent values automatically. … read more…
Power Apps now lets you integrate AI-powered prompts directly into your apps using the Prompt (AI capability). This feature makes it easy to collect input from users in a more interactive and dynamic way. You can configure it to accept free text, ask for a file upload, or even guide users with context-aware suggestions. By … read more…
Recently, I needed to import some Excel data into Dataverse for one of my Power Apps projects. At first, I thought it would be a simple copy-paste job, but it wasn’t. I encountered a few limitations and began exploring alternative options. That’s when I discovered three easy and practical ways to get Excel or CSV … read more…
Recently, one of my clients wanted to list down old files from a shared drive in their New York office. By using PowerShell, you can identify files older than any date you choose. In this tutorial, I will show you how to find files older than a specific date using PowerShell, along with some examples, such … read more…
Have you ever found yourself needing to display numbers as two digits in your TypeScript projects, like “07” instead of “7”? In this tutorial, I’ll walk you through several ways to format numbers as two digits in TypeScript. We’ll cover built-in JavaScript methods, string manipulation, and formatting with Intl.NumberFormat. Here are the methods: Method 1: … read more…
In this Dataverse tutorial, I will show you how to create a Dataverse table step-by-step using different methods like Copilot and Blank table. Also, I will explain how to add various column types such as Text, Choice, Lookup, and more. This guide will help you get started with the Dataverse table easily, even if you’re … read more…
Have you ever needed to extract just the decimal part from a number in your TypeScript project? Maybe you’re building a financial dashboard or processing sales tax calculations, and you need to isolate the cents from a dollar amount. In this tutorial, I’ll walk you through several methods to get the decimal (fractional) part of … read more…
Would you like to display current user profile information using a SharePoint Framework user profile web part? We can do this by retrieving the current logged-in user’s information from the Azure Active Directory into the SPFx web part using the Microsoft Graph API. In the example below, you can see that we have retrieved the … read more…
In Power Automate, there are many situations where you need to split a string and retrieve a specific part, such as the first, last, or any specific n-th value. For example, suppose you have a string like this: “123 Main Street, Springfield, IL, 62704.” Now, you want to extract only the city (Springfield) or the … read more…
In this Power Pages tutorial, I’ll show you how to set up Google login as an authentication method. This is great when you want to allow users to sign in to your site using their Google accounts, whether they’re internal users, partners, or public visitors. Power Pages supports multiple OAuth 2.0 providers, including Google, Facebook, … read more…
Recently, while I was trying to create a new SPFx (SharePoint Framework) solution using the yo @microsoft/sharepoint command, the process failed and displayed more than 100 npm warnings. Then, at last, it displays some errors like: I couldn’t find any clear solution because these errors do not directly say what the actual root cause was, … read more…
In this typescript tutorial, we will see how to convert an array to a string with a separator in typescript using different methods. Here are the methods we are going to cover: Convert a TypeScript array to a String With a Separator using Join() Here we will see how to convert an array to a … read more…
In modern TypeScript development, you might need to determine if an object is empty, meaning it has no own properties. In this tutorial, I will explain how to check if an object is empty in TypeScript using various methods with practical examples. What Does “Empty Object” Mean in TypeScript? In JavaScript and TypeScript, an “empty … read more…
Recently, one of my team members was trying to convert a number to a boolean in TypeScript. I suggest a few methods to do so. In this tutorial, I will explain several methods to convert a number to a boolean in TypeScript with practical examples. In TypeScript, you’ll often encounter situations where you need to … 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