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

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
Highlighted
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
secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (10,146)