I have scraped a data table from a website and I’m using a For Each Row activity to iterate through each row. My issue is that I only need to iterate until the activity finds the text Trace in one column and Work In Progress in another column. How do I get the For Each Row to stop when it finds what I need? Or do I need to use something else instead?
You can use the ‘break’ activity once your condition is found. So if row.item(“column1”) = “Trace” AndAlso row.item(“column2”) = “Work In Progress” Then Break