Announcements
Hi,
There is error with Filter Query, can you help how to correct this formula?
The output of the variable is "addDays(utcNow(),-30,'YYYY-MM-DD')"
Use gt instead of > in your oData query.
Hi Sudeep,
Tried but still error.
Hi @YanLiang
1. The filter query of List rows present in a table does not support column names with spaces.Please change Start Date to StartDate.2.AND is in lowercase (and)3. Use single quotes around variables.
Best Regards,
Levi
Hello Levi,
Thanks, but still error.
Have a look at thishttps://learn.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#and
I'm sorry this was an oversight on my part.The filter query of List rows present in a table does not support some filtering methods such as greater than and so on (by design).I suggest you use the Filter array action.
@YanLiang ,
Date format in your variable expression is incorrect. Try
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Vish WR 632
Haque 458
Valantis 357
