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.
Recently, I was working on a Power BI matrix visual for a client. They wanted to calculate the percentage of the total in the Matrix visual. The client had sales data for various products like laptops, keyboards, mouse, and monitors. They wanted a Power BI report that not only showed the sales values but also … Read more >>>
When you create a new SharePoint list, a Title column appears by default. In many cases, this column doesn’t match your actual data structure, especially if you’re using fields like Project Name, Task, or Customer ID. In this type of case, we need to rename the title column in the SharePoint Online list. In this … 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 >>>
For a few days, I have been working on the Replace() function in Power Automate, which allows replacing characters in a string, substrings within a string, strings within an array, and strings within a JSON array, as well as multiple objects within an array. This tutorial explains how to replace the last character of a … Read more >>>
One of our clients contacted us regarding a requirement where they had an Excel file containing project details and associated company information for 2025, which is stored on their local desktop. The requirement is to replace one of the Associated Company names in the Excel sheet, as it has recently changed its name. We can achieve … Read more >>>
Are you trying to replace a double quote with a single quote using Power Automate? I will help you with this. In this tutorial, I will explain how to replace double quotes with single quotes using Power Automate. Replace Double Quote with Single Quote using Power Automate To explain this example, I will manually take … Read more >>>
Are you trying to replace newlines in a string with <br> tags using Power Automate? Unfortunately, Power Automate does not allow you to process new line characters using the replace function, which is a non-printable character. When trying to replace the ‘\n’, which represents a new line, the replace function will consider it as a … Read more >>>
A few days ago, I worked on a flow that required creating multiple SharePoint lists and libraries automatically from a single JSON file. Instead of creating each one manually, I used Power Automate to read the JSON and create the SharePoint lists. In this Power Automate tutorial, I will show you how to create SharePoint … Read more >>>
SharePoint is a powerful platform by Microsoft used by organizations worldwide to store, organize, share, and collaborate on information. One of its most essential features is the Document Library. In this tutorial, I will explain everything you need to know about SharePoint Document Libraries: what they are, how they work, how to create them, real-world … Read more >>>
When you upload a file with spaces into a SharePoint document library, the file URL will be created, where the spaces are stored as %20. For example: If there is a file ‘Guidelines for Project Meet Ups’-> the URL will be saved as ‘Guidelines%20for%20Project%20Meet%20Ups. You can replace the file name with underscores, so that the … 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