I created a WHILE activity.
The conditions are
Inside the WHILE activity, there is an Excel activity that reads cells of column B one by one inside a sheet.
When the cell is either empty or has the word TOTAL, sequence should end.
If I leave the condition
it works very well. If it finds a blank cell, it ends the sequence and goes to another part of the flow (not inside the scope of this thread)
But if there is no blank cell, it reads and copies the cell with TOTAL and any cell coming after it.
So another condition to end the sequence is finding the word TOTAL.
So… how to have a condition that if the cell has the word TOTAL, sequence will end, without casuing me an error if it finds a blank cell?