web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Filter one combobox wi...
Power Apps
Answered

Filter one combobox with other 2 comboboxes values

(0) ShareShare
ReportReport
Posted on by 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:
I have the same question (0)
  • Verified answer
    Kalathiya Profile Picture
    2,456 Super User 2026 Season 1 on at
     
    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!
  • Charlie Martharper Profile Picture
    943 Season of Giving Solutions 2025 on at
     
    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
  • Verified answer
    Kalathiya Profile Picture
    2,456 Super User 2026 Season 1 on at
     
    #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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Valantis Profile Picture

Valantis 424

#2
WarrenBelz Profile Picture

WarrenBelz 355 Most Valuable Professional

#3
11manish Profile Picture

11manish 290

Last 30 days Overall leaderboard