Sort by and grouping by at the same dropdown

I’m creating a dropdown that fetches options from an external spreadsheet via an API. I need it to retrieve elements based on both a filter and a group. In the filter part, I can apply a “sort by” criteria, but when I add the grouping, it disregards the filter and arranges the options in alphabetical order.

If I add a “sorted” after the “grouped by,” the field becomes empty. Does anyone know which order I can use to make the “sort by” work?

This topic was automatically closed after 70 days. New replies are no longer allowed.