Filter array data with date condition not working without ticks

[maheshkhisteLiv]

In filter array data i was using  condition with 2 dates coming from dynamic values but seems like filter array wasn;t honoring it after

lot of tries when i tried with ticks conversation it started working (returning correct results). Seems to be a bug in Flow action.

[v-yuazh-msft]

Hi @ maheshkhisteLiv,

Could you please share a screenshot of the configuration of your flow?

Could you please explain more about the "filter array wasn;t honoring it after lot of tries when i tried with ticks conversation" that you mentioned?

Do you mean the filter array wouldn't work when you use condition with 2 dates coming from dynamic values? could you please explain more about the "ticks conversation"?

I have made a test on my side,and I have create a sharepoint list with two date type column as below:

The screenshot of the flow as below:

The flow would run successfully as below:

Regards,
Alice Zhang

[bqkelley]

I might be having the same/similar issue. I am trying to use filter array to pull items from a sharepoint list if the column "Beginning Date" is within the past 15 days. Here's the code I put into the filter array:

@and(greater(item()?['Beginning_x0020_Date'], getPastTime(15, 'day', 'f')),lesser(item()?['Beginning_x0020_Date'], utcnow()))

The flow is running smoothly but the filter array output is blank:

[ ]

Through a manual check of the list there are 7 items which should have met this criteria. Is there a glitch or am I doing something wrong?

[bqkelley]

However, converting the dates to ticks works:

@and(greater(ticks(item()?['Beginning_x0020_Date']), ticks(getPastTime(365, 'day', 'yyyy-MM-ddThh:mm:ss'))),less(ticks(item()?['Beginning_x0020_Date']), ticks(getPastTime(7, 'day', 'yyyy-MM-ddThh:mm:ss'))))