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
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

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

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (2,486)