In SharePoint, you might want to display a page, file, or folder in a web part; the SharePoint Page Viewer web part is the best option for this. The page viewer web part is only available on a Classic SharePoint site. However, the Modern SharePoint site does not support it. If you want to display … read more…
In this Power BI Tutorial, we will learn about the Power BI Group By function and Power BI Count Group By. Also, we will cover the topics below: Power BI Group By function Power BI GROUP BY is a function used in the query editor or in DAX (Data Analysis Expressions) to combine data based … read more…
One of my clients provided a requirement to create a pagination in the Power Apps application. Additionally, they want to use the Gallery control and a Dropdown control to make pagination more attractive and responsive. This Power Apps article explains how to create pagination in PowerApps, pagination in PowerApps gallery, and pagination in Power Apps … read more…
Recently, I was creating an Asp.Net web application for a SharePoint POC where we wanted to display SharePoint list data using CSOM (Client side object model using C#.Net), but I got an error as: Could not load file or assembly ‘Microsoft.AI.Web’ or one of its dependencies. The system cannot find the file specified. Description: An … read more…
One of my clients provided a requirement to display a SharePoint document/file in the Power Apps application. Additionally, they want to use the Search Bar, Open File, Zoom In, and Zoom Out functions of PDFs [much way your Windows, Mac OS, and Android devices’ local PDF reader software does]. To achieve this, Power Apps provides … read more…
A Power BI Date Slicer is like a magic wand for your data. It lets you easily filter and visualize your data based on dates. Think of it as a virtual tool that helps you slice and dice your data by time periods such as days, weeks, months, or even years. In this tutorial, we … read more…
I recently received a task in which I needed to remove the first and last characters from a string and all spaces from the string in Power Apps. Fortunately, Microsoft Power Apps provides Trim and TrimEnds Functions to achieve this. In this Power Apps tutorial, I will explore all the information about the Power Apps … read more…
When working in Power BI, you might encounter a situation where your data has merged columns, such as having too much information in one column, like “PowerBIDesktop.“ In that case, you can use Power BI’s Split Column option to divide that column into multiple columns, like “Power BI Desktop.“ In this tutorial, we will learn … read more…
Recently, I got an opportunity to work with the Now, Today, IsToday, and UTCNow functions to get the current date and time, current date without time, date format, etc. In this Power Apps tutorial, I will explore all about PowerApps now() format, PowerApps now() timezone, Power Apps today format, Power Apps today date without time, … read more…
One common task in data analysis is working with dates. Power BI Power Query provides functions for working with dates, including getting the current date and other date-related functions. In the tutorial, I will discuss Power Query Today Date in Power BI and Power Query Today Minus 7 days. Also, we will cover the topics … read more…
In this Power Apps tutorial, We will discuss the Rating control in PowerApps, its properties, and how to add a Rating control in Power Apps. As far as we know, Power Apps has various controls to work with canvas apps; apart from that, Rating control is a user interface component within the app that allows users … read more…
I recently got a task where I needed to get the first record, the last record, the first 10, and the last 10 records in Power Apps. Fortunately, Power Apps provides some functions like First, FirstN, etc., to achieve it very easily. In this Power Apps tutorial, I will explain everything about the First function in … read more…
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 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…