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.
Yesterday, someone from my team asked me whether it was possible to filter the Power Apps gallery based on multiple Combo box values. Yes, of course, achieving it is possible and very easy. In this article, I will explain how to filter Power Apps gallery based on Combo box selection along with the topics below: … Read more >>>
Recently, during a product development, I faced a scenario where I had to combine data from multiple sources into a single array. In Power Automate, merging arrays is frequently needed when dealing with dynamic content like SharePoint lists, Excel rows, or API responses. Whether you’re aggregating data for reports, combining multiple lists, or preparing JSON … Read more >>>
Last week, I was working on a Power Automate flow and came across a requirement to add data to an Excel table named ‘DataLog‘, which already had some previous data. Instead of entering the information manually every time, I thought, “Why not automate this?” The goal was to simplify the process: I wanted to set … Read more >>>
While working with Power Automate, I only needed to send an email if certain conditions were met. This is where the If condition comes in handy. It lets you check if something is true or false and, based on that, decide whether to send an email. For example, you could set up a flow to … Read more >>>
While working on a Power Automate document management flow, I got a requirement to convert Word to PDF using Power Automate. The requirement is that when a user uploads a Word file to a SharePoint document library, that specific Word file should be converted into a PDF and stored in a SharePoint document library. In … Read more >>>
Recently, I have been assigned a task to retrieve the SharePoint list items and update the list column values. In this blog post, I will explain the following examples: Power Automate Search and Update SharePoint List Item To describe this example, I have taken two SharePoint lists, ‘Leave Requests‘ and ‘Leave Balance,’ which contain various … Read more >>>
Recently, I was working on creating login forms using Power Apps, and I encountered a requirement for users to update their passwords if they forget them. During this process, the passwords stored in the SharePoint list must be updated accordingly. In this article, I will explain how to update SharePoint list items using Power Apps … Read more >>>
In my recent Power Automate project, I needed to combine two strings, Employee Name, and ID, into one string. I researched it and learned that Power Automate provides a useful function called concat() that helps to concatenate multiple strings into a single string. In this post, I will explain the Power Automate concat function, its … Read more >>>
In this tutorial, I will discuss how to convert UTC to local time zone in Power Automate. Apart from that, we will also see the three various ways to convert UTC to local time using Power Automate. Such as: Power Automate convertFromUtc() Function When working with different geographical locations globally, converting the timezone to their … Read more >>>
In my recent Power Automate project, I needed to update a SharePoint list item. After researching, I found that using the Update item action from the SharePoint connector in Power Automate allows you to automatically change specific fields, like updating a status, assigning a new owner, and more. In this tutorial, I will explain how … 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