I replicated your data in a collection:
ClearCollect(
ColCities,
{
City: "Mumbai",
Code: 12,
State: "MAH"
},
{
City: "Bangalore",
Code: 13,
State: "KK"
},
{
City: "Chandigah",
Code: 14,
State: "PB"
}
)
CityDropdown.Items:
CodeDropdown.Items:
You don't need to filter like this, I just did it this way to return the correct city code.
Button.OnSelect:
Set(gblState, LookUp(ColCities, City = Dropdown1.Selected.City And Code = Dropdown1_1.Selected.Code, State)) // or UpdateContext
Label.Text:
Final result:
