Most of the time Joel is very helpful but sometimes he’s just plain grumpy:
I’m finding that the lookup field quick preview list does not honor sort order. In this example I have a “sequence” field that sorts the list in the desired order:
If you go to the lookup dialog, it honors the sort order in the lookup view:
Is there any way to make the quick lookup preview honor the sort order?
And I kind of appreciate his grumpiness on this one because the reply from authoritative sources came thick and fast:
This is not possible today, quick preview list sorts it based on the “primary attribute” of the entity. But if this is something which blocks your scenario, I will be happy to add it into the backlog for lookup enhancements. Can you please open a connect bug for this and send me the ID.
Relentless man that he is, Joel indeed used Microsoft Connect to press on with the issue (and under the similar circumstances you, our readers, should do the same!):
Here is an existing Connect item with 15 votes. I would say this is high priority. The only way to make it work is currently to append numbers to the lookup list to make it sort correctly in preview.