cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

How to filter and set Drown value with Some Conditions

There are two dropdowns TypeA having values (A,B,C,D) and TypeB having values (1,2,3,4,5,6)

1-When a TypeA = ‘C’ or D is selected the TypeB should be filtered to only include the following choice values:(3,4,5,6)

2-When a TypeA = ‘A’ or B is selected the TypeB should be automatically set to 1

 

I have tried below solution in items property of TypeB dropdown but for condition 2 I have to set the value of drodpwn to 1 but its just showing me in dropdown, how can I do it?


Switch(
TypeA.Selected.Value,
"C",["3","4","5","6"],
"D",["3","4","5","6"],
"A",["1"],
"B",["1"],
Choices(Listname.TypeA)
)

1 REPLY 1
Fatih1 Helper III
Helper III

Re: How to filter and set Drown value with Some Conditions

TypeA items -> ["A","B","C","D"]
TypeB items -> if(TypeA.Selected.Value = "C" Or TypeA.Selected.Value = "D", ["3","4","5","6"], if(TypeA.Selected.Value = "A" Or TypeA.Selected.Value ="B", ["1"]) 
TypeB default -> If(TypeA.Selected.Value = "A" Or TypeA.Selected.Value ="B", "1") 

 

I think this must be working.

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Top Solution Authors
Top Kudoed Authors
Users online (6,291)