Unanswered

Action 'Filter_array' failed

(0) Share

Report

Posted on by Community Power Pla...

I was creating a flow for sending an email alert for expired documents. During the test run, the flow shows error in the filter array - failed. Please help me to take a look at the screenshot below.

Waiting for your reply on this error.

Thank You

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (0)

DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@Anonymous

Can you clarify which expression you are using?

This is what I am suggesting:
less(coalesce(item()?['ExpirationDate'], addDays(utcNow(), 1)), utcNow())

If you are sure that the Expiration date is never null, then you need to check your expression for ExpirationDate. Look back at your history, output, can you see that key name "ExpirationDate". Is the spelling correct? Have you got the path correct? Without seeing your flow it is hard to comment exactly on the cause.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here and like & subscribe to my YouTube Channel thanks 😉

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
Copy link

Link copied!

Thank you for the solution but still, it is showing an error. The Expiration date is not null. Please help me to clarify it.

Error details below
The execution of template action 'Filter_array' failed: The evaluation of 'query' action 'where' expression '@less(item()?['ExpirationDate'], less(coalesce(item()?['ExpirationDate'], addDays(utcNow(), 1), utcNow())))' failed: 'The template language function 'less' expects two parameter of matching types. The function was invoked with '1' parameter(s).'.

Thank You

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
Copy link

Link copied!

Hi @DamoBird365

Thank you for the solution but still, it is showing an error. The Expiration date is not null. Please help me to clarify it.

Error details below
The execution of template action 'Filter_array' failed: The evaluation of 'query' action 'where' expression '@less(item()?['ExpirationDate'], less(coalesce(item()?['ExpirationDate'], addDays(utcNow(), 1), utcNow())))' failed: 'The template language function 'less' expects two parameter of matching types. The function was invoked with '1' parameter(s).'.

Thank You

Was this reply helpful? Yes No
DamoBird365 8,942 Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @Anonymous

Did you expect ExpirationDate to be null? You might need to handle that scenario with Coalesce which will return the first non null iem from the list.

less( coalesce( item()?['ExpirationDate'] , adddays(utcnow(),1) ) , utcnow())

which is basically if expirydate is null use utcnow()+1

Damien

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here and like & subscribe to my YouTube Channel thanks 😉

Was this reply helpful? Yes No