Power Platform Community Forum Thread Details

Hi!

So I have 3 combo boxes, the first one get choices from a column to filter the combobox "words" and the third combobox. The third combobox is the title of the item, and it should appear when the first combobox is selected (even if "words" is blank") but also filter if combobox "word" is selected.

The word item:

With(
    {
        _allRecords: Filter(
            'Circuits_territorials_03_2026',   //Your SharePoint List - Please replace if it's wrong
            UP_Origen.Value = ComboBox_Origen1_1.Selected.Value //AGA Combobox name - Replace 'AGAComboBox' your combobox control name
        )
    },
    SortByColumns(
        Distinct(
            _allRecords,
            Paraules_clau //Your SharePoint Column Name - Which you want to saw as selection
        ),
        "Value",
        SortOrder.Ascending
    )
)
 
The SortByColumns is wrong:
 
The Title item:
 
With(
    {
        _allRecords: Filter(
            Circuits_territorials_03_2026,   //Your SharePoint List - Please replace if it's wrong
            UP_Origen.Value = ComboBox_Origen1_1.Selected.Value //AGA Combobox name - Replace 'AGAComboBox' your combobox control name
        )
    },
    SortByColumns(
        Distinct(
            _allRecords,
            Nom_Circuit //Your SharePoint Column Name - Which you want to saw as selection
        ),
        "Value",
        SortOrder.Ascending
    )
)
 
Origen is first combobox, Paraula clau is words (3rd column SP) & nom circuit is Title (first column SP).
 
The column in the SP looks like this:
It is possible from the words in 3rd column to filter the first?
The idea is, they write words in the second combobox (third column in SP) which will filter the options in the third combobox (first column in SP)
The gallery is getting an error in paraules clau (text, 3rd column SP/2nd combobox):