how to add filter with search and sort in powerapps

[Ashok2]

how can add filter column name "delete" equals "no" in below powerapps syntax for gallery item

SortByColumns(Search(AddColumns( 'SP_List', "EmpText", 'Team Member'.DisplayName ),TextInput1.Text,"EmpText","Title"),"Modified",Descending)

[RandyHayes · Accepted solution]

@Ashok2 

Please consider changing your Formula to the following:

SortByColumns(
    Search(
        AddColumns(
            Filter('SP_List', delete="no"),
            "EmpText", 'Team Member'.DisplayName 
        ),
        TextInput1.Text, "EmpText", "Title"
    ),
    "Modified",Descending
)

I hope this is helpful for you.