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.
When dealing with a large amount of data in Power Automate, it is unable to fetch all the records from the SharePoint list. With the Power Automate get items filter query option, we can easily filter out the data based on our requirements. In this article, I will explain how to use Power Automate get … 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 >>>
Recently, I got a requirement to count the rows and columns of an Excel sheet by using Power Automate Desktop. In this tutorial, I will show you how you can count the total number of rows and columns present in an Excel worksheet using Power Automate Desktop. I will also show you how to get … Read more >>>
I recently worked on a Power Automate desktop flow for a client. We then received a requirement to export and import those desktop flows to another environment. In the Power Automate desktop app, there is no direct option to export and import desktop flows. To achieve this, you need to follow the approach mentioned below: … Read more >>>
Many organizations use SharePoint for collaboration, document management, and team productivity. One of its key features is the ability to share content not just within your organization, but also with people outside it—commonly referred to as “external sharing.” In this tutorial, I will explain how to share a SharePoint site with external users. You will … Read more >>>
While working on a client’s requirement, I was assigned a task to extract the file name from the file path that is stored locally on the desktop. This is similar to getting a substring from a string in Power Automate Desktop. Power Automate desktop provides a set of text functions that enable you to perform … Read more >>>
Recently, I worked on a Power Automate flow that required sending a report to a manager on a monthly basis. The report should only include items with the status “New” from a SharePoint list. To do this, I used the Filter Array action in Power Automate. The Filter Array action in Power Automate is particularly … Read more >>>
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 >>>
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