cancel
Showing results for 
Search instead for 
Did you mean: 

Delete rows actions of Excel Online

I want to delete all rows from Excel Online

for renew all in table on Excel Online

 

Currently, Excel Online have the action 'Delete a row'.

But, I want to delete all rows and get new data, add rows

Status: New
Comments
Anonymous
Not applicable

@TheMan . Thanks! Instead of deleting rows within an Apply To Each step, I simply have a SharePoint step to copy a blank sheet (identically named but in a different folder) into the current folder overwriting the current file. I feared there might be a unique identifier other than file name that the flow uses but that doesn't appear to be the case.

Anonymous
Not applicable

@Anonymous : oooh, that sounds like an interesting workaround.  You keep a blank template excel file with the table in it already, and just reuse that?

luuminhvuong93
Post Patron

@Anonymous  Hi there I tried to use "Copy file " from sharepoint , and select the option "replace" if file existing

However it doesn't replace the file at all. the old file is still there

READMEtxt
New Member

I had the exact same issue (trying to delete all rows in a onedrive excel table through an azure logic app). And implemented a solution similiar to @TheMan , List all rows in a table, then run a foreach loop on the returned list, then run a "delete a row" excel action in the foreach loop where the column content is equal to the current item's column content. And I ran into the same problem where in the foreach loop, it only deleted 1 row from excel, no matter how many foreach iterations ran. My solution was going into the foreach loop control's settings and turning on "Concurrency control" and setting the limit to 1. This way it actually deletes all the rows in the table in the foreach loop without having to add seconds delay etc. Hope this helps for anyone in the future with the same problem