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?
Hi @lourena.coutinho, have you tried removing the filter? And can you post a screenshot of the workflow?
Thanks!
Are you using filter in excel sheet or only the filter activity ?
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.
Excel sheet
I’m sorry, but I don’t understand the second point.
don’t i need to have an accountant in the formula?
No problem, It will be easier if you can share your xaml file please.
I had two for each, I don’t know why, but now it works. Thank’s for your time.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
