web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Using filter query to ...
Power Automate
Answered

Using filter query to compare dates

(0) ShareShare
ReportReport
Posted on by 212

Hi, I'm having an issue where my flow is always true in my flow, hence adding an item to my SP list. The issue I believe is my filter query. My date field which you can see below is in the form of, 'M-d-yyyy', and I'm comparing it to utcNow('M-d-yyyy'). Which I believe is using minutes and seconds as well (which would always be greater than my most recent SP item submission). Does anyone know how I could fix this? I only want the filter query to be true if the work area == 'Front Office' AND the Date (in 'M-d-yyyy' format) is less than today's date (in 'M-d-yyyy' format). Below is how my flow looks like now, and a pic of my SP Date column format.

Thank you,

JBennett12_0-1660657976314.png

 

JBennett12_1-1660657376838.png

 

Categories:
I have the same question (0)
  • Verified answer
    David- Profile Picture
    1,254 on at

    Filter queries use the ISO 8610 date format and not the date format selected at the site or user profile level. The ISO format is yyyy-MM-dd. Update your expression for the utcNow() date to the following and it should work:

     

     

    formatDateTime(utcNow(),'yyyy-MM-dd')

     

     

     

  • JBennett12 Profile Picture
    212 on at

    @David- 

    Thank you, that worked.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 262 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 227

#3
Expiscornovus Profile Picture

Expiscornovus 225 Most Valuable Professional

Last 30 days Overall leaderboard