Combine Filter and sort in PowerApps

Hi christina_hoeglinger,

I don't know how to combine those functions either but, for the search bar you can use code similar to below:

SortByColumns(Filter([@'Site Security - Detail'],StartsWith(Member.DisplayName,TextSearchBox1.Text),Current.Value="Yes"),"Title",If(SortDescending1,Descending,Ascending))

Where:

• [@'Site Security - Detail'] is OOSListAT
• Member.DisplayName is the column name you want to search for
• TextSearchBox1.Text is the name of the search box

In my app it sorts as expected. Hopefully this will work for you as well.

I hope this helps.

Norm