DROPDOWN WITH DIFERENT CHOISES

[Magoforrest]

Hi all,i am trying to filter my selection in the second dropbox.... if in the first drop box i choose an item i want the item to have it special list....

for example if in the fisrt dropbox i have:

water

in the second i want the user to select only certain values like:

-2

-3

if in the first dropbox the select snow:

-6

-7

-8

 THKS!

[WarrenBelz]

@Magoforrest ,

Make a table (either a list or collection) with two fields (I will call them Object and number here). Your first drop-down would contain the object list, the second would be

Filter(
   YourListName,
   Object=YOurFirstDropdown.Selected.Object,
).Number

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[Magoforrest]

thx for the replay but i don't get it... I am creating list in excel..... i cant seam to get it working. 😞

[WarrenBelz]

@Magoforrest ,

Can you please supply the code (in text) you have currently tried as well as where you are using it.

The Items of the two combo boxes in particular are needed.

[Magoforrest]

I am not using a combobox.... only simple dropdown... 

Filter(
Tabella3,
Object=Dropdown3.Selected.Object,
).Number

[WarrenBelz · Accepted solution]

@Magoforrest ,

This is why 

Please watch this video

Firstly, I will assume that the Items of your first drop-down are

Tabella3.Object

Apart from Number being a bad name for a field (I only used it as an example of the type of data it would contain),

what is the error saying?

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.