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 to only s...
Power Automate
Suggested Answer

Filter array to only select items where one date is later than another date

(0) ShareShare
ReportReport
Posted on by
I have a flow which does what it is supposed to do, but I'm getting warning messages that it's running too many actions and we're exceeding 80% of our capacity. So I want to filter it, so it only runs the flow on items which have been Modified since the last run. I've added a ProcessedTime column to my list which gets timestamped when the flow runs if an item in the List is updated. The list has a Modified column by default. Below is an image which shows what my flow currently looks like. The flow says it runs successfully, but it's still processing every item in the List, because every item is getting timestamped when I run the flow. Can anyone tell me what I'm doing wrong?
 
Categories:
I have the same question (0)
  • Suggested answer
    SudeepGhatakNZ Profile Picture
    14,396 Most Valuable Professional on at
    Is ProcessedTime a DateTime column?

    Assuming the logic for updating ProcessedTime has been verified, could the issue be related to inconsistent date formats? To investigate further, have you tested the Filter Query by hardcoding the ProcessedTime using the following OData filter example:

    Modified gt '2024-01-20T12:00:00Z'  
     

     
     
     

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!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 552

#2
Valantis Profile Picture

Valantis 388

#3
11manish Profile Picture

11manish 375

Last 30 days Overall leaderboard