Bijay Kumar 
When working with strings in PowerShell, I often need to extract characters from the end of a string. You will get this kind of requirement when parsing log files, manipulating file names, processing data from APIs, etc. In this article, I’ll show you several methods to extract a substring from the end of a string … read more…
When working with TypeScript, I often need to convert enum values to their string representations. This is especially common for TypeScript developers when displaying enum values in a user interface or serializing data for API calls. In this tutorial, I will explain several reliable methods to convert enums to strings in TypeScript with examples. Let’s … read more…
As a PowerShell administrator, I use the Get-ItemProperty cmdlet a lot. You can use this cmdlet to gather installed software information, access registry values, or retrieve file metadata, etc. In this tutorial, I will explain how to use Get-ItemProperty in PowerShell effectively with real-world examples that I’ve personally used throughout my decade-plus career with PowerShell. … read more…
A few days ago, I started working on an IT Help Desk application in Power Apps. The app has many screens, so I decided to use a Power Apps navigation component instead of adding separate navigation buttons on the home screen. Based on my research, a horizontal navigation menu with submenus is a better option … read more…
If you work with Microsoft Dataverse, you already know how powerful it is for storing and managing business data. However, when you need to export that data to Excel for reporting, manual export can take a lot of time, especially if you do it regularly. While some people can export manually, automating the process saves … read more…
One of my colleagues recently started working with Dataverse in Power Automate and asked me a simple but important question: “How do I get the value from a Choice column in Dataverse using Power Automate?” They were used to working with SharePoint, where we usually access a Choice column value using something like trigger()?[‘ColumnName’]?[‘value’]. But … read more…
When working with Microsoft Dataverse in Power Automate, you often retrieve data as one of the most common tasks. In Power Automate, there are two main ways to get data from Dataverse: And each of these actions comes in two versions: In this tutorial, I will explain how to get a row by ID from … read more…
I was working on a Power Apps project for a field inspection team. They needed a way for users to take photos right inside the app. I found the Camera control in Power Apps, which worked perfectly for this requirement. With just a few steps, I was able to set it up so users could: … read more…
Recently, I was working on a server cleanup project where I needed to delete thousands of log files that were older than 90 days. These files were taking up valuable disk space, and manually identifying and deleting them would have been incredibly time-consuming. In this tutorial, I’ll show you how to create PowerShell scripts that … read more…
A few days ago, a client had a request. They have a Power Apps form with several fields. We used a SharePoint list containing certain users’ email addresses. Only those users can edit all the fields, while others can edit only some. In this Power Apps tutorial, I will explain role-based security in Power Apps … read more…
This Power Apps tutorial will teach you how to use the Power Apps gallery control’s OnSelect. Then, we will discuss the Power Apps gallery OnSelect navigate Screen and how to get selected gallery record details on a Display form/Edit form using the OnSelect property. Additionally, we will see how to set a variable in the gallery … read more…
Do you want to receive a notification on your phone when a new form is submitted or a task is assigned to you? With the help of Power Automate, we can easily send mobile notifications. In this Power Automate tutorial, I will show you two flows: sending a mobile notification using a manually triggered trigger … read more…
A few weeks before, I developed a Power Apps application for a client that takes data sources as a SharePoint list. There are almost six lists, and each list has more than 20 fields. Due to some permission issues, we had to manually create all the lists and columns on the SharePoint site. So I … read more…
Recently, I was working on a PowerShell script to validate user inputs, and I needed to check if strings contained special characters. This is a common requirement when validating usernames, passwords, or parsing data files. The challenge is that PowerShell treats many special characters differently since they have specific meanings in the language. In this … 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