During various SharePoint implementations, we often needed to filter array items by date in Power Automate. Recently, while working on a “Project Management System” in SharePoint for one of our clients, I was required to filter SharePoint list items based on Project Start Dates and End Dates. In this tutorial, I will explain how to … Read more >>>
Nowadays, I am working with an array in Power Automate. So, doing a bit more research on this. In today’s tutorial, I will explain how to filter an array by multiple conditions in Power Automate. We will use the same filter array action in Power Automate. Here, I will also show you two different examples: … Read more >>>
One of my team members asked about filtering an array by Index in Power Automate. Unfortunately, Power Automate does not have a built-in option to get the index of an item within an array. But there are ways to do this. In this tutorial, I will show you how to filter an array by index … Read more >>>
Recently, I was working on a Power Apps application named Expense Claims App. I had a requirement to create a Power Automate flow that filters files in a SharePoint document library containing a specific substring. For example, if the file name is “Customer Invoice Details.docx”. I wanted to filter based on a substring, i.e, “Invoice”. … Read more >>>
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 >>>
Learn how to automatically create a SharePoint Online list and all its columns from an Excel file using Power Automate—without using any Premium connectors.
📅 4th AUG 2026 – 10:00 AM EST | 7:30 PM IST
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…