cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
thoang858
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
RobElliott
Super User
Super User

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
RobElliott
Super User
Super User

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.

Thanks Rob. Appreciate your time.

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (2,145)