
Announcements
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.
Hi @Anonymous
Could you please explain more details about the Status column in your list? Is it a choice type column?
If the Status column is a choice type column, you couldn't filter the items in the Filter Query field in the Get items action, you need to add a Filter Array action under the Get items action for filter the items that Not started as screenshot below:
Also please make sure to choose the Status Value dynamic content instead of the Status dynamic content in the Filter Array action.
Best regards,
Alice
Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.