Sort Referenced Dependant Dropdowns

[Skip2MiLu]

Hi guys

Any help on the following?

Hello, I'm trying to SORT dependent dropdown... Questions

I believe I might be needing to do the same thing but my expression is incorrect. I have the following tables: Note: I would prefer to keep the table structure as is, due the fact that I pull this from our system at work and doing bulk updates would proof difficult if I modified the table structure differently from the source. Family Segment [image] Crop -Unfortunately this table does not show the relationship between Crop and Family Segment. -The relationship is only visible in the Produ…

[Bahbus]

Alright, I’ll reply here to keep things cleaner.

Hello, I'm trying to SORT dependent dropdown...

Family Segment
-The current default if to sort the drop down by Family Segment No and not Family Segment
-I tried the following expression in Valid_if, that sorts the list by Family Segment instead of Family Segment No. The problem is that is seems to want to enter the Family Segment rather than the Family Segment No.
SORT(Family Segment[Family Segment])
Sample Input: Herbs

Try this as the Valid If instead:
ORDERBY(Family Segment[INSERT_YOUR_KEY_COLUMN],[Family Segment No])

Hello, I'm trying to SORT dependent dropdown...

Crop
-I then would like to see a limited and sorted Crop drop down options dependant on “Herbs” input selected previously.
-I am completely stumped on the expression I need for this one.
-Drop Down Options need to be: Basil , Chives , Dill only

For this Valid If try:
ORDERBY(SELECT(Product Segment[Crop Description], [Family Segment Description]=[_THISROW].[COLUMN_NAME_FROM_PREVIOUS_DROPDOWN]), [Crop Description])

Just make sure to swap out those column names for real ones.

[Skip2MiLu]

Thanks for the help:

The below expression seems to work

Bahbus:

Try this as the Valid If instead:
ORDERBY(Family Segment[INSERT_YOUR_KEY_COLUMN],[Family Segment No])

but not this one:

Bahbus:

For this Valid If try:
ORDERBY(SELECT(Product Segment[Crop Description], [Family Segment Description]=[_THISROW].[COLUMN_NAME_FROM_PREVIOUS_DROPDOWN]), [Crop Description])

Just make sure to swap out those column names for real ones.

I change [COLUMN_NAME_FROM_PREVIOUS_DROPDOWN] with the Ref column from previous selection [Family Segment].

So the final expression is:
ORDERBY(SELECT(Product Segment[Crop], [Family Segment Description]=[_THISROW].[Family Segment]), [Crop Description])

but I am not sure if we using the correct column name.
Keep in mind that the columns indicated in red are the column ID / ref connected between columns.

[Bahbus]

What error are you getting if any? Or what is currently happening?

[Skip2MiLu]

HI Bahbus

I restructured my data a bit to make things easier as well as tried my best to describe my column structure.

See below

Sorted Dependant Dropdowns with Ref Columns Questions

Need some help from you guys on below. Firstly, here is and overview of my table structure: Red = Separate worksheets (i.e. Products and Product Refs excel worksheets) Green = Tables within the worksheet Pink = Columns Underlined = Key columns Dotted lines connecting tables = Ref column types and where they are connect to [image] Secondly, is an example of data in the table: [image] [image] [image] [image] Questions & Comments Firstly, is it better to have all table located in one …