Power Platform Community Forum Thread Details

I have a Power Automate flow that does the below.

A form is filled and then it creates a task on my planner. That entry/task is also added to a SharePoint list. Once the task in my planner is complete, then the SharePoint list entry is updated as complete.

All seem to work fine. However, once my SharePoint list reached the 5001 entries the flow is now failing. I thought there was an issue with the flow but after many attempts, I decided to just delete 100 entries from the SharePoint list.

The flow worked like before. So, it is clear that the SharePoint list has a 5000 entries limit. Is there a way to increase this? Do you have a permanent solution instead of me deleting entries to keep the list below 5000?

I hope you can help me.

Categories:

Building flows

If you are using an Apply to each loop in your flow be aware that only power Automate Premium licenses can run an Apply to Each loop on more than 5,000 items. I suspect that may be what is happening. The only fix is to prefilter your items to get the size of the loop to less than 5,000 or pay for a Premium license. Take a look at the profiles definitions in this article. Limits of automated, scheduled, and instant flows - Power Automate | Microsoft Learn

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog