Checking The Date In Filter Query Within Power Automate Flow

In this blog, we are going to see how to check if the due date is today.

The most important thing in the date comparison is the Date Format. If it is not matching the right date format then it will end up in error.

The SharePoint field "Due Date" has the value in "M/d/yyyy" format, so the utcNow() date should also be in the same format, only then will we be able to compare it.

Checking the Date in Filter Query within Power Automate Flow

Ex: If the date is "07/06/2021", the "MM/dd/yyyy" format will give you the result as "07/06/2021". But if the date format is set to "M/d/yyyy" you will get the date as "7/6/2021". That makes the difference.

Checking the Date in Filter Query within Power Automate Flow

The Formula in Filter Query for Due Date is equal to the current date and should be as shown below,

Checking the Date in Filter Query within Power Automate Flow

If you like this post, please do like, share, and comment.