Erro: There is no row at position 2

[lourena.coutinho]

I have a table, which has 10 rows, but that table contains a few empty lines, so it includes a filter for when entering For each the robot is not checking for empty lines.

But now an error is occurring, because as the table has a filter the robot cannot find line 2, how can I do to eliminate this error? Or do I need to remove the filter for it to work perfectly?

[KM1996 (Kavita)]

Hi @lourena.coutinho, have you tried removing the filter? And can you post a screenshot of the workflow?
Thanks!

[Nithinkrishna]

Please make sure you have checked UseFilter option in Excel Read Range

[lourena.coutinho]

So I scored and even then the error continues.

My workflow:

[Nithinkrishna]

1. Are you using filter in excel sheet or only the filter activity ?

2. In the assign activities, you don’t want to traverse through the data table instead you can just use the row object in the for each.

[lourena.coutinho]

Excel sheet

I’m sorry, but I don’t understand the second point.

don’t i need to have an accountant in the formula?

[Nithinkrishna]

No problem, It will be easier if you can share your xaml file please.

[lourena.coutinho]

I had two for each, I don’t know why, but now it works. Thank’s for your time.