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.
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
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?
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'))))
User | Count |
---|---|
34 | |
15 | |
14 | |
13 | |
9 |
User | Count |
---|---|
42 | |
30 | |
26 | |
14 | |
12 |