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

Notifications

Announcements

Community site session details

Community site session details

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

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard