Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - General Discussion
Answered

Filter Query - Comparing two date-time columns

(0) ShareShare
ReportReport
Posted on by 7

Hello

 

I am building a workflow using get items action and there I specify the filter query as follows:

 

ColumnA ne ColumnB (both are date-time) 

 

As a result I get:

Fetching items failed. Possible invalid string in filter query. 

 

Could you tell me what time doing wrong? 

 

Thank you

  • Verified answer
    v-mengmli-msft Profile Picture
    on at
    Re: Filter Query - Comparing two date-time columns

    Hi @Wicia ,

     

    As far as I know, the filter query supports column-to-character comparisons, but not column-to-column comparisons.

    Here is a link about filter query syntax. How to Use Power Automate Filter Query [Guide With Examples] - Citizen Development Academy

     

    ————————————————————————————————————————

    If my answer helps you solve the problem, please accept it as a solution.

     

    Best regards,

    Rimmon

  • Wicia Profile Picture
    7 on at
    Re: Filter Query - Comparing two date-time columns

    Thanks 🙂 It's working. I am still wondering power automate doesn't have mechanism for comparing dates in get items query filter or I haven't discovered how to do it... 

  • Verified answer
    v-mengmli-msft Profile Picture
    on at
    Re: Filter Query - Comparing two date-time columns

    Hi @Wicia ,

     

    I recommend you use Filter array to achieve your needs.

    vmengmlimsft_0-1711024016818.png

     

     

     

    Best regards,

    Rimmon

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

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >