Filter function seems correct, but gallery items do not filter properly?

[MashaOvchar]

Hi community, 

Can someone explain me where I went wrong? How come other items do not disappear when filtering through searchbox?

 

My formula:

ForAll(
Distinct(
'Updates', Summary),
LookUp(
SortByColumns(
Filter('Updates', Required = "Y", 
StartsWith(WorkInstructionNumber,TextSearchBox114_1.Text) || StartsWith(UnitDescription,TextSearchBox114_1.Text) || StartsWith(Location,TextSearchBox114_1.Text)), "Title",If(SortDescending1,Ascending,Descending)), Summary = Result))

I want the gallery to show me items with distinct values from column Summary (after filtering column Required = "Y") and to be able to filter through a couple of other columns WorkInstructionNumber, UnitDescription and Location via Searchbox.

[Alex_10 · Accepted solution]

@MashaOvchar 

if you are sure that your provided formula works well:

Filter(
    ForAll( Distinct('Updates', Summary),
        LookUp(
            SortByColumns(
                Filter('Updates', 
                    Required = "Y", 
                    StartsWith(WorkInstructionNumber, TextSearchBox114_1.Text) || StartsWith(UnitDescription, TextSearchBox114_1.Text) || StartsWith(Location, TextSearchBox114_1.Text)
                ), 
                "Title", If(SortDescending1, Ascending, Descending)
            ), 
            Summary = Result
        )
    ),
    Summary <> Blank()
)

[MashaOvchar]

@Alex_10 Yes! Thank you!