Suppose you want to filter the Power Apps data table using dropdown. In that case, you can follow this tutorial to get all the information about how to filter Power Apps data table by dropdown. Here, we will discuss filtering the Power Apps data table by dropdown using the collection and SharePoint Online list. Also, … read more…
Power BI is a great tool for data analysis. When people first learn Power BI DAX (Data Analysis Expressions), they often begin with basic arithmetic calculations like addition, subtraction, multiplication, and division. In this tutorial, I will demonstrate how to subtract in Power BI using DAX (Calculate column, Measure). We will also discuss how to … read more…
Power BI can be quite useful when we are working on dates. It has some powerful built-in formulas that allow you to do calculations based on dates. One common scenario where you have to perform calculations with dates would be to find out how to calculate monthly sales. In this tutorial, we will learn how … read more…
This Power BI tutorial will help how to add data to existing table in Power BI. Recently, while working on a Power BI report, I encountered a situation where I needed to add data to an existing table. The Append feature in the Power Query Editor of Power BI proved very helpful in this scenario. … read more…
Power Apps is a powerful platform developed by Microsoft that allows users to create custom business applications using different types of control like Text inputs, Dropdown, Forms, Gallery controls, etc. While working with the dropdown control, we sometimes need to validate if a dropdown is empty or not in Power Apps; if it is empty, … read more…
If you are having trouble organizing your data in Power BI, the Power BI measure table can be helpful. In this Power BI tutorial, we will look at the idea of a Power BI measure table, how to create a measure table in Power BI, and how to add the measure to the measure table … read more…
Sorting columns is common when working with Power BI tables and matrix visuals. It helps in organizing and presenting data in a more meaningful way for analysis. But what if you want to Sort Multiple Columns in Power BI? Sorting columns in Power BI tables and matrix visuals might differ from other software, but you … read more…
Are you getting the error “register-pnpmanagementshellaccess is not recognized” while using PnP PowerShell? I will show you how to fix this error. Register-PnPManagementShellAccess : The term ‘Register-PnPManagementShellAccess’ is not recognized Recently, I was using PnP PowerShell to connect to SharePoint Online. While running the below command, I received the error: The complete error message looks … read more…
While working with the Power Apps Dropdown control, we usually need to filter the data like SharePoint list records, Collection records, and Excel items based on the dropdown selected value. But, sometimes, we need to add an “All” option to a dropdown in Power Apps that allows users to display all the records on the … read more…
Power Apps dropdown controls are mostly used to collect user input, such as selecting a category, product, or value from a SharePoint list. A common scenario involves using a dropdown control in PowerApps to display a list of users from a SharePoint person or group field. Follow this tutorial to get all the information on … read more…
Do you want to install PnP PowerShell? I will explain in detail how to install PnP PowerShell for SharePoint Online. Let us first understand what is PnP PowerShell and what we can do using this? PnP PowerShell PnP PowerShell is an open-source and community-provided library containing more than 650 cmdlets to work with various Microsoft … read more…
If you are working in PowerShell, then you will get requirements to use looping to iterate items in a collection. In this tutorial, I will explain how to use PowerShell foreach loop with various real examples. The foreach loop in PowerShell takes a collection of items and iterates over each item sequentially. It assigns each … read more…
Microsoft Provides a list of controls to Power Apps to build business applications. This Microphone control enables users to interact with the application through voice commands or capture audio input. In this tutorial, I will explain to you what Power Apps Microphone control is, the key properties of the Power Apps Microphone control, and how … read more…
When working with dates in Power Apps data tables, sometimes you must change the date format to suit your application’s requirements or user preferences. Recently, I was working on the Power Apps data table control where I needed to change a SharePoint date format to dd/mm/yyyy. In this Power Apps tutorial, I will show you … read more…