Sort list of a dependent dropdown in Appsheet

[francisjasonagr]

Here is my 'Valid if' formula to limit my list of names in the dropdown (dependent on two variables)

but the list are not alphabetically arranged, 

Select(Stock Inventory[Item Name],AND([_THISROW].[Site]=[Site],[_THISROW].[Category]=[Category]))

How Can I Sort them alphabetically

Tried ORDERBY(Stock Inventory[Item Name], [Item Name) 

Help!

[Marc_Dillon · Accepted solution]

SORT()

ORDERBY() is only for key values.

[Marc_Dillon · Accepted solution]

SORT()

ORDERBY() is only for key values.

[jaichith · Accepted solution]

sort(Select(Stock Inventory[Item Name],AND([_THISROW].[Site]=[Site],[_THISROW].[Category]=[Category])),false)

[francisjasonagr]

Thank you!!!