cancel
Showing results for 
Search instead for 
Did you mean: 
0 Kudos

PAD: Better solution needed for look at excel values in range and delete rows where there is a match.

Power Automate Desktop: Better solution needed for look at excel values in range and delete rows where there is a match.

 

After finding a range, you would think that you could create a For Each current item and include an if then condition where if a value present then that current item will be deleted by using "Delete Row from excel worksheet" .

Unfortunately, Delete Row from excel worksheet does not work that way. It does not auto track the remaining range of rows for further interrogation properly. 

 

1st issue: Delete Row from Excel is looking at the worksheet and deleting literal rows without looking at range defined. So wrong row is getting deleted. So the iteration of for each and the range row count being interrogated is not correlating to the delete function row.

2nd issue: After a row is deleted, the literal rows in excel just changed and is not aligned with the for each loop of current items. 

 

This creates a lot of unnecessary work to get this to function properly.

 

Delete Row from Excel worksheet should behave more like Delete row from range in Excel worksheet.

 

Unnecessary work below:

 

r96359_0-1628518336144.png

 

Status: New