For each Data Row break at certain row/value

I have a read range activity read a column with a list of numbers and possible “#N/A”. Next I have a for each row that will cycle through each data row from the read range activity. Inside the for each loop, I want the loop to break if the current row is “#N/A” what expression do I use in the if statement condition?

Use this expression in if Statement: row(“ColumnName”).Tostring.equals(“#N/A”)

Hi @lakshman ,

I did the read range without a header, what should I put in “ColumnName”?

Then use column Index instead of ColumnName.

1 Like

Please use index of column. For example

row(0) - refers first column value

1 Like

Hi, it doesn’t seem to work. Current workflow looks like this:

Excel looks like this:
Based on this, UiPath should be displaying the message “good” 3 times before it breaks. Is there something I did wrong?

Hi @anon5199880,

As per your input, during the first 3 iterations, the condition must fails and ‘Else’ block will execute. On the third iteration, the condition satisfies and control exists the loop. If your execution doesn’t work like this, please use the condition as row(0).Tostring = "#N/A" and try again.

Warm regards,

hi @nimin,
UiPath is still displaying the message past the 3rd iteration.

Hi @anon5199880,

Could you please share the error message or output panel screenshot?

Warm regards,

Hi @nimin,
This is the 4th iteration where row should be #NA


HI @anon5199880,

Can you try the below condition in your If Condition


Let me know whether this condition grabs the value properly…

Hi @anon5199880

Just give a try with this condition once, row(0).ToString.Trim.Equals(“#N/A”)

Although, row(0).ToString.Contains(“#N/A”) should work as well…


Hi @Lahiru.Fernando and @ronak_94 ,
Both methods doesn’t work


Can you share your excel so I can check it out here?

@Lahiru.Fernando This is the file (7.7 KB)

Hi @anon5199880,

Please try by removing ‘#’ from your string in excel and condition.

Warm regards,

@nimin , Ok the process works now. However, what do I do to detect “#N/A”? The actual excel file I am running contains #N/A that I need to check for and cannot change it.

Hi, in the datatable, it actually captures the #N/A as a numeric value which is :“-2146826246”

That is because, when getting data into a datatable, it converts all the data of that column to a specific type. In your case, its numeric because first rows contain numeric values.

So try out this condition… it will work


@Lahiru.Fernando, Thanks it works now.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.