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

You're welcome! - it really is useful. Thanks for letting me know it worked well for you.

That is super high praise, thank you! 🤩

Really glad you found it useful. If you watch the create items video you’ll find a way to make your delete items action twice as fast. Very easy to do. Good luck on the creates!

@@PaulieM Hi Where should I add the Threads to the BATCH DELETE Flow? I tried but it is taking just as long. I must be missing something and can't figure it out.. Thanks

Thank you!!! I ran into this issues and couldn't figure out why

Thank you. This was driving me crazy.

Thank you!

Great to hear. The speed improvement is great, but just as important is the reduction in API actions. It’s a double win!

Easy mistake to make. Glad you got it sorted.

it now works with this...thanks

Thanks for posting this. The missing "/" was giving me a http 400 error. Works now

Glad it helped!

Thanks for the sub!

Glad it helped. It really does save a lot of time.

Thank you! Glad it helped!

Great to hear that’s it’s helped you out. Thank you for the feedback - even better method coming up soon!

I can foresee the new method is going to be insane amazing. 😂 Subscribed!

You don’t need to batch when retrieving items. The standard methods should work fine.

@@PaulieM Thank you, sir.

You're very welcome!

I agree something has changed. But it hasn’t changed for everyone. On some tenants the batch operation is much faster, on others it does seem to have been constrained. I have run the same operation on different tenants and the speeds are wildly different.

Glad you found it useful - it’s a neat little addition to the toolbox!

@@PaulieM Hi Paulie, I was able to take the parts from your “create items threaded version” and apply it in the bulk deleted one on here so I successfully created a threaded solution for Delete in Batch!!! Fantastic Tutorials!!! I was able to delete 1500 items in under a minute verses 3 minutes on the non threaded version.

@@robertbaker70 good work! Sounds like you’ve build a brilliant solution.

Hi, Please create a post on powercoders.net and show the issue and I will see if I can find a solution.

me also facing same issue

@@AYUSHGUPTA-pi1ib same U_U

Sorry..it worked for me...I was not providing the correct internal name for the list

Me too...got this:: --batchresponse_fe7f85a1-d115-42d2-82bb-59cbe67ca499 Content-Type: application/http Content-Transfer-Encoding: binary HTTP/1.1 400 Bad Request CONTENT-TYPE: application/json;odata=verbose;charset=utf-8 {"error":{"code":"-1, Microsoft.SharePoint.Client.InvalidClientQueryException","message":{"lang":"en-US","value":"Invalid request."}}} --batchresponse_fe7f85a1-d115-42d2-82bb-59cbe67ca499 Content-Type: application/http Content-Transfer-Encoding: binary HTTP/1.1 400 Bad Request CONTENT-TYPE: application/json;odata=verbose;charset=utf-8 {"error":{"code":"-1, Microsoft.SharePoint.Client.InvalidClientQueryException","message":{"lang":"en-US","value":"Invalid request."}}} --batchresponse_fe7f85a1-d115-42d2-82bb-59cbe67ca499 Content-Type: application/http Content-Transfer-Encoding: binary why?

Thanks for the feedback - I’m really pleased it was helpful

same issue here

ever figured this out? or a faster way that does work?

Check the Send HTTP Request Action - mine had blanked out the site address. Works now after adding back in.

I noticed that myself the other day. Maybe SharePoint throttling has changed.

1000 is the maximum number of actions that can be completed in one batch request. You can easily control this by setting the maximum number of results from the "Get Items" action to 1,000. I prefer to use a lower number such as 750 to give some margin.

Thank you! 🙏

I’m very pleased to hear that! 🙏 😃

Are you aware of a way to enter that data manually if we're unable to use the My Clipboard function?

Have you tried pressing CTRL-V when you’re in the clipboard?

@@PaulieM I did, indeed. The same thing was happening on your batch create page. The code would not copy and paste. I ended up downloading your example file and importing, copying and pasting from within PA. That seemed to work

Have you tried in the old designer?

@@PaulieM sir thanks it is done now

@@PaulieM sir i ran it twice last times, it skipped almost 1k records please suggest how to avoid this problem

My pleasure, pleased to hear it helped you out.

@@PaulieM Can you do a video tutorial update all items?

It will, but you will have to correctly encode those characters so the lost name matches up.