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.

Categories:

Building flows

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.

I have the same question (0)

All responses (2)

Answers (0)

Expiscornovus 33,195 Most Valuable Professional on at

Like (1)

Report
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)}'

Was this reply helpful? Yes No
SweatyLumpfish 21 on at

Like (0)

Report

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.

Was this reply helpful? Yes No