Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / Filter Query Current Date
Power Automate - Building Flows
Answered

Filter Query Current Date

(0) ShareShare
ReportReport
Posted on by mayarnaldo 92

Hi,

 

I want to filter an item created today. But I got an error that the expression is not valid. 

 

date.jpg

Any help is appreciated! 🙂

 

 

Regards,

May

 

  • mayarnaldo Profile Picture
    mayarnaldo 92 on at
    Re: Filter Query Current Date

    Hi,

     

    It works! Thank you! 🙂

  • Verified answer
    abm abm Profile Picture
    abm abm 32,506 Most Valuable Professional on at
    Re: Filter Query Current Date

    Hi @mayarnaldo 

     

    Please try this

     

    image.png

     

    The above expressions are

     

    formatDateTime(utcNow(),'yyyy-MM-dd 00:00')
     
    formatDateTime(utcNow(),'yyyy-MM-dd 23:59')
     
    Thanks
  • abm abm Profile Picture
    abm abm 32,506 Most Valuable Professional on at
    Re: Filter Query Current Date

    Hi @mayarnaldo 

     

    Try to formatDateTime expression to yyyy-MM-dd format. Also if you looking for todays date then you may need to look between yyyy-MM-dd 00:00 and yyyy-MM-dd 23:59.

     

    Also you need to use single quotes around the expressions

     

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

    formatDateTime(utcNow(), 'yyyy-MM-dd 23:59')

     

     

     

     

     

     

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

News and Announcements

Now Available: 2025 Release Wave 2
Welcome to the Power Platform Communities

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June 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 > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans