Gallery Filter and Sort (with avoiding Delegation Issues)

(2) Share

Report

Posted on by CU10041356-0

I have a Gallery that is connected to a Sharepoint List "HMH Administrators List"

The Gallery gets it's values from a Dropdown called :

scr04_drpAccountsActiveFilter

In the list are 3 Columns :

Active (Yes/No Text Column)

HMHAdministratorsEmail (Text Colum)

HMHAdministratorsDisplayName (Text Column)

which are populated from an Office365User patch process.

I want to sort the Gallery into Ascending order of the HMHAdministratorsDisplayName value.

When the Screen is opened "Screen On Visible" i define a Collection :

ClearCollect(collectAdministratorFilterChoices, ["All","Yes","No"]);

Which adds "All" to a Dropdown Box Item list (scr04_drpAccountsActiveFilter)

On the Gallery Item choice i added this code:

SortByColumns('HMH Administrators List',"HMHAdministratorsDisplayName",SortOrder.Ascending

which seemed to work (hopefully avoiding delegation issues too)

i tried adding this code too but get an error. (not sure how to use both code snippets together. As i get an error that is vague, i don't understand it and can't use it.

If(scr04_cmbAccountsActiveFilter.Selected.Value="All",'HMH Administrators List',Filter('HMH Administrators List',Active=scr04_drpAccountsActiveFilter.Selected.Value))

Basically is there a way to add these two snippets together on the Gallery Item and still avoid delegation issues. I want all Filter choices "All","Yes","No" to be filtered ascending on the HMHAdministrationDisplayName column.

SortByColumns('HMH Administrators List',"HMHAdministratorsDisplayName",SortOrder.Ascending

and

If(scr04_cmbAccountsActiveFilter.Selected.Value="All",'HMH Administrators List',Filter('HMH Administrators List',Active=scr04_drpAccountsActiveFilter.Selected.Value))

or an alternative more than appreciated. My skills are limited at the moment.

Thanks

Categories:

Building Power Apps

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Suggested answer

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

Like (1)

Report
Copy link

Link copied!

@CU10041356-0,

With(

    {

        _filteredData:

            If(

                scr04_drpAccountsActiveFilter.Selected.Value = "All",

                'HMH Administrators List',

                Filter(

                    'HMH Administrators List',

                    Active = scr04_drpAccountsActiveFilter.Selected.Value

                )

            ),

        _searchedData:

            If(

                IsBlank(txtSearch.Text),

                _filteredData,

                Filter(

                    _filteredData,

                    StartsWith(HMHAdministratorsDisplayName, txtSearch.Text)

                )

            )

    },

    SortByColumns(

        _searchedData,

        "HMHAdministratorsDisplayName",

SortOrder.Ascending

    )

)

I always refer the article from @WarrenBelz when the topic is about the delegation. This formula (Power Fx) has been extended to your logic based on his previous implementation and i believe this will works

Blog of Delegation : https://www.practicalpowerapps.com/category/delegation/

✅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
CU10041356-0 86 on at

Like (0)

Report
Copy link

Link copied!

Many thanks for the assistance and have noted the link.

However it fails from :

_searchedData:

            If(

                IsBlank(txtSearch.Text),

                _filteredData,

                Filter(

                    _filteredData,

                    StartsWith(HMHAdministratorsDisplayName, txtSearch.Text)

                )

            )

    },

    SortByColumns(

        _searchedData,

        "HMHAdministratorsDisplayName",

SortOrder.Ascending

    )

)

Name isn't valid. 'txtSearch' isn't recognised.

Name isn't valid '_filteredData' isn't recognised.

Any ideas? Don't know how this really works, so a bit stuck.

Was this reply helpful? Yes No
Verified answer

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

Like (1)

Report
Copy link

Link copied!

@CU10041356-0,

I understood the requirement you have drop down to filter records and search box as well to filter the records so based on that logic the below code was provided here you need to replace txtSearch with your actual textbox name (actual control name.Text) if the text box exists.

If there is no textbox control then try with the below formula and also please provide the UI for finer solutions

With(

    {

        _filteredData:

            If(

                scr04_drpAccountsActiveFilter.Selected.Value = "All",

                'HMH Administrators List',

                Filter(

                    'HMH Administrators List',

                    Active = scr04_drpAccountsActiveFilter.Selected.Value

                )

            )

    },

    SortByColumns(

        _filteredData,

        "HMHAdministratorsDisplayName",

        SortOrder.Ascending

    )

)

✅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
CU10041356-0 86 on at

Like (0)

Report
Copy link

Link copied!

Sorry no.

I am not searching on the Gallery.

Just a Dropdown which Filters "All","Yes","No"

Will try what you suggested.

Thanks again.

Was this reply helpful? Yes No
CU10041356-0 86 on at

Like (0)

Report
Copy link

Link copied!

That worked great - thank you so much.

Was this reply helpful? Yes No