Re: SORT () expression does not order

TalkNet_TechnoS · 12-12-2019 10:46 AM

Hi,
I have the following expression in the “Valid If” of a Reference column, to show the options, according to different filters. In addition, 2 more options are added at the end that must always be present.
The first list, I want it to be sorted alphabetically, but, as seen in the image, it doesn’t work.
Any suggestions as to why the list is not sorted?

SORT(
SELECT(Productos[Producto Id],
AND(
OR(
IN([DiaSem],[Dias]),
IN([Feriado],[Dias])
),
IN([Turno],[Turnos]),
IN([Salón],[Salones]),
[_THISROW].[Tipo de Evento]=[Tipo Evento]
)
),FALSE)+
SELECT(Productos[Producto Id],
OR(
[Producto]=“Precio Personalizado”,
[Producto]=“RESERVADO”
)
)

The result of this expression is as follows:

WillowMobileSys

The list is being sorted by the “Producto Id” value. Is that the value displayed in the dropdown?

TalkNet_TechnoS

Ah, certainly! What I’m seeing is the label, but it’s sorting the list by Key Id’s !! I did not think about it like that.
Do I have any way of ordering using another field as criteria?
In that case I could create a virtual column with the labels and sort by that criterion. True?

Steve