This came up today. This may be a critically serious issue if it cannot be resolved. This is absolutely unexpected, and I am worried about my project being deliverable!
Error: "The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator. clientRequestId: 2b517dbf-7e5c-4e26-83f4-33b2dce18728 serviceRequestId: 7b1e8e9e-e0b2-6000-bec7-b0874a236760"
There are in excess of 5,000 items in this list. Why is it failing with a simple action? This is the first indication of an issue.
There is a limit of 5000 items for sharepoint lists in microsoft flow currently. And those get throttled when hit a list bigger than 5000 items.
There is a similar post has the same issue as yours:
This is a known limitation, if you want to extend, please consider to submit an idea in the Flow Ideas forum, so it might be considered for future releases.
Have your problem be solved according to my solution? If yes, please go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!
Actually, I ended up doing a manually triggered flow varying the range each time to step through the several thousand items at a time, using the list ID. It was inconvenient, but doable.
While I did appreaciate your letting me know the details of the limitation, it did not really offer a solution. Thus, I'll be using this as the solution.
I would like to revisit this. The other over 5,000 issues Ive seen have to do with filters, and having results over 5,000 items. My get items request will only return ONE item, per my using the Top Count control. Thus, it seem strange that the actual search is limited to 5,000 items. That does not seem right. Is there a setting somewhere else that can help with this situation? I will actually have a very large problem if my flows stop failing as lists exceed 5,000 items. I mean, I need it fixed POST HASTE because I already have ont that is at 5,283. It is a document libraray, but I have not seen this error yet, and I have many flows searching against it. So, is there another problem here?
Not sure if you have solved this issue or not. I have a sharepoint list that is over 16K and needed a flow to send closed items to an archived list
What I ended up doing was the following:
Added a second Filter Query to exclude a lot of items.
Created a view that only allowed 100 items (which is what I was after) and used that in my Limit Columns by View
Indexed the columns that were used in the Filter Query and the Order by.
I tried several of the above by themselves but only in concert did it actually work.
I'm not sure if this will help you with the documents listing but I hope so.
Check out new user group experience and if you are a leader please create your group
See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.
Many congratulations to the Season 1 2021 Flownaut Crew!
ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.