Power Platform Community Forum Thread Details

Hello guys,

I'm using several Combo Boxes to select Volumes in my App. And the value on that Combo Box depends on other two Combo Boxes:

Product - Size - Volume - Quantity

A - 1 - 1

A - 1 - 2

A - 1 - 3

B - 2 - 2

B - 2 - 3

C - 2 - 3

C - 2 - 4

D - 1 - 3

I'm using this formula to select Volume:

Items: Sort(Distinct(Filter(Database, Product= ComboBox1.Selected.Result And Size=ComboBox2.Selected.Result),Database),Result)

If I choose A and 1, it will appear in the ComboBox3: 1,2,3. Then I have a Data Card where I can insert Quantity.

After insert Quantity, ComboBox4 will appear with the same formula as ComboBox3 and the possible results will be the same (1,2,3). I would like to update date ComboBox4 with only 2 and 3 as possible choices after selecting 1 in ComboBox3. And then if I select 2 in ComboBox4, ComboBox5 only has 3 as option, and so on.

Sorry if I confused you, but I think this is the best way to explain my problem. Can you help me with this?

Thanks a lot.

Categories:

Building Power Apps