Can we use WDL expressions (i.e. utcnow(), adddays, etc) in Filter Arrays?

[efialtes]

Hi all

I am trying to build a flow with the Recurrence trigger; the first action is Sharepoint Get Items from a Sharepoint List. I want to filter the output items and get just the ones meeting a certain condition (date comparison).

OPTION 1.- I understood ODATA filter is not available for such Action block.

OPTION 2.- I also understood a Condition Block is not valid since the output is an array, 

OPTION 3.- I implemented an Array Filter

If I use a simple expression (first example in the screenshot) the flow is compiled properly; however if I add WDL expressions to compare Date column ('Fecha') from sharepoint list with current date, a validation error is shown (second example in the screenshot, please also note part of the error text cannot be displayed).

I also tried with the ? character between item() and ['Fecha'[ with the same result.

Can we use WDL expressions (i.e. utcnow(), adddays, etc) in Filter Arrays? If so, can anybody help me find the error?

BR

[telu · Accepted solution]

Hi efialtes,

I think you can use something like this @less(item()?['LastModified'], 'adddays("2015-03-15T13:27:36Z", -20)')

espcially pay attention to the double quote " instead of single one.

I also recommend you can try simple mode instead of advanced mode first.

I created a similiar flow

Thanks,

Teng

[efialtes]

Thank you for your feedback, @telu! Now I can save the flow. The execution fails, but that's another story already reported in another thread

https://powerusers.microsoft.com/t5/Flow-Forum/Condition-problems/td-p/7495