Power Apps Charts Tutorial: Visualize SharePoint Data using Pie Chart

Power Apps Charts

Did you know we can use Power Apps to generate dynamic and powerful charts? Yes, we can generate visually appealing charts with other tools, such as Power BI, by leveraging Power Apps Chart Controls. This Power Apps tutorial explains what Power Apps Charts mean, different types of chart controls in Power Apps, and how to add … read more…

How to Create SPFx Web Part with jQuery Accordion

jquery accordion in spfx web part

Do you ever need to display information in an accordion style on the SharePoint home page? Recently, for a client, we developed a client-side SPFx web part that dynamically displays information from a SharePoint events list. Even though SharePoint already has an Events web part to display upcoming events, it didn’t provide the flexibility we … read more…

How to Create Dataverse File Field [With Examples]

Create Dataverse File field

When I was building an internal Power Apps solution for one of our teams, we needed a way to store documents directly inside Dataverse, things like invoices, agreements, and small supporting files. At first, it looked simple, but once we started working on it, questions came up: How much file size does Dataverse support? Can … read more…

How to Change Data Type in Power BI?

Change Data Type in Power BI

Last week, when I created a Power BI report for the Finance team, I received the data from SQL. After loading it into Power BI, I noticed that some fields had the wrong data type. For example, a few columns were loaded as text, but they should have been numbers. To change the data type, … read more…

How to Change Data Type in Power BI Using Power Query

How to change data type in Power BI query

While working in Power BI, one of my colleagues asked me, “Is there a way to set the data type when creating a new column in Power Query?” This happened because when we add a column, Power Query does not automatically assign the correct data type. Usually, we first create the column and then change the … read more…

How to Add an Empty Column in Power BI

Add an empty column in power bi

While creating a dashboard for an organization, I realized I needed a few empty columns. To do this, Power BI provides multiple ways to create empty columns, depending on whether you’re working with DAX or Power Query. In this tutorial, I will show you all the practical methods to add an empty column in Power … read more…

Count Data With Multiple Filter Conditions in Power BI DAX

multiple filters with the CALCULATE FUNCTION Power BI

We are working on a report for our client, and during the discussion, one of my colleagues asked me a question. They wanted to calculate how many customers placed an order in the last 30 days, for a specific product category, and whose total purchase amount is above 10,000. I told them we can easily … read more…

How to Filter Power BI Dax Based On Condition

Power bi DAX filter based on condition multiple conditions

A few days ago, I was working on a Power BI report where the client needed some special filters. They wanted to see sales above a certain number, show only active records, and apply more than one condition at the same time using DAX. The normal Power BI filters could not do this, so I … read more…

How to Filter Dates in Power BI DAX [7 Examples]

Power BI DAX filter datediff

A few days ago, I was creating a dashboard for a client where they needed to analyze their data using different date conditions. They wanted to see records greater than a certain date, compare data before a specific date, and even view trends between two selected dates. Since these filters had to work dynamically inside … read more…

Power BI Distinct Count with filter [With 5 Examples]

Power BI distinct count with filter

Today, I received an email from a user who wanted to create a DAX measure to count how many distinct companies sold 10 or more items in a week. They wrote a DAX formula like this: Count above 10 =CALCULATE( DISTINCTCOUNT(Table1[Company]), FILTER(Table1, SUM(Table1[Items sold]) >= 10)) But this did not work. The reason is that … read more…

Get SharePoint Folder Permissions Using PowerShell

get sharepoint library file permissions into an excel

A few days earlier, my manager asked me to send a report about who had permission (including external users) to access the files stored in the SharePoint library. This library has multiple levels of subfolders, so I need to make a report on the files present in those subfolders as well. To achieve this requirement, … read more…

Power Apps functions free pdf

30 Power Apps Functions

This free guide walks you through the 30 most-used Power Apps functions with real business examples, exact syntax, and results you can see.

Live Webinar

SharePoint Permission Checker Agent using Microsoft Copilot Studio

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 User registration canvas app

DOWNLOAD USER REGISTRATION POWER APPS CANVAS APP

Download a fully functional Power Apps Canvas App (with Power Automate): User Registration App