Sort order in a Lookup

[David_Clegg]

Does anybody know how I can dictate the sort order in a Lookup field?
I have a table of companies that can be added to over time, thus will not necessarily be entered in alphabetic order. Of course I can sort the actual table itself, but if I try to perform a lookup from this table, the presentation order in the drop down list will be in the entered order only.

[Jean_Pierre_Traets]

Hi @David_Clegg,

This post could be of your interest:

Combine Sort() statements in one formula?

It’s possible to combine Sort() statements using the Table UI, and to rearrange them to change sort priority. (see embedded View example) Is it also possible to combine Sort() statements using only a formula? Chaining Sort() performs a total re-sort with each new chain. (see embedded Canvas formula example) This behavior makes sense, but then how to combine Sort() statements in a formula? USE CASE: Organize lengthy list of options in a “Select list”. NOTE: My eyes are loving the recently add…

Kind regards,
//JP

[David_Clegg]

Not sure this helps - this appears to be related to sorting a table, which is great, but not sorting the presented list derived ‘from’ a table when used for during a Lookup - unless I’m missing something!

[Ander]

@David_Clegg

@David_Clegg

this appears to be related to sorting a table, which is great, but not sorting the presented list derived ‘from’ a table when used for during a Lookup

The use case was exactly this, and thanks to @Dalmo_Mendonca, I implemented it yesterday. (The forum post question boiled the functionality down to table sorting to keep the discussion simple.)

Column type must be Select list (instead of Lookup) if you want to manipulate presentation of the dropdown menu (filter, sort, etc).

[David_Clegg]

Thanks for this - will experiment again soon.
I’ve been under the misguided apprehension that Lookups provided a reference to the source data, whilst Select Lists were a copy of the source data, thus I’d lose any true referential integrity, but that appears not to be the case!

[David_Clegg]

Excellent, working perfectly!