Showing results for 
Search instead for 
Did you mean: 
0 Kudos

Contains function should accept null

I'm trying to search for a certain phrase in the Notes field, but the flow fails if the Notes field is empty. Its logic: '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'.'.


It seems to me that, fundamentally, 'contains' should be able to accept a null value, and simply always return False. I shouldn't need to nest the condition in another one checking to see if the Notes field contains a null object.

Status: New
Advocate III

I can get around the issue using coalesce(), but I'm a programmer. Flow isn't in general designed for that to be necessary.