How to quickly delete items from a SharePoint list with Power Automate using the Batch API

How to delete items from a SharePoint list in batches of 1,000 rows by using the SharePoint Batch API method. This method is faster and users fewer API actions than the standard "Delete Item" method available in Power Automate. Grab the code from my blog:

If you found this solution useful, I'd appreciate a donation to the channel:

[akashmahajan]

I can't thank you enough for the tutorial. Bulk creation and bulk deletion in batches is a game-changer, enabling me to solve my problem and achieve better results. Your generosity in sharing knowledge is truly commendable. Thanks a million!🙌

[RowDogSA]

Thanks for this. I am getting 1000 records per minute. A huge improvement from my previous 5 minutes. Now on to your video "to batch create SharePoint List Items".

[braveheartingux]

The first proper blog about Power Automate, with examples, codes and true knowledge. Amazing. Shared with other and highly recommended.

[ajambo]

Brilliant, thank you for this Paulie, it worked a treat. The copy and paste into Scope was a gem. I dabbled with POST BATCH but was getting the syntax wrong, it is very touch about spaces and new lines, so it was great to be able to deploy and view working code. The largest batch I have deleted so far has been 11, 000 items, I'm working my way up, and it has consistently been 1 min to delete 1, 000 items. The next task is to do a mass batch upload, which great timing as you have just released that video.

[GuyBerthiaume-ScaleModels]

Worked very well, reducing a 7 minute process to just 1 minute! Thanks!

[lungadlabantu]

This is the best video that I’ve come across this year! Thanks a million!!!

[TrailersYT]

Damn, this is such a good way to delete items! You really helped me a lot!

First it took about 90 minutes, and now 17!!

[ajssoarestube]

Thanks Paulie, your channel saved me! Here in Brazil we have poor content in our language.
God bless you.

[ljukcz]

Amazing tutorial, I'm amazed how people are clever to manage this. Many thanks !

[SeabrookIslander]

So following the directions on the video, I could never see the Delete SharePoint Items pasted code in the clipboard, instead it was giving me the default Power Automate message of available actions that can be copied. If you see this, you need to do a Control-V to successfully paste his code into your flow. This was not obvious from either the video or his blog.

[davidcampling]

Awesome Video and Blog. Thx for sharing. I made a mistake of not including the forward slash at the end of my site name which meant the flow ran but didn't delete. You live and learn ! Thx for sharing . I am off to do watch the batch creation!

[mdhidayat]

Thank you so much Paul!
Love the batch delete and create videos.
It has been a tremendous time saving!
Cheers!

[c.mdsalih]

OMG! This is amazing. Saved lot of time and number of requests, Thanks a ton!

[chapish]

Well, this is a very handy find, thanks! I have a list with nearly 700, 000 items that I need to clear down...

[robertbaker]

Works great! This was a great learning experience for working with large items!

[Rizzipups]

Great tutorial, thank you Paul! Everything is working well, but has something changed in PowerAutomate or SharePoint? Because it is running correctly, but I'm not saving any time in comparison to the old (Apply to each) function... any ideas? Before it was 12 minutes, now it is also 12 minutes...

Edit: I have the same "problem" with your other "Power Automate Flow to batch create SharePoint List Items".. Creation is unfortunately not speeding up

[Sepialex]

Amazing video and coding skills bro. Thanks, new subscriber and greetings from México.

[vishwahadagali]

@PaulieM - Awesome solution.. this is really helpful one when users want to refresh the list with bulk deletion using batch API. Did you try to trigger this using power app. When I use my power app trigger instead of manual trigger the flow fails at get items. It doesn't show exact error details.. I have gone through your article and comments of the users .. it seems other users also having same issue with power app trigger.. I'll be waiting for your response.. thank you so much.

[shjohn]

Thank you so much Paulie for this video. This really helped.

[SiMataR]

This works great for me deleting around 20k items from a 4.5M item SharePoint List faster! Thank you very much for this, Paul!

Can we also use this SharePoint Batch Method in exporting the same 20k or more items to CSV? I am having trouble lately using the Get Items only solution even when the pagination is already set to 5000. My flow was exporting 20k a day before but since the start of December 2023 it has just been exporting just less than 10k.