Unanswered

Delete all the rows in excel table at one go

Like (0) Share

Report

Posted on 24 Feb 2022 14:46:38 by sumit_tiwary

I am trying to delete all the rows in an excel table. However in power automate cloud, I can delete only one row at a time which works if the table is small. In case of number of rows exceeding 500 or 1000, it takes a lot of time and most of the time it jus times out.

Is there a way to delete all the rows all at once?

All responses (2)

Answers (0)

jdoss 458 on 25 Feb 2022 at 18:18:57

Like (0)

Report

Re: Delete all the rows in excel table at one go

In the action settings set the concurrency to it's maximum and even though it's one at a time it should run much faster as it will be doing many at the same time.
manuelstgomes 6,625 on 25 Feb 2022 at 18:05:02

Like (0)

Report

Re: Delete all the rows in excel table at one go

Hi @sumit_tiwary

Unfortunately not. There's an idea submitted with that feature request here.

Sorry for the bad news.

Cheers
Manuel

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.