I have in excel cell with string value “Red”. Cell value is read to string variable “CarColor” in Get Cell Value Action.
In If Action first operand variable is “CarColor”, comparison operand is “Equals” and Second operator is “Red”.
If Action should execute Then block, but it always executes Else block.
I checked “CarColor” variable in Notepad window and it gets typed “Red”. I even used Trim Whitespace in variable, but it didn’t made any difference.
Is it possible that Get Cell Value action takes some hidden characters or what might be reason that in If Action “CarColor” = “Red” is not true?