cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

Filtering Junk email in Hotmail not working, error of 'Unable to process template language expressions..'

I'm trying to filter my Hotmail Junk email to another folder if it meets certain conditions. Sometimes it works and sometimes it doesn't. It fails many times with below error: 

 - Unable to process template language expressions for action 'Condition' at line '1' and column '21211': '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'.'.Screenshot here:

https://drive.google.com/file/d/1jmGxv-7b7yjv2YWLkNJgd5WldfB0Et8g/view?usp=sharing


This is my flow: 

https://drive.google.com/file/d/1ReX2m-y7-oX5_-aNspJKpjcHkb6_0uWD/view?usp=sharing


This shows how often it fails and succeeds: 

https://drive.google.com/file/d/1cDimvJAWwow4X135V8rnyoM5hWg-haMJ/view?usp=sharing

 

Any ideas? 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Hi @tringo007,

 

The error "The provided value is of type 'Null'" means the Email Body or subject is empty, there is no value in one of them.

You could click the time to check run details, to see if the Email Body or subject is empty. 

hot2.png

 To make the Flow could run successful no matter body or subject is empty, you could create a condition to check it if contains a value:

Screenshot 2020-10-19 131816.jpg

 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
Community Support
Community Support

Hi @tringo007,

 

The error "The provided value is of type 'Null'" means the Email Body or subject is empty, there is no value in one of them.

You could click the time to check run details, to see if the Email Body or subject is empty. 

hot2.png

 To make the Flow could run successful no matter body or subject is empty, you could create a condition to check it if contains a value:

Screenshot 2020-10-19 131816.jpg

 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Top Kudoed Authors
Users online (7,257)