Solved: Ordering Enum/Ref Buttons, with dependent dropdown... - Page 2

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

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

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

View solution in original post

Ordering Enum/Ref Buttons, with dependent dropdowns