cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

MS Flow or Power Automate SharePoint Delete Action limited to only 100 items per run

Greetings,

 

I am not sure if this is a limitation of Flow or Power Automate but it looks like the SharePoint Deletion Item is limited to delete only 100 items per run. Can someone please confirm my assumption? If so, is there anyway I can get around this?

 

I have a flow that queries item created dates older than a specific then deletes them. There is a log list that I have created to log my flows and currently it has over 41,000 items. This of course causes an issue because it exceeds the 5000 list view threshold so I am just trying to programmatically clean it up. After building out my clean flow and viewing the history, I see that it will only delete 100 items at a time. 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III
Super User III

Re: MS Flow or Power Automate SharePoint Delete Action limited to only 100 items per run

Hi @thoang858, to overcome the 100 limit, click on the 3 dots next to the Get items and select Settings. Then turn on pagination and set the threshold to 1000 or 5000 or whatever figure you need. I've only ever had to do it on a document library that had about 200 items where it worked perfectly. But it should be fine for much larger libraries.

 

Pagination1.png

 

Pagination2.png

 

 

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

View solution in original post

2 REPLIES 2
Highlighted
Super User III
Super User III

Re: MS Flow or Power Automate SharePoint Delete Action limited to only 100 items per run

Hi @thoang858, to overcome the 100 limit, click on the 3 dots next to the Get items and select Settings. Then turn on pagination and set the threshold to 1000 or 5000 or whatever figure you need. I've only ever had to do it on a document library that had about 200 items where it worked perfectly. But it should be fine for much larger libraries.

 

Pagination1.png

 

Pagination2.png

 

 

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

View solution in original post

Regular Visitor

Re: MS Flow or Power Automate SharePoint Delete Action limited to only 100 items per run

Thanks Rob. Appreciate your time.

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Users online (6,518)