Change object not associating a list in given order.
I have one helper object which is associated to main entity and there is many to many association between them. I have a microflow which gets the list of main entity in the order that we need to display. However, when I am associating that list to helper object, the order in not maintained. In the microflow retrieval, SearchPartList gives the correct order however, when we associate it with FilterHelper the order changes.
The Mendix retrieve action retrieves data with default sorting order, which is ID.
You can also notice the same in your debug window, except I see one latest ID in the first item.
It is better to check if you have order it with some custom sorting in your retrieval.
Or force the ordering yourself.
NOTE: I have also noticed sometimes this happens, but I had my own explanations for those incidents in my case.