Use formula to populate and sort dropdown

MAP(ORDER(SELECT(data.airtableAgenciesPositions,item.fields.Type===“Agency”),self.label), {label: item.fields.Name, value: item.fields.Name})

The formula above populates my dropdown menu as expected, but it doesn’t sort it. I’ve tried putting the ORDER function outside the MAP function, but that doesn’t work either. Basically, the menu appears in the same order whether the ORDER function is used or not.

What am I doing wrong?

Hi @David_Diamond ,

I used SORT_BY_KEY to sort out my list in repeat in alphabetic order and I put the function outside of any other functions/formulas your are doing.

Hope this helps

Dan

1 Like