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 / Remove filter options ...
Power Apps
Suggested Answer

Remove filter options from the gallery

(2) ShareShare
ReportReport
Posted on by 42
I have a gallery filter with searchbox and combobox which is working fine. Code below. 
 
Currently the Combobox filter Select All filters out all the status i.e. "Yet to Start", "Pending", "Completed". I want to remove the status "Completed" from the Select All filter. May i know how to do this?
 
Gallery Items
 
With(
    {
        _activerequests1: Filter(
            'Datasource',
            'Created By'.Email = User().Email && (Len(ComboBox2_1.Selected.Value) = 0 || ComboBox2_1.Selected.Value = "Select All" || Status.Value = ComboBox2_1.Selected.Value)
        )
    },
    SortByColumns(
        Filter(
            _activerequests1,
            Len(TextInput1_2.Text) = 0 || TextInput1_2.Text in Title || TextInput1_2.Text in LookUp(
                Finance,
                ID = 'Fin ID',
                'Created By'.DisplayName
            )
        ),
        varsortcolumn,
        varsortdirection
    )
)
 
I have the same question (0)
  • WarrenBelz Profile Picture
    154,749 Most Valuable Professional on at
    If I am interpreting your requirement correctly, something like this: -
    With(
       {
          _activerequests1: 
          Filter(
             'Datasource',
             'Created By'.Email = User().Email && 
             (
                Len(ComboBox2_1.Selected.Value) = 0 || 
                (
                   ComboBox2_1.Selected.Value = "Select All" &&
                   (
                      Status.Value = "Yet to Start" ||
                      Status.Value = "Pending
                   )
                ) || 
                Status.Value = ComboBox2_1.Selected.Value
             )
          ),
          _Created:
          LookUp(
             Finance,
             ID = 'Fin ID',
             'Created By'.DisplayName
          )
       },
       SortByColumns(
          Filter(
             _activerequests1,
             Len(TextInput1_2.Text) = 0 ||
             TextInput1_2.Text in Title || 
             TextInput1_2.Text in _Created
          ),
          varsortcolumn,
          varsortdirection
       )
    )
     
    Please Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like
    Visit my blog
    Practical Power Apps    LinkedIn  
  • CU19031426-0 Profile Picture
    3 on at
    Hello @PowerUser,
     
    Not sure will this work for your need. You could try this

    Status.Value <> "Completed"
     
    Something like below (Try to use it in AND Filter.
     
    Filter(
                'Datasource',
                'Created By'.Email = User().Email && Status.Value <> "Completed" &&  (Len(ComboBox2_1.Selected.Value) = 0 || ComboBox2_1.Selected.Value = "Select All" || Status.Value = ComboBox2_1.Selected.Value)
            )
     
    Let me know if this solves your answer, if it does kindly mark, it as an answer
  • karthikt29 Profile Picture
    18 on at
    Hello @PowerUser,
     
    Not sure will this work for your need. You could try this

    Status.Value <> "Completed"
     
    Something like below (Try to use it in AND Filter.
     
    Filter(
                'Datasource',
                'Created By'.Email = User().Email && Status.Value <> "Completed" &&  (Len(ComboBox2_1.Selected.Value) = 0 || ComboBox2_1.Selected.Value = "Select All" || Status.Value = ComboBox2_1.Selected.Value)
            )
     
    Let me know if this solves your answer, if it does kindly mark, it as an answer
  • Suggested answer
    MS.Ragavendar Profile Picture
    6,245 Super User 2026 Season 1 on at
     
    Can you please try this formula.
     
    With(
        { varStatus: ComboBox2_1.Selected.Value },
     
        With(
            {
                _base: Filter(
                    'Datasource',
                    'Created By'.Email = User().Email
                )
            },
     
            SortByColumns(
                Filter(
                    If(
                        IsBlank(varStatus) ||varStatus= "Select All",
                        // exclude Completed
                        Filter(_base, Status.Value <> "Completed"),
                        // Case 2: Specific status → match exact
                        Filter(_base, Status.Value =varStatus)
                    ),
                    Len(TextInput1_2.Text) = 0 ||
                    TextInput1_2.Text in Title ||
                    TextInput1_2.Text in LookUp(
                        Finance,
                        ID = 'Fin ID',
                        'Created By'.DisplayName
                    )
                ),
                varsortcolumn,
                varsortdirection
            )
        )
    )
     
    ✅If this helped, please Accept as Solution to help others ❤️ A Like is appreciated 🏷️ Tag @MS.Ragavendar for follow-ups.
  • WarrenBelz Profile Picture
    154,749 Most Valuable Professional on at
    A quick follow-up to see if you received the answer you were looking for. Happy to assist further if not.
     
    Please Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
    Visit my blog
    Practical Power Apps    LinkedIn   
  • MS.Ragavendar Profile Picture
    6,245 Super User 2026 Season 1 on at
     
    A quick follow-up to see, does the suggestion worked for you or still you were looking for any other approaches or assistance.
     
    ✅If this helped, please Accept as Solution to help others ❤️ A Like is appreciated 🏷️ Tag @MS.Ragavendar for follow-ups.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 482 Most Valuable Professional

#2
11manish Profile Picture

11manish 459

#3
Haque Profile Picture

Haque 331

Last 30 days Overall leaderboard