I have created a bot that looks for line numbers in a certain column and deletes all rows that do not contain a %LineNumber% variable. It does this by scanning through all the rows, and adding the row numbers that do not contain %LineNumber% or 0 (as we want to preserve formulae) to a list, before reversing the list and finally looping through the list to delete rows. Problem is, the actual deletion of the rows takes a long time, seemingly because excel takes a while to actually delete the row. Is there anyway I can speed up this process? My flow runs at 1ms already.
