You’re offline. This is a read only version of the page.
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.
Hi.
Holy crap!I didn't know that at all.
After removing the nulls first, I searched and the error no longer occurs.
Thanks!!
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
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
Share
Report
All responses (
Answers (
