2 Data Sources on 1 ComboBox

[swan_soup]

Hi all,

I currently have an issue where I need to be able to default a combobox item to match my current record in a gallery. Only issue is that my combobox items all have to come from a specific SharePoint list. Whereas the rest of my gallery is coming from a separate static table. 

My question is if I have to connect both the SharePoint and the static table to the combobox? 

Or is there some function I can use where my selected gallery item can recognize the data in its column and match with the same item on the SharePoint column?

Let me know if further explaining is needed. 

What I said makes sense in my head but might not make sense to anyone else reading 

Cheers!

[Anonymous]

To filter a datasource down to a particular record as selected in another control, you would use the Filter() function in the Items property of a gallery (for instance), and reference the control.

Filter(myData, myField = myDropDown.Selected.myField)

On the other hand, to filter a combobox/dropdown to match a subset of items might be connected to an item selected in a Gallery, or to populate the Default item for that combobox/dropdown, then you will need to reference the gallery's Selected property, and get to the appropriate field

myGallery.Selected.myField

[tommyly · Accepted solution]

You can refer to a field (or object) in your gallery by using ThisItem. For example let's say you have a gallery based on a SharePoint list with Address information called myAddressList.

Let's say from within the gallery's card, you have comboBox1 and you want the default value to equal the card's City. You would do something like this:

comoboBox1.Default = ThisItem.City

Let's say you have a comboBox2 that is not in the gallery card; instead, comboBox2 resides outside of the gallery. You would refer to the gallery's item like this:

comboBox2.Default = gallery1.Selected.City

The neat thing about gallery objects is that you can refer to objects that reside inside the cards. For example, this would output the currently selected item from comboBox:

gallery1.Selected.comboBox1.Selected.City

[Anonymous]

Thanks for your help with this thread @Anonymous and @tommyly!

@Anonymous