I have a list with multiple view. This list contains more the 5000 items. I know and understand that it means that any given view should not have more than 5000 items shown at any given time in it. But it seems that the ability to limit items in a view is pretty pointless to help in that matter.
I know that, even with the filter, there are more than 5000 items that are return in my list. That means that the filter is not enough. So I specified a hard item limit on the number of items returned by the view (100 items flat I don't need more to be returned by the view at any given time). But the Threshold is still exceeded, even if the request is very light. I only want the top 100 items of my view.
Is there a way to have such behavior on SharePoint Online ? When the filter is not sufficient to limit the number of items. I don't really understand why the item limit is not able to prevent list threshold issues.
I cannot make a more precise filter since it would need to be applied on a date that vary by the minutes. You cannot make a filter with minutes precision, only day precision ([Today]-xdays).