I don't know the cause of the Filter_array error

[soooofunny]

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.

[efialttes · Accepted solution]

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

[soooofunny]

Hi.

Holy crap!I didn't know that at all.

After removing the nulls first, I searched and the error no longer occurs.

Thanks!!