Ordering Enum/Ref Buttons, with dependent dropdowns

[Jerome_TSC]

Hello Dear Community.

I"m creating an inspection App for a buildings suite, where I have a “Corridors” Database with columns ordered like so:

[Building] - [Floor] - [IDCorridor] - [SubIDCorridor] (KEY)

I Then have an “Inspection points” Database, which is used to collect data through a form. I want the users to be “guided” through the form in the selection of where they are doing inspections.

So I do have these 4 columns again, as Enum, pulling data from “Corridors” table with these settings :

• [Building] > Enum/Text - Valid_IF : Corridors Database[Building]
• [Floor] > Enum/Text - Valid_IF : Corridors Database[Floor]
• [IDCorridors] > Enum/Text - Valid_IF : Corridors Database[IDCorridors]
• [SubIDCorridor] > Enum/REF (to Corridors Database) - Valid_IF : Corridors Database[SubIDCorridors]

The Workflow is functionning as expected, and each subsequent field is correctly populated with data related to previously selected field. However the last Enum/Ref (SubIDCorridor) selection a doesnt appear in correct alphabetical/logical order (Buttons or dropdown, same issue…)

This despite the fact that they are correctly sorted in the “Corridor Database”…

Is there any way I can make these fields correctly ordered ?

Many thanks by advance !
Regards .

[Tedesco_Tech]

You could try using SORT() expression

SORT(Corridors Database[SubIDCorridors])

[Jerome_TSC]

Thanks for your input !

But Unfortunatelly I tried it and this doesn't work, as it is breaking the "nested continuity" of the "dependant dropdown" selection...

Applying "SORT(Corridors Database[SubIDCorridors])", returns me ALL the items in the SubID Corridors Column, and not only the items dependant of the Building+Floor selection...

[Tedesco_Tech · Accepted solution]

It should works the same way as Corridors Database[SubIDCorridors].

Try SORT(UNIQUE(SELECT(Corridors Database[SubIDCorridors], AND([Building] = [_THISROW].[Building], [Floor] = [_THISROW].[Floor]))))

[Jerome_TSC]

Thanks so much. That did the trick !

I had to add an "AND" condition, for the "Corridor ID" And this input works as expected !

Thumbs up !