web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / dropdown column depend...
Power Apps
Answered

dropdown column depends on another dropdown

(0) ShareShare
ReportReport
Posted on by

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:
I have the same question (0)
  • PowerRanger Profile Picture
    3,458 Super User 2024 Season 1 on at

    @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.

     

  • venky232 Profile Picture
    on at

    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.

  • Verified answer
    v-xiaochen-msft Profile Picture
    on at

    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.

    vxiaochenmsft_0-1661324321479.png

    vxiaochenmsft_1-1661324339028.png

    vxiaochenmsft_2-1661324355523.png

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

     

    Best Regards,

    Wearsky

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 711 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 319 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard