Recently, I have been working with Power Automate Desktop, where I got a requirement from one of our clients who wanted to share the Project Details Excel file with his manager via email in a tabular format. However, unfortunately, Power Automate Desktop does not allow Excel tables in emails, so we need to add the … Read more >>>
Recently, I got a requirement to update SharePoint list items from an Excel file using Power Automate. The client had an Excel file and wanted to update these records in a SharePoint Online list. In this tutorial, I will explain how to update SharePoint list items from an Excel spreadsheet using Power Automate. Update SharePoint … Read more >>>
One of my clients asked us to update items in a data table using Power Automate Desktop. It is easy to update the value of a single item. Still, when dealing with multiple items in a data table, there is no direct way to retrieve the row index of a data table that updates the … Read more >>>
One of my clients requested to extract data from a web part to an Excel file using Power Automate Desktop. In this tutorial, I will explain how to extract data from any web page using Power Automate Desktop with two different examples. Extract Data from a Web Page using Power Automate Desktop I wanted to … Read more >>>
You can insert a row or a column in an Excel sheet that is present in your local system by using Power Automate desktop. In this tutorial, I will cover the way to insert a new column as well as a new row in an Excel worksheet using Power Automate desktop. Insert Column to Excel … 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, I worked on a SharePoint project where I needed to split and replace the text string values present in a SharePoint list column. We can achieve this using a SharePoint calculated column. This SharePoint tutorial explains how to split strings using a SharePoint calculated column with different text functions, such as: I will also show … Read more >>>
Are you trying to create a hyperlink in SharePoint? Maybe using a SharePoint calculated column. Microsoft officially does not support and blocks the execution of HTML markup in SharePoint calculated fields. Alternatively, you can use JSON Formatting to make the hyperlink clickable as a solution for this requirement. In this tutorial, I will guide you … Read more >>>
Over the past few months, we have developed several helpful apps in Power Apps, including Leave Management, Travel Requests, and User Login. I wanted to display all of them in one place, and cleanly. So, I created a gallery that scrolls automatically and displays each app one by one in a Power Apps canvas app. … 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…