Long search and finally an answer to the NULL record in MS FLOW and Sharepoint

 Situation: 

SHAREPOINT (sharepoint) list has rows of record where a string value type is blank. This is treated as a NULL when the sharepoint is connected to the MS FLOW or PowerBI.

MS FLOW ISSUE

You wish to test a condition for these with MS FLOW and this fails.  error similar to "Unable to process template language expressions for action 'Condition' at line '1' and column '16370': '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 WORKED:

Then Create the Condition:

The leftside has the empty(function with the output of the compose) this you pick from the Dynamic Content.

The right side will be tested for "word - True or False"

Test and see!