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

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Get multiple filter fr...
Power Apps
Answered

Get multiple filter from combo boxes into gallery values

(0) ShareShare
ReportReport
Posted on by Charlie Martharper 943 Season of Giving Solutions 2025
Hi!
 
I have 3 combo boxes that gets values from SP list and I want to get all of them as filter into the gallery, right now I have just one, but I need to filter the 3 of them. How could I do it?
The formula I have is this one:
 
Filter(
    'Guia derivacions 04.12.25', 
    ESPECIALITAT = ComboBox_Especialitat.Selected.Value
)
 
Which is the second combo box in the app.
Categories:
Connector development
I have the same question (0)
  • Suggested answer
    MS.Ragavendar Profile Picture
    MS.Ragavendar 7,431 Super User 2026 Season 1 on at
     
    Filter(
        'Guia derivacions 04.12.25',
        // AGA filter (ignore if no selection)
        (IsBlank(ComboBox_AGA.Selected)
            || AGA = ComboBox_AGA.Selected.Value  // If SharePoint column is Choice: use .Value
            // If AGA is text: use  AGA = ComboBox_AGA.Selected.columnname(depending on Items binding)
        )
        &&
        // ESPECIALITAT filter (your current one, made optional)
        (IsBlank(ComboBox_Especialitat.Selected)
            || ESPECIALITAT = ComboBox_Especialitat.Selected.Value
        )
        &&
        // Unitat Tractament filter (ignore if no selection)
        (IsBlank(ComboBox_Unitat.Selected)
            || 'Unitat Tractament' = ComboBox_Unitat.Selected.Value
        )
    )
     
    ✅ Please click Accept as solution if my post helped you solve your issue and help others who will face the similar issue in future.
    ❤️ Please consider giving it a Like, If the approach was useful in other ways.
    🏷️ Please tag me @MS.Ragavendar if you still have any queries related to the solution or issue persists.
  • Charlie Martharper Profile Picture
    Charlie Martharper 943 Season of Giving Solutions 2025 on at
     
    I used your formula, the first one AGA is type column choice, other columns are plain text so I wrote it like this:
    Filter(
        'Guia derivacions 04.12.25',
        // AGA filter (ignore if no selection)
        (IsBlank(ComboBox_AGA.Selected)
            || AGA = ComboBox_AGA.Selected.Value  // If SharePoint column is Choice: use .Value
            // If AGA is text: use  AGA = ComboBox_AGA.Selected.columnname(depending on Items binding)
        )
        &&
        // ESPECIALITAT filter (your current one, made optional)
        (IsBlank(ComboBox_Especialitat.Selected)
            || ESPECIALITAT = ComboBox_Especialitat.Selected.columnname
        )
        &&
        // Unitat Tractament filter (ignore if no selection)
        (IsBlank(ComboBox_Prestacio.Selected)
            || MONOGRÀFIC = ComboBox_Prestacio.Selected.columnname
        )
    )
     
    Should I add where "columnname" the first part again? Like "ESPECIALITAT" and "MONOGRÀFIC"? 
    Lookin like that it doesn't show any result
  • Kalathiya Profile Picture
    Kalathiya 2,456 Super User 2026 Season 1 on at
     
    Please try this:
    Filter(
    'Guia derivacions 04.12.25',
    // AGA filter (ignore if no selection)
    (IsBlank(ComboBox_AGA.Selected)
        || AGA = ComboBox_AGA.Selected.Value  // If SharePoint column is Choice: use .Value
        // If AGA is text: use  AGA = ComboBox_AGA.Selected.columnname(depending on Items binding)
    )
    &&
    // ESPECIALITAT filter (your current one, made optional)
    (IsBlank(ComboBox_Especialitat.Selected)
        || ESPECIALITAT = ComboBox_Especialitat.Selected.Value
    )
    &&
    // Unitat Tractament filter (ignore if no selection)
    (IsBlank(ComboBox_Prestacio.Selected)
        || MONOGRÀFIC = ComboBox_Prestacio.Selected.Value
    )
)
     
     
    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
    Charlie Martharper 943 Season of Giving Solutions 2025 on at
     It returns me this error:
    With the others I don't have this issue:
     
  • Verified answer
    Kalathiya Profile Picture
    Kalathiya 2,456 Super User 2026 Season 1 on at
     
    Please find updated formula:
     
    Filter(
    'Guia derivacions 04.12.25',
    // AGA filter (ignore if no selection)
    (IsBlank(ComboBox_AGA.Selected)
        || AGA.Value = ComboBox_AGA.Selected.Value  // If SharePoint column is Choice: use .Value
        // If AGA is text: use  AGA = ComboBox_AGA.Selected.columnname(depending on Items binding)
    )
    &&
    // ESPECIALITAT filter (your current one, made optional)
    (IsBlank(ComboBox_Especialitat.Selected)
        || ESPECIALITAT = ComboBox_Especialitat.Selected.Value
    )
    &&
    // Unitat Tractament filter (ignore if no selection)
    (IsBlank(ComboBox_Prestacio.Selected)
        || MONOGRÀFIC = ComboBox_Prestacio.Selected.Value
    )
)
    If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.
  • Verified answer
    MS.Ragavendar Profile Picture
    MS.Ragavendar 7,431 Super User 2026 Season 1 on at
     
    I have one Query AGA  is what type of column ?
     
    A) AGA is single‑select Choice
     
    Filter(
        'Guia derivacions 04.12.25',
        // AGA (Choice, single-select)
        IsBlank(ComboBox_AGA.Selected)
            || AGA.Value = ComboBox_AGA.Selected.Value,
     
        // ESPECIALITAT (Text)
        IsBlank(ComboBox_Especialitat.Selected)
            || ESPECIALITAT = ComboBox_Especialitat.Selected.Value,
     
        // MONOGRÀFIC (Text) - note quotes for accent/space in column name if present
        IsBlank(ComboBox_Prestacio.Selected)
            || 'MONOGRÀFIC' = ComboBox_Prestacio.Selected.Value
    )
     
    B) AGA is Multi‑select Choice
     
    Filter(
        'Guia derivacions 04.12.25',
        // Keep row if any selected AGA value is present in this row’s AGA choices
        IsEmpty(ComboBox_AGA.SelectedItems)
            || CountIf(ComboBox_AGA.SelectedItems, Value in AGA.Value) > 0,
     
        IsEmpty(ComboBox_Especialitat.SelectedItems)
            || ESPECIALITAT in ComboBox_Especialitat.SelectedItems.Result,
     
        IsEmpty(ComboBox_Prestacio.SelectedItems)
            || 'MONOGRÀFIC' in ComboBox_Prestacio.SelectedItems.Result
    )
     
    ✅ Please click Accept as solution if my post helped you solve your issue and help others who will face the similar issue in future.
    ❤️ Please consider giving it a Like, If the approach was useful in other ways.
    🏷️ Please tag me @MS.Ragavendar if you still have any queries related to the solution or issue persists.

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

News and Announcements

Welcome to the Power Platform Communities

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

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans