Hi!
I have comboboxes that filters items in a list and shows the information in a container. There is something wrong with some of them that when selected, it doesn't show up. Look:
This is how it should look when that combobox is selected because it means it exists and all of the items has information:
But when I select some of them, the container remains blank:
That doesn't make sense because if the second combobox is selected it means it exists and it should show in the gallery below them and the information in the container on the right. Why is not showing? It could be for this issue?
The code is this in the last combobox where it later is wrong n the gallery:
With(
{
_allRecords: Filter(
'Cartera proves diagnostiques 2026_final', //Your SharePoint List - Please replace if it's wrong
UPOrigen.Value = ComboBox_Origen1.Selected.Value, //AGA Combobox name - Replace 'AGAComboBox' your combobox control name
'Codi/Descripció' = 'ComboBox_Codi/Descripció'.Selected.Value //SecondComoboBox - Replace 'SecondComoboBox' with your control name
)//ESPECIALITAT - Replace this with the SharePoint column that you want to compare with the second dropdown column
},
SortByColumns(
Distinct(
_allRecords,
'UP Desti' //Your SharePoint column name – the column you want to display as a selection.
),
"Value",
SortOrder.Ascending
)
)
This is the gallery code: where "UP Desti" is yellow with that issue:
Filter(
'Cartera proves diagnostiques 2026_final',
(IsBlank(ComboBox_Origen1.Selected)
|| UPOrigen.Value = ComboBox_Origen1.Selected.Value
)
&&
(IsBlank('ComboBox_Codi/Descripció'.Selected)
|| 'Codi/Descripció' = 'ComboBox_Codi/Descripció'.Selected.Value
)
&&
(IsBlank('ComboBox_UP/Destí'.Selected)
|| 'UP Desti' = 'ComboBox_UP/Destí'.Selected.Value
)
)
