If column contains a specific value then

Im working with excel spreadsheet where I have filtered column “SR Status”. Then read range the same column name. Then I want to state that If for each row in column “SR Status” is equal to New, Open or Pending then follow the workflow. But getting error → Input string was not in a correct format.

image


image
image

error file attached
stringinputerror.txt (2.5 KB)

Could you please help explain where I went wrong?

  1. No need for using ReadRange activitiy before ForEachExcelRow. Just remove it. ForEachExcelRow knows how to read data from Excel directly
  2. ForEachExcelRow should run on whole range/sheet. Don’t sub-select the column only.

This being said, we will try to reproduce the issue, to fully understand why selecting the column triggers the error in the first place.