You’re offline. This is a read only version of the page.
68
Hi all,
I'm trying to build a workflow where a property gets updated for the items that meet a certain criteria. The current workflow is as below, however, when I test it there is an error in the get items action.
I have a Filter Query advanced parameter with the following lines of code:
"Status eq 'Deployed' and LastModified lt addDays(utcNow(), -30) and Certification ne 'New Application'"
I have replaced the internal names of the columns here, but they are accurate. I get the following error in the Get Items 2 action when I test it:
"The query is not valid."
Can I modify the filter query or should I use conditions instead?
Hi @KL007
Pls try the below filter query:
Share
Report
All responses (
Answers (
Status eq 'Deployed' and Modified lt '@{addDays(utcNow(), -30)}' and Certification ne 'New Application
just copy-paste the above query in 'Filter query' text box.
If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.
