The most recently updated SharePoint, Power Apps, Power Automate and Power BI tutorials from EnjoySharePoint. Every tutorial is tested in a real Microsoft 365 tenant.
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 >>>
You can use the @ symbol to manually mention users in a Teams message. By using Power Automate flow, you can also mention multiple users in a team channel. In this tutorial, I will show you how to tag multiple users in a Teams message using Power Automate. Tag Multiple Users in Teams Message using … 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 >>>
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 >>>
I was recently working on string manipulations in Power Automate, where we wanted to replace apostrophes with double quotes. You can do it easily. In this tutorial, I will show you how to replace an apostrophe character in a string in Power Automate. Additionally, I will cover the following examples. Replace Apostrophe in String Variable … 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 >>>
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 >>>
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 >>>
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 >>>
122 copy-paste formulas with real examples, sent straight to your inbox.
Your free Power Automate Expressions Cheat Sheet is on its way. Can't find it in a few minutes? Look in your Promotions or Spam folder.
Sent to