Contents
If you want to increase the limit, you can enter a Top Count value. The maximum top count you can enter is 5000, which changes the way Flow sends the Get Items request to SPO.
You can set top count to any value up to 5000, but no more. The field will accept a larger figure, but it will not retrieve more than 5000 items. So getting 5,000 items is easy, how about the rest? To get every item in the list, a loop is required that runs until there are no more records.
What’s the maximum number of items you can view in a list?
List View Threshold. 5,000. Specifies the maximum number of list or library items that a database operation, such as a query, can process at one time. Operations that exceed this limit are blocked. To give you time to make alternative plans, you may be warned on the List Settings page when your list has exceeded 3,000 items.
What happens if there are 5000 items in a list?
However if it is just an empty query without any filtering it will fail, if you use unindexed column for filtering or ordering the query will fail, if you filter/order by indexed column and the query returns more than 5000 items it will fail again. The error in this and other scenarios is similar to the one below.
Is it possible to have a library of 5000 items?
List or Library above 5000 items is indeed possible with planning and some filtering/sorting compromises. If you can make it modern, you should. The modern experience improves over time; classic does not. Apply remedies before you hit 5000 items, though in some cases, you can make it to 20000.
How to index large lists and large libraries?
In an ideal situation, where the user knows the List or Library will be large, you’d index any and all columns you can. A View that’s over the threshold will generally only display if it’s filtered by an indexed column first in the view, and that filter returns no more than 5000 unique values.