How to Compare Date Using Ticks Function in Power Automate?

How to compare dates in Power Automate using ticks

I ran into an unexpected issue while working on a Power Automate flow. I needed to compare two dates: today’s date and a date five days in the future. I used the formatDateTime() function to format the dates, but when I applied the condition to check if today’s date was greater than today + 5 … Read more >>>

How to Replace Commas With New Lines in Power Automate

Replace Commas with New Lines in Power Automate in Variable

While working on a project named Employee Satisfaction Survey, I encountered a requirement to replace commas with new lines in Power Automate. Initially, I thought this could be easily achieved using the replace() function, which follows this format: However, when I tried using \n, char(10), or even HTML <br> tags as the newText Value, they … Read more >>>

How to Extract Number From String in Power Automate?

How to Extract Number from String using Power Automate

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 >>>

How to Convert String to Integer in Power Automate?

INT Function in Power Automate

Recently, while working on a Power Automate Flow to generate a PDF from SharePoint list items, I encountered a challenge: some numerical values stored in my SharePoint list were in text format instead of numbers. This became a problem when I needed to perform calculations, as Power Automate treats string values differently from integers. If … Read more >>>

2 Various Ways to Format Number as Currency in Power Automate

Format Number as Currency in Power Automate

Recently, while working on a Power Automate Flow to Generate a PDF from SharePoint List Items, I encountered a challenge formatting number as currency. The default number formatting didn’t quite meet the requirements, so I researched and found a few practical ways to achieve this. In this tutorial, I will tell you how to format … Read more >>>

Power Automate IF Expression – How to Use

Power Automate if expression equals

In this article, I will explain how the Power Automate IF expression works along with below-mentioned examples: Power Automate IF Function Expression Power Automate If condition is one of the most commonly used expressions in Power Automate flows. The If expression checks whether a given condition is valid. Syntax: Power Automate If Expression Examples Now, I will … Read more >>>

How to Save Email Attachment to SharePoint Using Power Automate?

Save Email Attachment to SharePoint using Power Automate

While working on a Power Automate, I needed to save email attachments directly to a SharePoint document library. The team wanted a simple way to keep all important files from emails in one place without manually downloading and uploading them. Handling multiple emails daily made this process time-consuming, so I used Power Automate to automate … Read more >>>

How to Retrieve SharePoint List Items Using Power Automate?

Power Automate get single item from SharePoint list

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 >>>

>

Build a High-Performance Project Management Site in SharePoint Online

User registration Power Apps canvas app

DOWNLOAD USER REGISTRATION POWER APPS CANVAS APP

Download a fully functional Power Apps Canvas App (with Power Automate): User Registration App

Power Platform Tutorial FREE PDF Download

FREE Power Platform Tutorial PDF

Download 135 Pages FREE PDF on Microsoft Power Platform Tutorial. Learn Now…