Bijay Kumar 
While working on a project, a client asked me about the various ways to display SharePoint list in Power Apps and how to get value from SharePoint list in PowerApps. I researched some articles and collected a total of five different ways to show SharePoint list items in Power Apps. In this tutorial, I will … read more…
In this Power BI tutorial, I will explain all about Power BI Power Query examples, Power Query m Language examples, and Power Query Advanced Editor examples. Also, we will cover the topics below: What is Power Query in Power BI? Power Query is a feature within Power BI (also available in Excel) that allows users … read more…
The Navigate function in Power Apps helps you change which screen to display. It allows you to transition from one screen to another, either within the same app or to a different app. In this tutorial, I will explain in detail the Power Apps navigate function, Power Apps screen transitions, and how to work with … read more…
In this Power Apps article, I will tell you what the PowerApps replace function is, how to use Power Apps replace function, and how to substitute in Power Apps with various examples. Also, we will discuss how to work with Power Apps replace character in string, Power Apps remove special characters from string, and many … read more…
The Power Query Editor in Power BI is a strong tool for transforming data. It helps you clean and manipulate data right within Microsoft Power BI. In this tutorial, I will explain how to create table in power query, including: Power Query Create Table To create a table in power query, follow the steps below: … read more…
The Power Apps collection is a temporary storage area for data. Sometimes, we need to update or add a new record to the collection. Follow this tutorial to learn more about the Power Apps update collection. Such as: Update Collection PowerApps Updating a Power Apps collection typically involves adding, modifying, or removing records from the … read more…
When using Power BI, you might encounter a situation where you need to apply an IF condition with dates or Power BI IF Date. What will happen then? In this tutorial, we will see how to work with the Power BI if statement with dates and Power BI if date is between two dates then … read more…
When working with Power Apps, we usually need to create a collection to store and manipulate data within the app temporarily. In this Power Apps tutorial, I will explain everything about the Power Apps Collection, like what is a collection in Power Apps and its syntaxes. Including: Collection in Power Apps A Collection is a … read more…
When we discuss Power BI logical functions, we usually start with the IF function. But there is a problem: the IF function becomes more complex if we have multiple conditions. That’s where the Power BI Switch function comes in handy. In this tutorial, we will discuss the Switch function in Power BI and the switch … read more…
When working with Power Apps applications, we should use a list of functions to build more responsive and attractive apps. One of the most important and easy functions is the Len() function, which determines the length of a string. In this tutorial, I will explain what the Power Apps Len function is and its syntax. … read more…
One of my subscribers emailed me recently. When they tried to publish their report on the web, they got an error message saying, “This content isn’t available. Learn more about Power BI.“ In this Power BI tutorial, we’ll talk about how to fix an error message that says, “This content isn’t available.” Power BI Error: … read more…
In this Power Apps tutorial, I will explore how to create a cascading dropdown in Power Apps using different ways. Such as: Cascading Dropdown in Power Apps [Manually] Power Apps cascading dropdown is mostly useful when you have data that is related hierarchically. To create a cascading dropdown in Power Apps manually, we will use … read more…
The Power BI Pie chart has one drawback. We can not find any conditional formatting option because it is unavailable in the chart. However, we have an alternative way to apply conditional formatting to the Power BI Pie chart. In this tutorial, I will explain how to apply conditional formatting in Power BI pie chart … read more…
Recently, I got an opportunity to work on creating a CSV file in SharePoint using Power Apps. In this Power Apps tutorial, I will explain in detail information about how to create CSV file in SharePoint using Power Apps with a real-time scenario. Also, we will see how to export gallery data to excel in … read more…