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.
I was recently working with the Replace() function in Power Automate, which allows us to replace characters, substrings, or strings in arrays, multiple objects in JSON format, and more. In this article, I will explain how to replace special characters from a string in Power Automate with the following examples. Replace a Single Special Character … Read more >>>
One of my colleagues asked me to assist with replacing text in a text file stored in a SharePoint document library, so that he can send an email with the updated document file to the client. We can achieve this by using the replace() function in Power Automate. In this tutorial, I will explain how … Read more >>>
A few days ago, I worked with a client who wanted me to design a Project Management system using SharePoint lists, libraries, and site pages. The client will receive the project-related files as attachments in their Outlook, which will be saved to the SharePoint document library. The requirement here was: whenever a new email with … Read more >>>
A few days ago, I worked with a client to develop a Project Management system utilizing SharePoint lists, libraries, and site pages. The client requires JSON data for each project, and based on the project status, I want to update the Project priority value: replace ‘Low’ with ‘High’ if the status is ‘In Progress’. In … Read more >>>
I was recently working on the Filter Array in Power Automate, where we can filter the items in the array by using different types of operators in the Filter Array action. This tutorial explains how to use filter query operators in the Filter Array action of Power Automate. Here we will see the following examples: … Read more >>>
Today, I will discuss an interesting example, and it is about filtering an array by another array in Power Automate. In this tutorial, I will show you how to filter an array with another array using the Power Automate Filter array action. You can learn two different examples here, such as: Filter an Array with … Read more >>>
A few days ago, one of my team members asked me to reverse an array using Power Automate. I used the Power Automate reverse() function, which changes the arrangement of array elements in reverse order. In this tutorial, I will explain how to reverse an array in Power Automate and show how to reverse an … Read more >>>
As a Power Platform developer, you might be required to use the replace function in Power Automate. This is very common in most real-world use cases. So, I thought to explain the Power Automate replace expression. In this tutorial, I will explain the Power Automate replace() function, focusing on its practical application in real-world examples. … Read more >>>
Recently, I have worked with the Leave Approval Process system, which enables employees to submit their requests through Microsoft Forms, and the responses are stored in a SharePoint list. Microsoft Forms has an Email field, where I need to save emails to a SharePoint list. Here, I faced an Issue: The data is coming in … Read more >>>
Recently, I got a requirement to save Microsoft Forms responses to Excel Online automatically. In this tutorial, I will explain how to save Microsoft Forms responses to Excel Online using Power Automate. Save Microsoft Forms Responses to Excel Online using Power Automate Here, you can see in the screenshot below that I have a Microsoft … 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