web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate
Unanswered

Get Items Query

(0) ShareShare
ReportReport
Posted on by 5,323 Super User 2025 Season 2

Will the below return ONLY both status identified that are seven or more days old?

Get Items Filter Query -
(Status eq 'string('Minutes Approved') or (Status eq 'Minutes Pending') and (Modified le addToTime(utcNow(),-7,'Days','yyyy-MM-dd')

Categories:
I have the same question (0)
  • v-chengfen-msft Profile Picture
    on at
    Re: Get Items Query

    Hi @Phineas ,

    Please try:

    (Status eq 'Minutes Approved' or Status eq 'Minutes Pending') and Modified le '@{addToTime(utcNow(),-7,'Day','yyyy-MM-dd')}'

     

    vchengfenmsft_1-1679538263654.png

     

    vchengfenmsft_0-1679538226947.png

     

    Best Regards

    Cheng Feng

     

  • Phineas Profile Picture
    5,323 Super User 2025 Season 2 on at
    Re: Get Items Query

    Are the brackets and the @ symbol required? I seem them in the written (text) version of your suggestion -

    Modified le '@{addToTime(utcNow(),-7,'Day','yyyy-MM-dd')}'

    I don't see them in the function version.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 497 Moderator

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 477 Super User 2025 Season 2

#3
chiaraalina Profile Picture

chiaraalina 242

Last 30 days Overall leaderboard