Bijay Kumar 
While working on a client report, there was a requirement to select multiple values from a slicer instead of choosing only one value at a time. The client wanted users to filter the report easily without holding the Ctrl key, and also needed the slicer to work across different visuals and tables. To solve this … read more…
Last week, one of my subscribers asked me a question about Power Query in Power BI. He was working with a Product table that has three columns: Product Key, Date, and Sold. For one Product Key, there are many records with different dates. The requirement was simple. He wanted to count how many times the … read more…
While working on Power BI reports, I receive data from multiple tables or different data sources. Many times, the information we need is split across these tables, and using them separately can cause issues when creating table visuals in Power BI. To solve this problem, we need to merge tables in Power BI. We can … read more…
As a community contributor, I regularly write blog posts based on my real-time experience from client projects and from working on our internal products. Sometimes I write a completely new blog post, and sometimes I update an existing post with new learning and practical experience. Before writing or modifying a post on SPGuides or EnjoySharePoint, … read more…
While working on a Power BI report for a Sales team, one of my colleagues asked me how to convert numbers to text in Power BI. This was because, in the source data, one column contained both numbers and text values. When this column was used in a chart or visual, Power BI started showing … read more…
I was working on a Power BI report, and I noticed that some columns, like Employee ID, Customer Code, or Product Number, were stored as text and had leading zeros, for example, 000123. When I use this column in a report and try to sort or filter the data, I am not getting the correct … read more…
When I was working on a Power Apps and Power Automate solution to create SharePoint sites automatically, I needed it to work across any tenant. The flow creates SharePoint sites via REST API calls, so we must pass the tenant name. However, Power Automate does not provide any direct action or function to get the tenant … read more…
When building apps in Power Apps, we often need fields to store simple true/false values, such as Is Active? Is it approved? Or has Email been Sent?. In Dataverse, this type of field is called a Yes/No field. In one of my apps, I needed a simple way to track things like whether a record … read more…
When I was working on a Power Apps and Power Automate solution for a client who wanted to create SharePoint sites automatically. Users would fill in details such as site title, internal name, storage quota, description, owners, members, and visitors in Power Apps. After submitting the form, Power Automate creates the SharePoint site using a … read more…
Recently, I was working on a Power BI report for a client. They wanted to create a report for their marketing team, where users can click on a visual and see more information related to that item. In their dataset, they already have a URL column. The requirement was to show this URL in a … read more…
When we add data to Power BI, we can sort the data in ascending or descending order. But in this case, I want something different. The marketing team wants to see sales data grouped and ordered by Customer Location so they can quickly understand which locations are performing better. To achieve this, we need to … read more…
When we are working on a Power BI report for a client, one of my colleagues asked me a question like this: This is what the index column shows now: But this was not the expected result. They wanted the index column to be like this: This means the same Department should have the same … read more…
In my previous post, I mentioned that I am working on a product that creates SharePoint sites using Power Apps and Power Automate. When the site is created, I am adding the current user as an Owner of that site. But after the site is created, I need a way to remove that user from … read more…
I am currently working on a small but useful product for creating SharePoint sites using Power Apps and Power Automate. I designed a Power Apps screen that allows people to enter required details, such as the site name, owner, visitor, and storage. After users submit the data, I created a Power Automate flow that uses … 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