Usability Improvement for Dynamically Populated Single Select Dropdowns

[adeveloper]

This is a suggestion as well as inquiry on other developers’ solution to this use case:

How do you make dropdowns dynamic while maintaining readability?

What other solutions do you have other than using aggregations?

Currently, the most dynamic way to populate the options under a single select is via table aggregations. However, we have received many user feedbacks about the sorting of these entries. The items on the list appear are not sorted. An example of this:

Can a sort option/function be added to aggregation?

Or is it possible to have a toggle added to the Single Select widget that allows you to choose whether you would want the list of options filtered alphabetically?

Open to hear other people’s solution to this application.

Similar to the suggestions post by other users (link below).

1. Sort Table Aggregations
2. Make table aggregations/Query list sortable

[ASharp-J]

You place the aggregation on top of a query. Any reason your query providing the appropriate sorting?

[adeveloper]

The example I used in the post was populated via aggregation on top a query.

The challenge is if you are querying from a table that’s being updated on a regular basis, the aggregation will only return the new items on the bottom of the dropdown list.
Let’s say this dropdown is used by someone who need to quickly locate an item on there, having the items indexed properly/sorted will improve usability.

[thorsten.langner]

Could you describe more specific, where you try to sort and where / when it gets lost?

When I sort A-Z in the query, the aggregation maintains this sorting:

after adding “A 2nd Test”