I would like to sort the contents of a dropdown menu.
In most cases, I can control the order of the entries via the Reference Data file. However, with Groups and Remove Duplicates, in the case of a user who is a member of multiple Groups, I find that there is no way to sort the list alphabetically.
I tried sorting the reference data file. However, it appears the website parses the list into separate Group-based lists. It then matches to Group membership, removes duplicates, and concatenates the results. This breaks the original sort order of the as-uploaded data.
An alternative to adding a 'sort' function... When importing a Reference Data file with Groups, create an autonumber Index column before splitting it into two Group-based lists. After determining which rows to display after checking Group membership, concatenating the results, and removing duplicates (Ignoring Index), then sort by the Index column. This would return control of the data order to the user, based on the original order when the Reference Data was uploaded. This method is a bit of a kluge, though
The ultimate fix would be to not break the uploaded data into separate Group lists. Keep the uploaded Reference Data in the as-uploaded order, in one list. If you want to display it filtered by group, do it on the fly.