cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
efialtes
Kudo Kingpin
Kudo Kingpin

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

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

WDLvsFilterArray.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
telu
Microsoft
Microsoft

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

filter-array2.png

Thanks,

Teng

View solution in original post

2 REPLIES 2
telu
Microsoft
Microsoft

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

filter-array2.png

Thanks,

Teng

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

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (2,572)