Preeti Sahu 
While testing a Power Apps Survey form, I noticed an issue where the Person combo box control allows users to select external guests (from Office 365 AD) when submitting the form. And then I realised that it’s not the correct approach, where someone can accidentally pick any guest user and submit the form. To overcome … Read more >>>
Recently, I was working on a Power BI report for a client. The report is based on the ‘Product Sales and Profits’. As one of their requirements was to view the profit of different product categories each year, which should show the category with the highest profits, and also the category with the lowest profits. … Read more >>>
A client recently reached out with a requirement in Power Automate Desktop. They needed to upload an Excel file containing employee details from their local system to a SharePoint document library, along with the associated metadata. Additionally, they wanted the entire process to be automated using Power Automate Desktop. In this tutorial, I will explain … Read more >>>
Recently, I created a Power BI report using various visualizations, such as a Pie chart, Table, Card, Matrix, and Line chart, as well as Slicers, etc. In that report, I had two slicers: ‘Product Sales’ slicer that has fields such as (Month Name, Product & Profit)and ‘Month Name’ slicer, as shown in the image below. Now, I … Read more >>>
A few days ago, I worked with a client to design a Modern SharePoint site page for their Human Resources Department. One of their requirements is to display the different types of list views based on the budget allocated for the specific policies on the site page. To enhance the SharePoint site page‘s attractiveness, I … Read more >>>
A client has reached out to us regarding one of his requirements for tracking ‘Project Management’ details on the SharePoint site. They wanted us to design a custom SharePoint list form layout, including different types of list views with project status to be displayed on the SharePoint site page, as well as a Gantt chart view of … Read more >>>
I was recently working on a Power Platform project for a client who assigned me a task to replace multiple strings in a variable that stores a string. Power Automate has a replace() function that allows you to replace strings, substrings, characters, and array objects. This tutorial will guide you on how to replace multiple … Read more >>>
I recently worked on a SharePoint project where I was required to calculate the average value in a SharePoint list. I will also explain the average() function in SharePoint Online. Here, I will show you two different examples: Average() Function in SharePoint The average() function in SharePoint calculates the sum of all column items divided … Read more >>>
I got a requirement from my client to extract email from a SharePoint person or group field. You can do this using JSON in SharePoint. In this tutorial, I will explain how to use JSON to retrieve an email address from a person or group field in a SharePoint Online list. To extract the email … Read more >>>
Recently, while working on one of the client’s requirements, I encountered a problem adding the lookup column value to the JSON Code while formatting the SharePoint list. So, I thought I would share my experience in this blog post. In this tutorial, I will explain how to add a lookup value to the SharePoint column … Read more >>>
Download a fully functional Power Apps Canvas App (with Power Automate): User Registration App
Download 135 Pages FREE PDF on Microsoft Power Platform Tutorial. Learn Now…