Unanswered

Invalid Filter Query - why?

(0) Share

Report

Posted on by SweatyLumpfish

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.

Categories:

Building flows

All responses (2)

Answers (0)

Sort by

Expiscornovus 33,997 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
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)}'
SweatyLumpfish 21 on at

Like
a
(0)

Report
Copy link

Link copied!

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.