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 / Filter Array by date i...
Power Automate
Answered

Filter Array by date is filtering out too many results

(0) ShareShare
ReportReport
Posted on by 17

Hello,

 

Tried to fix this for a while but can't figure out where I'm going wrong - I want to filter by a date column to return only dates that are on or before 2 weeks ago. The following is what filter I'm using and what my outputs are - it looks like the filter is excluding rows that it should be including? This is following a 'list rows present in a table' function. 

 

MSP38471_0-1661182283091.pngMSP38471_1-1661182289480.pngMSP38471_2-1661182298449.png

The inputs say that RefEmailDate for that row was 44720 (8th June 2022), which is well over 2 weeks before today (22nd August 2022), but still there are no outputs? 

 

I feel like it must be something obvious but just can't work it out!

 

Thanks in advance

Categories:
  • Verified answer
    Hardesh15 Profile Picture
    7,087 Super User 2024 Season 1 on at

    @MSP38471 Pls change date format in list row present in a table as ISO format.

    Also make both side date format equal.

    adddays(utcnow(),14,'yyyy-MM-dd')

    Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

    @Hardesh /Gopenly.in

  • MSP38471 Profile Picture
    17 on at

    Yes! This works if you do all of the above - the date formats were in as 'dd-MM-yy' but changing to ISO and changing all date formats to 'yyyy-MM-dd' fixes the problem. Thank you!

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 299

#2
11manish Profile Picture

11manish 274 Super User 2026 Season 2

#3
Henil Profile Picture

Henil 119

Last 30 days Overall leaderboard