Use Read from Excel worksheet to get the data. Then do a Loop to iterate through the rows and check if the value at %ExcelData[LoopIndex][7]% is empty via an If condition. The LoopIndex there is generated by a Loop action, while the 7 is a column index for column H.
If it is empty, use Delete row in Excel worksheet to delete the row.
I would suggest looping from the end to the beginning, so that further rows do not get affected by the deletion. I.e. if you delete row 2, what previously was in row 3 will move up to row 2. So, it will be tricky to use the index. But if you start at the bottom and go up, it won't matter.
To do that, make your Loop action start at %ExcelData.RowsCount-1% and end at 0, and iterate by -1.
Also, in the Delete row from Excel worksheet actio , when you delete a row, make sure you use %LoopIndex+1% as the row index. This is because indexes are 0-based in PAD, but 1-based in Excel.
-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.
I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.
