Hi,
In one of the flows, under get items I am using below filter query.
I want to fetch non completed tasks from a SP task list and along with that I have used below conditions as OR:
1. Duedate eq addDays(utcNow(),0,'yyyy-MM-dd') or
2. DueDate eq addDays(utcNow(),-1,'yyyy-MM-dd') or
3. DueDate eq addDays(utcNow(),-2,'yyyy-MM-dd') or
4. DueDate eq addDays(utcNow(),-3,'yyyy-MM-dd') or
For some reason its fetching not started and completed tasks, task status has only two options: Not started, completed. Am I using the filter query wrong? can someone help? I want to only fetch non started tasks along with date filters I listed above as OR.


Report
All responses (
Answers (