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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Change the value of a ...
Power Apps
Answered

Change the value of a dropdown from another dropdown

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

I have two dropdowns that correspond to each other in a form. If dropdown A is selected to "No" I want dropdown B to change to "N/A". How would I do this?

 

I tried a formula I found in these forums but it didn't work because I think it was based on a text-to-dropdown or vice-versa relationship.

 

DropDown A choicesDropDown B choices

Yes

Complete
NoIn Progress
 Not Started
 N/A
 Need Info
Categories:
I have the same question (0)
  • RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @nvargas 

    You should be able to use the following formula in the Default property of your Dropdown B.

    If(DropDownA.Selected.Value = "No", "N/A")

     

    I hope this is helpful for you.

  • subsguts Profile Picture
    1,259 Moderator on at

    I put the following code in the "Items" property of the 2nd dropdown and it work:

     

    If(Dropdown1.SelectedText.Value = "No", ["N/A"],["Complete","Not Started","N/A"])

     

    Let me know if this solves your problem.

  • subsguts Profile Picture
    1,259 Moderator on at

    Just to clarify, I went down Randy's path too, but thought you wanted to eliminate the other choices from being possible.  If that's the case I believe what I posted will work for you.  

    However, if you just want the second dropdown to default to "N/A" and still have the user be able to select the other choices that what Randy posted is what you'd want to do.  

    Hope this helps as I didn't want to confuse the issue with two answers that are similar in nature.

  • RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @subsguts 

    Another option (because If statements in Items properties are not good practice) would be to specify your data in your primary dropdown.

     

    So, the Items property for Dropdown A as:

    Table(
     {Value: "Yes", Values: ["Complete", "In Progress", "Not Started", "N/A", "Need Info"]},
     {Value: "No", Values: ["N/A"]}
    )

    Then, the Items property for Dropdown B set to:

    DropdownA.Selected.Values

    No If's or Defaults needed, it would simply have the correct options based on the choice.

     

     

  • nvargas Profile Picture
    Microsoft Employee on at

    I tried this and I get an error saying the formula has an error, but this is what I want so that when the form is saved it will save the N/A in the second dropdown.

    nvargas_0-1666206544546.png

     

  • RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @nvargas 

    What is the error you are getting?  Hover over the red underlined formula and view the tooltip that appears.

  • nvargas Profile Picture
    Microsoft Employee on at

    nvargas_0-1666271890160.png

    Expected Record Value

  • nvargas Profile Picture
    Microsoft Employee on at

    Just realized they're both a combo box, not a dropdown...

  • Verified answer
    nvargas Profile Picture
    Microsoft Employee on at

    I found the solution now that I realized they're comboboxes.

     

    https://powerusers.microsoft.com/t5/Building-Power-Apps/Update-another-dropdown-box-or-combo-box-based-on-another/td-p/291856

     

    This worked like a charm.

     

    Thank you for the help anyways @RandyHayes !

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 356 Most Valuable Professional

#2
11manish Profile Picture

11manish 225 Super User 2026 Season 2

#3
Mohsin Ali Profile Picture

Mohsin Ali 211

Last 30 days Overall leaderboard