Increase 1 million list item limit for Order list action

Increase 1 million list item limit for Order list action

Requesting to increase the limit of 1 million list item count for Order list action.

Currently we will get the following error when list item is over 1 million:

 
Cannot Run Action
The number of items in the list (1000001) exceeds the maximum allowed (1000000)
 

Screenshot 2021-09-16 at 5.10.27 PM.png

2 Comments
nick_barker
Certified Master Anaplanner

The issue with the current limit is that it seems to be applied to the total number of items in the list rather than the number of children a parent has. Since the sort is done within the confines of the parent it would seem that the limit should be on the maximum number of children any immediate parent has perhaps? but failing that then I would support the increase of the limit to a larger number.

mooreta
Certified Master Anaplanner

Upvoted.

Just ran into this as well. We have a supply chain use case where we have to concatenate what would be our dimensions in order to avoid creating an incredibly sparse model. If we didn't already have to do this workaround then we could order one of our lists instead of the entire concatenated list.

To @nick_barker 's point, we are ordering within the parent of which there are only 5-10 child members in our instance.