Showing results for 
Search instead for 
Did you mean: 
Advocate IV
Advocate IV

Powerapps: If combo Box 1 is equal to A then combo box 2 is set to A and disabled otherwise user cho

Powerapps is linked to a SharePoint Online list


Combo box 1:  Asset Type (2 options): IT Asset, Non IT Asset


If this box is set to "IT Asset" I need it to:

Combo Box 2: 1st level Approver ( 9 options): IT Director, Manager, Local Controller, General Manager, Field Controller, Regional Controller, CFO, CEO, BoD: This needs to be set to first option (IT Director) and gray out (disable)

Combo Box3: Approval (Person Field from SharePoint); Set to name of IT director and gray out (disable)



Any and all assistance to accomplish this would be helpful!







Accepted Solutions



I finally got this working:


Combo box 1: Set OnSelect to: Set(varAssetType,ComboBox1.Selected.Value)


Combo box 2: Set DefaultSelectedItems to: f(ComboBox1.Selected.Value ="IT Asset",(Filter(Choices(ListName.ComboBox2),Value="IT Director")))


Combo box 3: Set DefaultSelectedItems to: If(ComboBox1.Selected.Value ="IT Asset",
Email:"" },Parent.Default)


Then on the DisplayMode of both the data cards for Combo Box 2 and Combo Box 3 to: If(ComboBox1.Selected.Value ="IT Asset",Disabled,Edit)


Hopefully this can help someone else!

View solution in original post

Community Champion
Community Champion

You would just use an If statement for this...


So..if you want it to default the value on Combo Box 2 off Combo Box 1 then the Default Value for Combox box 2 would be = If(ComboBox1.Selected.Value="IT Asset","IT Director") -- this will say if they select IT Asset for ComboBox1 then make the Default for Combo Box 2 "IT Director"


You would do the same If statement with a variation for making it disabled...


If(ComboBox1.Selected.Value="IT Asset",Disabled, Edit) -- This would go on the DisplayMode for ComboBox 2


Just make sure to remember that when you put a default for a combo box it goes on the DefaultSelectedItems....not the regular Default



Advocate II
Advocate II

This video might help. These guys are pretty good with PowerApps. 

@rebeccas I would like this as a solution but your default formula is not working "The property expects Record values but this rule produces incompatible text values."  there is no else part of this statement.


If(ComboBox1.Selected.Value= "IT Asset","IT Director") if it is false I would like it to be blank but I cannot seem to get it in the formula. 


Any thoughts?

Community Champion
Community Champion



Okay, is because I told you wrong it isn't working...I had to go pull up one of my old ones to get it right...thought I could right off...but I was wrong.


Anyhow, try:


If(ComboBox1.Selected.Value="IT Asset", (Filter(Choices(SPListName.Column2Name),Value="IT Director")))


You don't have to tell it anything special to make it blank if will be. Let me know if this doesn't work for you. 






 I got this working on Combo box 1 and 2 but how do I get this working on combo box 3 (person field from sharepoint)?  I want it to, If IT Asset, default the people combo box to user John doe. Any thoughts on how to do this?


Thanks for your quick assistance!


Community Champion
Community Champion

Would you be able to say put in their persons name?...if so it is the same concept but you just put their name in the quotes or do u need it t look up a person off the selection?

I want to put the IT directors name into the people field that is linked to a sharepoint people field, without the user's input. 

Community Champion
Community Champion

So, I think it would be this:


If(ComboBox1.Selected.Value="IT Asset", (Filter(Choices(SPListName.PeopleColumn),Value="John Doe")))


If that doesn't work let me know and I will click over and test it to see what needs to be different but I think it is right.



Here is an image of my screen: When combox box 2 (1st level Approver) is set to It director I want to Approval Name field below to be set to "John Doe" and be grayed out.



I tried: 

If(DcdAssetTypeV.Selected.Value ="IT Asset",(Filter(Choices(CAPEX.'1stApprover'),Value="John Doe"))) 

This did not work and when I changed the column to the people column (Approval1 which is different from 1stApprover) the formula errors out.



2018-11-21 09_33_16-Window.png

Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power Apps Community Call Jan. 2022 768x460.png

Power Apps Community Call

Please join us on Wednesday, January 19th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,956)