cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MashaOvchar
Frequent Visitor

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

Hi community, 

 

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

tempsnip.png

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.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Alex_10
Memorable Member
Memorable Member

@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()
)

 

 

View solution in original post

2 REPLIES 2
Alex_10
Memorable Member
Memorable Member

@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()
)

 

 

@Alex_10 Yes! Thank you!

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (1,697)