Bijay Kumar 
I’m currently working on an intranet portal for a client that requires managing a large number of metadata terms, such as departments, regions, and document types. Manually adding each term one by one would have taken a lot of time. That’s when I used the Import feature in the SharePoint Term Store. SharePoint allows you … read more…
In SharePoint, the Term Store helps maintain consistent metadata across your sites. But users might search using different words for the same term. For example, one user might search for “HR” while another might look for “Human Resources.” To bridge this gap, SharePoint allows you to add synonyms (or ‘Other Labels’) to metadata terms, improving … read more…
Do you need to retrieve the key name from an enum value in TypeScript? As a TypeScript developer with many years of hands-on experience, I’ve faced this situation countless times—especially when working with data from APIs or user input that only provides enum values. In this tutorial, I’ll walk you through multiple methods to get … read more…
When someone opens your Copilot Studio chatbot, the very first thing they see is the welcome message. By default, it’s pretty basic, but now you can change it! Whether you’re building a support bot, an HR assistant, or a custom solution for your business, updating the welcome message helps you set the tone, guide users … read more…
Recently, one of my clients asked if it’s possible to automatically extract key information from an invoice, such as Name, Amount, Item Description, Date, and Summary, as soon as the invoice file is uploaded to a SharePoint Document Library. After exploring a few options, I found a simple and effective solution using Power Automate and … read more…
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…
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 a SharePoint Permission Checker Agent using Copilot Studio. Using this agent, you can check library-level and file-level permissions. Also, identify Users, SharePoint Groups, and Permission Levels.
📅 1st July 2026 – 10:00 AM EST | 7:30 PM IST
Download a fully functional Power Apps Canvas App (with Power Automate): User Registration App