Unanswered

Having Problems with null values Error :Unable to process template language expressions for action 'Condition' at line '0' and column '0': 'The template language function 'contains' expects its first argument 'collection' to be a dictionary (object), an array or a string.

(0) Share

Report

Posted on by gadama

Hi everyone,

I was recently tasked with creating a flow that will pull attachments from an outlook mailbox and place them in folders based on who the email was sent to or who was cced on the email. The flow works fine when I put my email in or anyone of my emails, but as soon as I put in one of my coworkers emails I get a null value. Any reason this would be and are there any known solutions. Attached is a basic picture of my flow. The full error message is Unable to process template language expressions for action 'Condition_1' at line '0' and column '0': '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'.'. Thank you

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (0)

DJ_Jamba 2,837 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @gadama
Could you explain this a little more?

I don't think you can have as a condition:
'To' field contains nothing
...when setting criteria for emails.

I don't think the flow will even reach the second group in the condition, but even if it did, the screenshot above is basically saying:
Filter emails where nothing is in To and CC AND filter those emails where something is in To and CC and that criteria can never be true.

The other thing I'm confused on is - the flow can only run in the context of your email account. The only way it can check your colleagues email accounts is if they all have a copy of this flow and those flows are configured under their account.

Was this reply helpful? Yes No
Ellis Karim 11,940 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @gadama ,

As @DJ_Jamba has mentioned, the condition will never evaluate to true.

For the condition at least, you could try ordering the conditions as as shown below to see if it stops the flow from stopping with an error:

Then look to address the questions raised by @DJ_Jamba .

Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site

Was this reply helpful? Yes No
gadama 4 on at

Like (0)

Report
Copy link

Link copied!

The to and cc fields are both filled out with company emails that i wasnt going to post to a public forum. When it is my email it works fine but when I put theirs in it stops working thinking maybe encryption?

Was this reply helpful? Yes No
DJ_Jamba 2,837 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @gadama

Can you throw up another screenshot and just make up the data that you omitted from your first screenshot?
e.g.
bob@bob.com
may@may.com
etc

Was this reply helpful? Yes No
gadama 4 on at

Like (0)

Report
Copy link

Link copied!

yes attached are some screenshots without the null values when the flow was working which makes me think it could be encryption. The create file section of the email assigns the email to a folder based on who it is sent to as shown example email would go in the example folder example 1 would go in example 1 and so on. When including the condition with the null values it now does not pull any of the attachments.

Was this reply helpful? Yes No
DJ_Jamba 2,837 Moderator on at

Like (0)

Report
Copy link

Link copied!

OK so first things first.
In order for any of your conditions to work, there has to be at least two emails in the To or CC fields.
Your flow runs in the context of your mailbox.
Can there ever be more than one email address in the To or CC fields? Because if there can only be one - it will always be your own email address. Checking for others is pointless

Was this reply helpful? Yes No