Answered

Add All Filter in Gallery which should show all records

(2) Share

Report

Posted on by Poweruser32490

156

I have a Gallery filter which is showing records based on combobox selections. If i select combobox value as My Request/Boss View, it shows respective records. Below is the code for the same. I need to add a All option in combobox which should show me all the records which is being shown in My Request and Boss View. May i know how to implement the same?

Gallery Items

With(
    {
        _activerequests: SortByColumns(
            Filter(
                'Users',
                (Len('ETypeCB'.Selected.Value) = 0 || 'Employee Type'.Value = ETypeCB.Selected.Value) && (Len('LocationCB'.Selected.Name) = 0 || Location.Value = LocationCB.Selected.Name) && (Len(SwitchCB.Selected.Value) = 0 || (SwitchCB.Selected.Value = "My Request" && AdUser.Email = User().Email) || (SwitchCB.Selected.Value = "Boss View" && (Manager.Email = User().Email ))) && (StartsWith(
                    'First Name',
                    SearchBox.Text
                ) || StartsWith(
                    'Last Name',
                    SearchBox.Text
                ) || StartsWith(
                    Company,
                    SearchBox.Text
                ))
            ),
            "Modified",
            SortOrder.Descending
        )
    },
    SortByColumns(
        _activerequests,
        varsortcolumn,
        varsortdirection
    )
)

Categories:

Connector development

Error handling

GCC, GCCH, DoD - Federal App Makers (FAM)

Building Power Apps

Governance & administering

Experimental features

AI Builder

Microsoft Dataverse with Power Apps

Power Apps Pro Dev & ISV

Power Query

General topics

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

11manish 4,376 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Yes. You can add an "All" option quite easily without changing the overall structure of your Gallery formula.

Try below :

With( { _activerequests: SortByColumns( Filter( 'Users', (Len(ETypeCB.Selected.Value) = 0 || 'Employee Type'.Value = ETypeCB.Selected.Value ) && (Len(LocationCB.Selected.Name) = 0 || Location.Value = LocationCB.Selected.Name ) && ( Len(SwitchCB.Selected.Value) = 0 || SwitchCB.Selected.Value = "All" || ( SwitchCB.Selected.Value = "My Request" && AdUser.Email = User().Email ) || ( SwitchCB.Selected.Value = "Boss View" && Manager.Email = User().Email ) ) && ( StartsWith('First Name', SearchBox.Text) || StartsWith('Last Name', SearchBox.Text) || StartsWith(Company, SearchBox.Text) ) ), "Modified", SortOrder.Descending ) }, SortByColumns( _activerequests, varsortcolumn, varsortdirection ) )

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Valantis 7,236 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Poweruser32490,

Add this condition to your SwitchCB block:

(SwitchCB.Selected.Value = "All" && (AdUser.Email = User().Email || Manager.Email = User().Email))

So the full SwitchCB condition becomes:

(Len(SwitchCB.Selected.Value) = 0 ||
(SwitchCB.Selected.Value = "My Request" && AdUser.Email = User().Email) ||
(SwitchCB.Selected.Value = "Boss View" && Manager.Email = User().Email) ||
(SwitchCB.Selected.Value = "All" && (AdUser.Email = User().Email || Manager.Email = User().Email)))

Then add "All" as an option in your SwitchCB combobox items.

Best regards,

Valantis ✅ If this helped solve your issue, please Accept as Solution so others can find it quickly.

❤️ If it didn’t fully solve it but was still useful, please click “Yes” on “Was this reply helpful?” or leave a Like :).

🏷️ For follow-ups @Valantis.

📝 https://valantisond365.com/

💼 LinkedIn ▶️ YouTube

Was this reply helpful? Yes No
Suggested answer

Haque 4,088 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Poweruser32490,

As a first step, let's bring the condition in the combox for "All". We can do it by adding all this way for combobox Items property:

["All", "My Request", "Boss View"] //-- Array of string.

Now, we need to add a condition that will check if the combox selection is All. So, logically if "All" is being selected, we will include the records that satisfy either "My Request" or "Boss View".

( SwitchCB.Selected.Value = "All" && ( AdUser.Email = User().Email || Manager.Email = User().Email ) )

Here is the full update for the same:

With( { _activerequests: SortByColumns( Filter( 'Users', (Len('ETypeCB'.Selected.Value) = 0 || 'Employee Type'.Value = ETypeCB.Selected.Value) && (Len('LocationCB'.Selected.Name) = 0 || Location.Value = LocationCB.Selected.Name) && ( (SwitchCB.Selected.Value = "All" && (AdUser.Email = User().Email || Manager.Email = User().Email)) || (SwitchCB.Selected.Value = "My Request" && AdUser.Email = User().Email) || (SwitchCB.Selected.Value = "Boss View" && Manager.Email = User().Email) ) && ( StartsWith('First Name', SearchBox.Text) || StartsWith('Last Name', SearchBox.Text) || StartsWith(Company, SearchBox.Text) ) ), "Modified", SortOrder.Descending ) }, SortByColumns( _activerequests, varsortcolumn, varsortdirection ) )

Was this reply helpful? Yes No