Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Invalid Filter Query - why?

(0) ShareShare
ReportReport
Posted on by 21
Hi,
 
I'm falling down at the first hurdle with a fairly simple PA linked to a sharepoint list. To start, all i want it to do is every Wednesday at 9am Get Items added to the list since the previous Wednesday. I've been trying to use a filter query to do this, but for
"Created ge addDays(utcNow(),-7)" and every variation I use it says "the expression is invalid".

See screenshots here. I've checked that Created is a valid column name in the back end. I've tried using ChatGPT and Google to find multiple variations of the query, I've also tried using the "Modified" date instead. I just can't figure out what I'm doing wrong here.
PA_Help1.png
PA_Help2.png

Your file is currently under scan for potential threats. Please wait while we review it for any viruses or malicious content.

  • SweatyLumpfish Profile Picture
    21 on at
    Invalid Filter Query - why?
    I had tried that formatting, and it also had returned as invalid. However, what I finally found that worked was swicthing back to the old designer and doing exactly the same thing, but using the 'advanced options' dropdowns which don't exist in the new builder.
  • Expiscornovus Profile Picture
    31,732 Most Valuable Professional on at
    Invalid Filter Query - why?
    Did you add the expression as plain text? Can you also add the single quotes around the date expression?
     
    If that is the case make sure you add it via the expression editor/fx button or use the below as a copy/paste:
    Created ge '@{addDays(utcNow(),-7)}'

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

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >