Bijay Kumar 
While working on a Power Apps application, there was a screen where the admin wanted to search and filter the gallery based on Microsoft 365/Office 365 users. Let’s say there is a Dropdown control containing departments such as IT, HR, and FINANCE, and a Text input control. Admin will navigate to the screen and select … read more…
While working on an internal app, a Power Apps gallery contains more than 100 records. Whenever I wanted to search for an item in the gallery, I kept scrolling to find the specific record, which took too long. To make the search thing easier, I added a Text input box where users can type exactly what they … read more…
SharePoint is a powerful collaboration platform that can change how your company manages documents, workflows, and team communication. But if you set it up poorly, it can quietly drain your budget through wasted storage, low productivity, and security headaches. Many mid-sized companies lose thousands every year because of simple mistakes that honestly could’ve been avoided. … read more…
While working for a client, I faced a requirement where the report needed a daily filter that automatically reflects the current date. The client wanted the report users to filter data every day without manually selecting the date each time. To achieve this, I decided to add today’s date as a separate column in the … read more…
While working on Power Apps projects, I often had to move data from various sources, such as SharePoint lists, Excel files, and other systems, into Dataverse. Doing this manually every time was impractical, especially since the data needed to stay up to date. This is where Dataverse Dataflows became really useful. In this tutorial, we … read more…
For the past few months, I’ve been working on a SharePoint Framework (SPFx) web part for a client. This web part uses the Microsoft Graph API to send emails whenever a new item is added to a SharePoint list or when an item’s status changes. To send emails, I used Mail.Send permission from Microsoft Graph. … read more…
While working on a client project, I faced a common requirement. The client wanted users to upload images directly from a Power Apps form and store them securely in Dataverse. This was needed for scenarios like uploading ID proofs, profile photos, or supporting documents during form submission. At first, it sounded simple, but when you … read more…
When I need to detect empty or missing values in a dataset, I use DAX functions in Power BI. In DAX, we have two functions, ISBLANK and ISEMPTY, and at first, they look like they do the same thing. Both functions return TRUE when something is empty and FALSE when data exists. Because of this, … read more…
While working on a project, there was a requirement to forward Outlook meeting invitations automatically to specific users. The client wanted this to happen automatically, especially when meetings were created or updated by a particular person. To meet this requirement, I used Power Automate to build a flow that detects a meeting invite in Outlook … read more…
I am working on a report for an organization, and I faced a requirement to identify and handle blank values in Power BI reports. Several columns contained empty data, which we did not want to consider in reports. Power BI provides multiple DAX functions, such as ISBLANK, COALESCE, FIRSTNONBLANK, and LASTNONBLANK, to identify, remove, or … read more…
One of my colleagues asked me how to join the First Name and Last Name columns in Power BI and add a space between them. He had tried creating a calculated column using the following DAX formula: However, this caused an error because the CONCATENATE function in DAX only accepts two arguments in the format … read more…
One of my colleagues asked me how to check if a text value is a date in Power BI Power Query. He was working on a report where a date field was stored in text format. When he tried to change the column data type to Date, Power BI showed errors for some rows. The … read more…
While working on Power BI reports for clients, I noticed that the data coming from Excel, SharePoint, or databases was rarely ready for reporting. In many cases, the values I needed were not available as separate columns. Instead, I had to create new columns from existing data, such as calculating values, applying simple business logic, … read more…
While working on a client report, there was a requirement to clean and format text data before using it in visuals. The source file contained values such as codes, names, and descriptions combined into a single column. The client wanted only specific parts of the text, such as the first few characters, the last value, … 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