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 Automate
Answered

Filter array of dates

(0) ShareShare
ReportReport
Posted on by 73

Hi I have an array holding a series of dates and I need to be able to filter that array to only include dates less than a specific date. At the moment I just have that date held in a variable called Test.  I've been testing this but can't seem to get it to work. The output from the filter just returns an empty value even though within the array there are dates earlier than the test date. Any ideas where I'm going wrong?

 

Picture1.png

 

Categories:
I have the same question (0)
  • VictorIvanidze Profile Picture
    13,079 on at

    Please show your "Filter array" action in edit mode.

  • WalesMariner Profile Picture
    73 on at

    Here you go Victor:

     

    Picture2.png

     

  • Verified answer
    VictorIvanidze Profile Picture
    13,079 on at

    Try to use the ticks() function both in the left and right fields.

  • WalesMariner Profile Picture
    73 on at

    That's awesome thanks Victor, I had to convert my dates into ISO 8601 Format but once I did that it worked perfectly!

  • grantjenkins Profile Picture
    11,063 Moderator on at

    Are the dates in your array able to be stored in the format yyyy/MM/dd or yyyy-MM-dd, for example: 2022/12/30 instead of 30/12/2022? Or is that the format you will get them and can't be changed?

  • WalesMariner Profile Picture
    73 on at

    Yes Grant I changed them all to the ISO format in order to get Victor's solution working. Thanks 

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 250 Super User 2026 Season 1

#2
Expiscornovus Profile Picture

Expiscornovus 222 Most Valuable Professional

#3
Haque Profile Picture

Haque 174

Last 30 days Overall leaderboard