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
Level: Powered On

@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.

Level: Powered On

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

Level: Powered On

@kyleb350  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