cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rhiheu
Advocate III
Advocate III

Combo Box default value populated from SP list based on selected value of another Combo box

Hi,

I'm struggling to get my default value of my Combo box (LocationComboBox) to load based on the selected value of another Combo box (CustComboBox). This is the setup:

  • In the first SP List ('CustomerList'), each item has both a customer reference ('CustRef') and an assigned location code ('AssignedLocationCode') which references the site of their booking - this is assigned by another system.
  • In the second SP list ('LocationList'), each item has both a location code ('LocationCode', which is the full listing of those codes that are that are assigned in the first list by the external system), and also further descriptions about that site - 'LocationName', 'LocationAddress' etc.
  • The user selects a value (single-selection only allowed) in CustComboBox from CustomerList. The default value is ThisItem.CustRef

The LocationComboBox shows a list of all place names (LocationName) from LocationList (single-selection only as well). I would like it's default value to be the LocationName stored in LocationList, based on the matching assigned site code of the CustRef selected in CustComboBox. 

So far I have (for LocationComboBox's default):

 

LookUp(LocationList,LocationCode=CustComboBox.Selected.AssignedLocationCode,LocationName)

 

It works in a text input field, but not sure how to make it work for a Combo box field.

Any help appreciated, thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
v-bofeng-msft
Community Support
Community Support

Hi @rhiheu :

Do you want to set the LocationComboBox's default options based on the selection in CustComboBox?

Do you want to display the options in LocationComboBox's as LocationName?

The point is the combo boxs DefaultSelectedItems property.

Ive made a test for your reference:

Set the LocationComboBox's property to:

Items: 

LocationList

DefaultSelectedItems:

LookUp(LocationList,LocationCode=CustComboBox.Selected.AssignedLocationCode)
DisplayFields: ["LocationName"]

SearchFields: 

["LocationName"]

I think this link will help you a lot:

Combo box control in Power Apps

Best Regards,

Bof

View solution in original post

2 REPLIES 2
v-bofeng-msft
Community Support
Community Support

Hi @rhiheu :

Do you want to set the LocationComboBox's default options based on the selection in CustComboBox?

Do you want to display the options in LocationComboBox's as LocationName?

The point is the combo boxs DefaultSelectedItems property.

Ive made a test for your reference:

Set the LocationComboBox's property to:

Items: 

LocationList

DefaultSelectedItems:

LookUp(LocationList,LocationCode=CustComboBox.Selected.AssignedLocationCode)
DisplayFields: ["LocationName"]

SearchFields: 

["LocationName"]

I think this link will help you a lot:

Combo box control in Power Apps

Best Regards,

Bof

View solution in original post

Hi Bof,

I assumed with the 'DisplayFields' part you meant enter that under the separate DisplayFields property, not under DefaultSelectedItems, then it worked perfectly, thanks!!

Thanks for the Combo box control in Power Apps link too. I had made the assumption that 'Default' was for single-selection only Combo boxes and 'DefaultSelectedItems' was for multi-selection Combo boxes. Do you know what is the purpose of the 'Default' field for Combo boxes? Just for my future reference. I've tried googling for an answer to this to no avail.

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (2,352)