If a list returns blank will it assign blank

[Austin]

I have an action that is going to set
[Field1]=ANY(SELECT(TABLE2[FIELD2], MATCH CONDITIONS)-[FIELD1]). The purpose of the action is to re-assign a persons current job if their current job is finished. Will this action fail if the any returns blank or will it assign [Field1] to blank? Or do I need an if isblank()?

[Steve · Accepted solution]

It will not fail; it will set Field1 to blank.