Hi there @kinghnvn!
After some testing I found out you can do it this way!
Items property on ComboBox
Distinct(LIST2;Country)
OnSelect property on Button
Patch(
LIST1;
Defaults(LIST1);
{
Title: "YOUR TITLE COLUMN";
Country: {
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference";
Id: LookUp(
LIST2;
Country = ComboBox1.Selected.Value
).ID;
Value: ComboBox1.Selected.Value
}
}
)
PowerApps doesn't seem to like Sharepoints Search columns that much, however I have recreated both lists with the Search column and it does work for me, so hopefully it will work for you as well . . . Bear in mind you will have to add any required columns for this to work, in my case I hade the Title column which was generated by default, and the Country column, both in the LIST1 as a search and in the LIST2 as a text field.
Hopefully this fixes your problems, otherwise, feel free to reply!
