Skip to main content

Notifications

Power Automate - Building Flows
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?
 
  • Suggested answer
    SudeepGhatakNZ Profile Picture
    SudeepGhatakNZ 14,231 on at
    Filter array to only select items where one date is later than another date
    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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,580

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,909

Leaderboard