Delete rows of Excel with specific conditions.(Power Automate Desktop)
I will show you in the sample to delete a row if a particular column is blank.
The following worksheet has column A in rows 3 and 5 as blank and we want to delete this row.


Overall view of Flow

Robin(for copy and paste)
It can be copied and pasted into Power Automate Desktop.
Excel.LaunchExcel.LaunchAndOpenUnderExistingProcess Path: $'''C:\\Test\\Test.xlsx''' Visible: False ReadOnly: False Instance=> ExcelInstance
Excel.SetActiveWorksheet.ActivateWorksheetByName Instance: ExcelInstance Name: $'''Sheet1'''
Excel.GetFirstFreeColumnRow Instance: ExcelInstance FirstFreeColumn=> FirstFreeColumn FirstFreeRow=> FirstFreeRow
LOOP LoopIndex FROM 1 TO FirstFreeRow STEP 1
Excel.ReadFromExcel.ReadCell Instance: ExcelInstance StartColumn: 1 StartRow: LoopIndex ReadAsText: False CellValue=> ExcelData
IF ExcelData = $'''%''%''' THEN
Excel.DeleteRow Instance: ExcelInstance Index: LoopIndex
END
END
Excel.CloseExcel.CloseAndSave Instance: ExcelInstance
Flow creation steps
Set up a Launch Excel Action.
Parameter | Value |
---|---|
Launch Excel | and open the following document |
Document path | Path of the target Excel book. |
Make instance visible | OFF |
Open as ReadOnly | OFF |

Set up a Set active Excel Worksheet Action.
Parameter | Value |
---|---|
Active worksheet with | Name |
Worksheet name | The name of the target sheet. |

Set up a Get first free column/row from Excel worksheet Action.

Set up a Loop.
Parameter | Value |
---|---|
Start from | 1 |
End to | %FirstFreeRow% |
Increment by | 1 |

Set up a Read from Excel worksheet Action in Loop.
Parameter | Value |
---|---|
Retrieve | The value of a single cell |
Start column | 1 |
Start row | %LoopIndex% |

Parameter | Value |
---|---|
First operand | %ExcelData% |
Operator | Equal to (=) |
Second operand | %''% |

Set up a Delete Row from Excel Worksheet Action in If.
Parameter | Value |
---|---|
Delete row | %LoopIndex% |

Finally, set up Close Excel Action and save the file.


If column A is blank when this Flow is executed, the row is deleted.


---
Discussion
New Comments
No comments yet. Be the first one!