Filter one combobox with other 2 comboboxes values

(0) Share

Report

Posted on by Charlie Martharper

943 Season of Giving Solutions 2025

Hi guys!

So I have 3 combo boxes, the first from a choice type column in a sharepoint.

Choices([@'Guia derivacions 04.12.25'].AGA)


The other that filters the first combo box, with plain text column with this formula:
Filter(With(
    {
        _allRecords: Filter(
            'Guia derivacions 04.12.25',   //Your SharePoint List - Please replace if it's wrong
            AGA.Value = ComboBox_AGA.Selected.Value //AGA Combobox name - Replace 'AGAComboBox' your combobox control name
        )
    },
    SortByColumns(
        Distinct(
            _allRecords,
            ESPECIALITAT //Your SharePoint Column Name - Which you want to saw as selection
        ),
        "Value",
        SortOrder.Ascending
    )
), Value = ComboBox_AGA.Selected.Value)
 
But now I have a third combo box that should be able to filter the value from the first combo box, and second combo box, and returns less values from the sharepoint list.
 
How does the formula look like? Then, the values available it will be shown in the gallery below them.

Categories:

Connector development

I have the same question (0)

All responses (3)

Answers (2)

Sort by

Verified answer

Kalathiya 2,456 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hello @Charlie Martharper,

Please try below code:

Combobox 3: Item Property:

With( { _allRecords: Filter( 'Guia derivacions 04.12.25', //Your SharePoint List - Please replace if it's wrong AGA.Value = AGAComboBox.Selected.Value, //AGA Combobox name - Replace 'AGAComboBox' your combobox control name ESPECIALITAT = SecondComoboBox.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, ESPECIALITAT //Your SharePoint column name – the column you want to display as a selection. ), "Value", SortOrder.Ascending ) )

If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.

---------------------------------------------------------------------------------

📩 Need more help? Mention @Kalathiya anytime!
✔️ Don’t forget to Accept as Solution if this guidance worked for you.
💛 Your Like motivates me to keep helping!

Was this reply helpful? Yes No
Charlie Martharper 943 Season of Giving Solutions 2025 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Kalathiya

I am using one of this but I am having trouble with some of them. Let me explain.

One of the comboboxes is a choice column from an SP list, but when adding it there, it returns this error:

The same happens with a gallery that shows the options filtered with the comboboxes, the = is red:

The full code is this:

Filter(

Circuits_territorials_03_2026,

(IsBlank(ComboBox_Origen1_1.Selected)

|| UP_Origen.Value = ComboBox_Origen1_1.Selected.Value

)

&&

(IsBlank(ComboBox_ParaulaClau.Selected)

|| Paraula_clau = ComboBox_ParaulaClau.Selected.Value

)

&&

(IsBlank('ComboBox_NomCircuit'.Selected)

|| Nom_Circuit = 'ComboBox_NomCircuit'.Selected.Value

)

)

The column in SP with the choices.

Why is this going wrong in this case?

I think it is because it's type choice... but dont really know how to solve it. I need both things to work to show the gallery options available

Was this reply helpful? Yes No
Verified answer

Kalathiya 2,456 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hello @Charlie Martharper,

#1.

Directly selecting distinct values from a multiple‑select column is not possible, but there are some workarounds you can try. Please see the suggestions below and give them a try. (I'm assuming that you want to show distinct value only from this column (Paraula_clau)

Sort( Distinct( Ungroup( _allRecords, Paraula_clau ), Value ), Value )

#2.

Paraula_clau column filter is giving an error because it’s a multiple-choice selection. It won’t work this way; please refer to the updated formula

Filter( Circuits_territorials_03_2026, (IsBlank(ComboBox_Origen1_1.Selected) || UP_Origen.Value = ComboBox_Origen1_1.Selected.Value ) && (IsBlank(ComboBox_ParaulaClau.Selected) || ComboBox_ParaulaClau.Selected.Value in Paraula_clau.Value ) && (IsBlank('ComboBox_NomCircuit'.Selected) || Nom_Circuit = 'ComboBox_NomCircuit'.Selected.Value ) )

If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.

Was this reply helpful? Yes No