Sometimes, you may need to display unique dates from a dataset in a Power BI report. You can create a calculated table or column that filters out duplicate dates to do this. Let’s look at an example of how to filter distinct date using Power BI DAX. Filter Distinct Date Using Power BI DAX While … read more…
I recently created a Power Apps form with a combo box control containing country names as items. To reduce the search time, I sorted the combo box items alphabetically. Users can scroll through the combo box items based on the first letter and easily select their country name. In this article, I will explain the … read more…
Sometimes, you may receive a requirement to create a new table from an existing table in Power BI. This task can be for various reasons, such as organizing data more effectively or preparing it for specific analyses and visualizations. So, I thought to show you how to create a table from an existing table in … read more…
A few weeks ago, I received a requirement in Power Apps to filter the gallery items based on dropdown lookup values. All the dropdown values must be retrieved from the SharePoint list lookup column. In this article, I will show you how to bind SharePoint lookup column in Power Apps dropdown. Also, how to filter … read more…
While working on Power BI, I was required to create a report using sales data from January to December, with each table having the same columns. To create the report, we needed to combine this data, and I learned that we can use the Append Columns method in Power Query Editor. I thought I would … read more…
I currently work for a client who requires me to retrieve the SharePoint document library‘s folder path only if it satisfies the given condition. After researching, I found out how to achieve this. Let me explain how to get SharePoint document library folder path in Power Automate. Get SharePoint Library Folder Path in Power Automate … read more…
A few weeks back, a requirement came up for building an Issue Tracker application using Power Apps. While exporting this application from the development environment to the testing environment, I found the Power Apps environmental variables very helpful because they made it easy to automatically adjust the URLs and connections without manually doing it. In … read more…
Recently, I developed one Power Apps application that needed a SharePoint list data source. Before running the application, the client must create the specific SharePoint list on their site. So, I wrote a Power Shell script to create the SharePoint list along columns to avoid mistakes when creating it manually. This script will first check … read more…
Recently, I created an application in Power Apps for internal employees to store their information. There, I was required to search for employees by department name and job title. Fortunately, the Power Apps Search function helped me achieve this requirement. In this tutorial, I will explain the Power Apps Search function using syntax and some … read more…
In this Power Apps tutorial, We will discuss the Timer control in PowerApps, its properties, and how to add a Timer control in Power Apps. As far as we know, Power Apps has various controls for working with canvas apps; apart from that, PowerApps Timer has an interesting control that can be used to execute … read more…
Power Apps provides various modern controls with different functionalities. Among them, Modern Slider is an important and useful control that allows the user to drag a handle to specify a value. In this article, I will tell you about Power Apps Modern Slider Control and its key properties. Also, we will see how to use … read more…
The OnSelect property of the button control in Power Apps allows us to perform actions like submitting data, navigating to another screen, changing background colors, etc. In this PowerApps Tutorial, I will explain various examples of using this OnSelect property of the button control to perform some actions. How to Use the Power Apps Button … read more…
Whenever I used Power Apps, I encountered difficulties creating the same banner repeatedly or copying and pasting it onto every screen. I researched and resolved the issue by creating a simple Power Apps Component. In this Power Apps tutorial, we will discuss how to create a header component in Power Apps. I will also explain how … read more…
In Power Apps, toggle control allows users to interact with an application by switching between actions, like On and Off, with a simple click. In this article, I will explain the usage of toggle control in Power Apps using 10 different examples. Power Apps Toggle Control The toggle control in Power Apps is a simple … read more…