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.
|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.
|Active worksheet with||Name|
|Worksheet name||The name of the target sheet.|
Set up a Loop.
|Retrieve||The value of a single cell|
|Operator||Equal to (=)|
Finally, set up Close Excel Action and save the file.
If column A is blank when this Flow is executed, the row is deleted.
For those who want to learn Power Automate Desktop effectively
The information on this site is now available in an easy-to-read e-book format.
Or Kindle Unlimited (unlimited reading).
You willl discover how to about basic operations.
By the end of this book, you will be equipped with the knowledge you need to use Power Automate Desktop to streamline your workflow.