Remove filter options from the gallery

(2) Share

Report

Posted on by Poweruser32490

126

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
    )
)

Categories:

Microsoft Dataverse with Power Apps

Power Query

Building Power Apps

Error handling

Connector development

General topics

I have the same question (0)

All responses (6)

Answers (0)

Sort by

WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(4)

Report
Copy link

Link copied!
Hi @Poweruser32490,

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

Was this reply helpful? Yes No
CU19031426-0 3 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
karthikt29 18 on at

Like
a
(1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

MS.Ragavendar 7,431 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@Poweruser32490,

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.

Was this reply helpful? Yes No
WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Poweruser32490,

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

Was this reply helpful? Yes No
MS.Ragavendar 7,431 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Poweruser32490,

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.

Was this reply helpful? Yes No