While working with Power Automate, I recently encountered a scenario where I needed to calculate the last working day of a month. This is particularly useful for generating monthly reports, scheduling reminders, or automating month-end processes. In this tutorial, I will explain how to calculate the last working day of a month using Power Automate. … Read more >>>
While developing a client requirement, I struggled to create items manually in a SharePoint list because I wanted large data sets. After researching, I found that we can create a single or multiple items in a SharePoint list using Power Automate. In this article, I will tell you how to create SharePoint list items using … Read more >>>
Recently, while working with our client on the Project Management portal, I was assigned to validate the SharePoint date and time column so that weekends are selected instead of weekdays. This can be achieved by using the WEEKDAY() function in SharePoint. In this tutorial, I will explain the functionality and syntax of the SharePoint WEEKDAY() … Read more >>>
While working on an Employee Leave Request App application, I had to delete the empty folders in the document library using Power Automate. Unfortunately, the Delete folder action is not present in Power Automate. After some research, I found two ways to delete a folder in the SharePoint document library using Power Automate. Such as: In this … Read more >>>
When working with files in Power Automate, sometimes the trigger or previous actions only provide metadata like the file’s full path, display name, or unique identifier but not the actual content. However, we need the file content to process or use the file further (such as sending it in an email or saving it to … Read more >>>
While working on Power Automate flows, you can use the If() expression to validate the condition in a single line instead of taking multiple conditional branches. In this tutorial, I will describe how to use the Power Automate If contains expressions with a few examples. Power Automate If Contains Text I will show you how … Read more >>>
I recently worked for a client who told me to create a flow for a leave request application where they wanted to send approval requests to multiple approvers. Yes, we can do that. Then, another requirement came up: we needed to send the requests to multiple approvers via both Outlook and Teams using Power Automate. … Read more >>>
Recently, while working on a Power Automate project, I faced a requirement to extract numbers from a string. This came up when dealing with a SharePoint list where some fields contained a mix of text and numbers, and I only needed the numeric values. After researching and testing different approaches, I found an effective way … Read more >>>
Last week, while working with a client, I got an interesting requirement: they needed to check if a string contained any numbers in Power Automate. At first, it seemed like a simple task, but as I explored different approaches, I found two interesting ways to achieve this. In this tutorial, I will tell you how … Read more >>>
A few days before, I was required to send an email containing project names and serial numbers. To achieve this, I used the range() function in Power Automate, which generates an array of integers. In this tutorial, I will explain how to provide a sequential serial number for a list of SharePoint items using 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