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!!
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.
User | Count |
---|---|
86 | |
50 | |
35 | |
32 | |
27 |
User | Count |
---|---|
76 | |
66 | |
50 | |
46 | |
42 |