Power Platform Community Forum Thread Details

Hello Experts,

I have a sharepoint and I need pull items with below conditions

Not being modified in the last 7 days

DWP Lead Assigned (Person or Group column) should not be empty/null

Progress should not be ('New - awaiting triage' or 'On hold' or 'Engagement closed - full rollout' or 'Engagement closed - decision to NOT proceed' or 'Engagement closed - customer decision to NOT proceed')

I am using the below filter but it does not pull the right count of items - meaning it should pull only 19 items (manaully checked) but the flow is pulling 100+ items which is wrong.

(Modified le 'addDays(utcNow(), -7, 'yyyy-MM-dd')')(Status ne 'New - awaiting triage') and (Status ne 'On hold') and (Status ne 'Engagement closed - full rollout') and (Status ne 'Engagement closed - Atos decision to NOT proceed') and (Status ne 'Engagement closed - customer decision to NOT proceed') and (DWP_x0020_Lead_x0020_Consultant_ ne '@{null}')

Please guide me

Here is the list information for referrence.