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.
Solved! Go to 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
Proud to be a Flownaut!
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
Proud to be a Flownaut!
Hi.
Holy crap!I didn't know that at all.
After removing the nulls first, I searched and the error no longer occurs.
Thanks!!
User | Count |
---|---|
92 | |
44 | |
21 | |
17 | |
16 |
User | Count |
---|---|
136 | |
49 | |
42 | |
36 | |
28 |