I don't know the cause of the Filter_array error

(0) Share

Report

Posted on by soooofunny

127

Hi, All.

I want to extract a person with the title "Manager" from the Office365 group.

For example...

Manager

General manager

Administrative Manager

It is configured like a capture, but I get an error.

The execution of template action 'Filter_array' failed: The evaluation of 'query' action 'where' expression '@contains(item()?['jobTitle'], 'Manager')' failed: 'The template language function 'contains' expects its first argument 'collection' to be a dictionary (object), an array or a string. The provided value is of type 'Null'.'.

I don't know the cause.

Thanks.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

efialttes 14,756 on at

Like (2)

Report

Hi!

I face the same limitation when using 'contains' operator in the past.

That is, if the field is empty in one of your records, condition evaluation will crash.

One potential workaround is to add an intermediate Filter Array just to remove those whose 'Job title' is null, then assign its output as your current filter array input

Hope this helps

Was this reply helpful? Yes No
soooofunny 127 on at

Like (1)

Report

Hi.

Holy crap!I didn't know that at all.
After removing the nulls first, I searched and the error no longer occurs.

Thanks!!

Was this reply helpful? Yes No