cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
becky2
New Member

Delete All Rows in Table -- Not Deleting All Records

Hi! 

 

I am trying to delete all the rows in an Excel table and reinsert new records into the table with data from SQL. I have done the popular List All Rows, then Delete A Row using a Key Field from the List All Rows step above. 

 

This worked fine, but now I am at 500+ rows (and my # of rows will continue to grow) and either the List or Delete step seems to time out before it removes all rows. I have tried adding some delays in there which helped a little, but my automation is losing its efficiency. 

 

Has anyone else run into this issue? Is there a way to delete all the rows in a table at once? 

 

Appreciate your help! Thank you! 

1 ACCEPTED SOLUTION

Accepted Solutions
becky2
New Member

Update! I found another thread that pointed out the List Rows limit of 256 records. I updated the Settings of the List Row step to a higher Threshold # and that seemed to have fixed it! Woo!

View solution in original post

1 REPLY 1
becky2
New Member

Update! I found another thread that pointed out the List Rows limit of 256 records. I updated the Settings of the List Row step to a higher Threshold # and that seemed to have fixed it! Woo!

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (2,514)