Error in Filter Array

(0) Share

Report

Posted on by ElisaArtalejo

Hello everyone,

I'm trying to filter an array extracted from an excel file but I'm getting this error:

The execution of template action 'Filter_array' failed: The evaluation of 'query' action 'where' expression '@contains(item()?['Negotiator ~1 Contact'], triggerBody()['text'])' 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'.'.

What means this error?

How can I solve this?

I have the same question (0)

All responses (4)

Answers (1)

ManishSolanki 15,089 Super User 2025 Season 2 on at

Like (0)

Report

Re: Error in Filter Array

Hi @ElisaArtalejo

Pls share the screenshot of filter condition in edit mode.

Thanks

Was this reply helpful? Yes No
ElisaArtalejo 36 on at

Like (0)

Report

Re: Error in Filter Array

sure:

@contains(item()?['Negotiator ~1 Contact'], triggerBody()['text'])
thanks for answering!

Was this reply helpful? Yes No
Verified answer

ManishSolanki 15,089 Super User 2025 Season 2 on at

Like (1)

Report

Re: Error in Filter Array

Hi @ElisaArtalejo

It looks like filter action could not read the column 'Negotiator ~1 Contact' from the excel sheet. Pls check the column name 'Negotiator ~1 Contact' in input excel sheet or share the actual column name in the source excel sheet.

Thanks

Was this reply helpful? Yes No
ManishSolanki 15,089 Super User 2025 Season 2 on at

Like (1)

Report
Re: Error in Filter Array

Hi @ElisaArtalejo,

Pls try this expression, assuming the column name is 'Negotiator ~ Contact':

@contains(item()?['Negotiator ~ Contact'], triggerBody()['text'])

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No