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.

View solution in original post

Thanks Rob. Appreciate your time.

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (76,269)