Bijay Kumar 
In one of my apps, I was loading data from several SharePoint lists into one collection. Since each list had different columns, the final collection didn’t always have the same structure. Before I could filter or use the data, I needed a quick way to see which column names were actually inside the collection. In … read more…
In my organization, when I am creating a Power BI dashboard, and many times I need to add new columns based on different conditions. Sometimes I must check multiple rules, use AND/OR, or handle errors in the data. I also need to add a column only if it doesn’t already exist. Power Query makes all … read more…
In an organization, I set up a Laptop Agreement process in which employees submit requests for laptops to work from home. These requests are stored in a SharePoint list named “Laptop Agreement.” Each request needs to be reviewed by the Releasing Officer. Once approved, the laptop allocation details must be added to another SharePoint list … read more…
When working with Power BI, I need to check if a column contains a specific word or value and then create a new column based on that. At first, I struggled with this because there are many different “contains” scenarios in Power Query. After working on e-commerce dashboard projects, I learned some easy, reliable ways … read more…
In my organization, I am creating a Power BI dashboard, and I often encounter columns with blank or null values. These empty fields can cause issues in calculations and visuals. To fix this, I started using Power Query and DAX to check for blank or null values and create clean, meaningful columns. In this tutorial, … read more…
A few days ago, I needed to filter a gallery based on a Dataverse Choice field. I had a dropdown in Power Apps that showed all the Dataverse choices, and whenever a user picked an option, the gallery had to filter based on that selection. In this Power Apps tutorial, I will explain how to … read more…
If you want to become a SharePoint Framework (SPFx) developer, then you should start by building your first SharePoint client-side web part. This complete tutorial will help you with this. I will explain, step by step, how to develop a SPFx client-side web part, including testing it in the workbench, packaging it, and finally deploying … read more…
Recently, while setting up a reporting dashboard for an organization, I had to work with some data that wasn’t fully clean. One of the tables had repeated values, and before using it in visuals, I needed to clean and prepare it properly. To do that, I first created a duplicate column so I could apply … read more…
Last month, while working on a document management system for our courses, I had to build a flow with more than 10 levels of approvals. Each level depended on a different condition, and when I added the 9th Condition action, I tried to save the flow. I ran into the error: In this tutorial, I’ll … read more…
Recently, while creating an HR dashboard in Power BI, I encountered a situation in which one table had an important column I also needed to use in another table. Instead of manually copying data, I explored different ways to bring that column into the second table. In this tutorial, I will show you how to … read more…
While working on an approval workflow for one of my client projects, I ran into an unexpected issue. The requirement was simple: the approver needed to enter a custom text response instead of just choosing Approve or Reject. But when I tried using the regular Start and wait for an approval action, I realized it … read more…
Recently, while working on an approval workflow for our Power Platform Course, I had to attach supporting documents, images, PDFs, Excel files, and other documents to the Start and wait for an approval text action in Power Automate. Everything worked smoothly until I reached the step where the flow needed to send attachments. However, none … read more…
While working on a Power Apps Model-Driven App, the Contact Number field was created as a Number column in Dataverse. However, the numbers were displayed with commas as thousand separators, which made the contact numbers look confusing. The requirement was to remove these commas and display the numbers as a clean, continuous string. In this Dataverse … read more…
Recently, I was working on a Voter Application Forms app for an organization using a Model-Driven App in Dataverse. As part of the requirement, I needed to create a flow that sends an email to the manager (or any authorized person) whenever a new entry is added to the Dataverse table. The email must also … 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