web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps dropdown column depend...

Power Apps

Answered

dropdown column depends on another dropdown

(0) Share

Report

Report

Posted on by venky232

i have 2 columns in sharepoint

1st column contains 2 choices : Software, Hardware

2st column contains 3 choices : Pending,Approved,N/A

when user select dropdown as Hardware ,then 2nd dropdown should show value automatically as N/A.

how to write code in 2nd dropdown with if condition?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

PowerRanger 3,458 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@venky232 On your second DropDown add this in the Default property

If(Dropdown5.Selected.Value = "Hardware","N/A")

Change Dropddown5 with the name of your first Dropdown.
Is this what you are looking for?

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.

Was this reply helpful? Yes No
venky232 on at

Like
a
(0)

Report
Copy link

Link copied!

not working ,i added code in default properties of dropdown & also in Default selected items.
showing below error
Issue
Expected Record value.
The property on this control expects Record
values. The rule produces Text values which are
incompatible.
Location
DataCardVaIue8
. Default
Haw to fix
Change the rule to produce a {0} value.

Was this reply helpful? Yes No
Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @venky232 ,

It seems that you are using combo box control rather than dropdown control.

If these 2 choice column are all not allowed multiple selections, I did a sample for you.

If(ComboBox1.Selected.Value = "Hardware",LookUp(Choices(LIST269.Choice2),Value="N/A"))

Best Regards,

Wearsky

Was this reply helpful? Yes No

Join the conversation