Skip to main content
Community site session details

Community site session details

Session Id : aB4+HM5LtqIIkmIHIa42gr
Power Apps - Building Power Apps
Unanswered

Filtering gallery doesn't show all rows

Like (0) ShareShare
ReportReport
Posted on 5 May 2024 14:26:51 by 28

Hi,

 

Using this: 

Filter(
 Avlarmningslista,
 Or(
 StartsWith(
 Title,
 TextInput1.Text
 ),
 TextInput1.Text in Larmobjekt.Value
 )
)

 

It kind of works, it filters by name (title) or Value in multi-choice column 'Larmobjekt'. However, when I search for a choice in the lower rows it can't find it. But I can see those rows if I scroll down the gallery manually. How do I get the filter to return all rows matching the text input? I only have 113 items in the list.

 

On a related note, I'm note sure if I'm passing the 2000 item row limit later so I tried to find a delegable way to filter the multi-choice + text columns. I couldn't find one that worked, is there a way?

  • Gochix Profile Picture
    1,933 Moderator on 06 May 2024 at 07:40:01
    Re: Filtering gallery doesn't show all rows

    @b1t1 ,

     

    You can try:

    With(
     {
     _FilteredData: Filter(
     Avlarmningslista,
     TextInput1.Text = Title
     )
     },
     If(
     IsBlank(TextInput1.Text),
     Filter(
     Avlarmningslista,
     Dropdown2.Selected.Value in Larmobjekt.Value
     ),
     Filter(
     _FilteredData,
     Dropdown2.Selected.Value in Larmobjekt.Value
     )
     )
    )


    _____________________________________________________________________________________
    Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!

  • b1t1 Profile Picture
    28 on 05 May 2024 at 17:38:46
    Re: Filtering gallery doesn't show all rows

    I found the issue, but I don't know how to solve it. It needs to be an exact match, if correct, it could show any row.

     

    But StartsWith doesn't seem to work on multi-choice column, it would also only return if the first choice is a match.. How do I filter the choice column by simply containing the input text search?

  • b1t1 Profile Picture
    28 on 05 May 2024 at 15:55:25
    Re: Filtering gallery doesn't show all rows

    1) The choices are to the left on the image, filtered list to the right. With this added dropdown as filter I could find all rows. But not in a combined search textinput (code in first post).

     

    b1t1_0-1714924172647.png

     

    I modified the filtering to check both text inputs (search field  + dropdown as follows), but I'd prefer to use a combined search.

     

    Filter(
     Avlarmningslista,
     And(
     StartsWith(
     Title,
     TextInput1.Text
     ),
     Or(
     IsBlank(DropdownCanvas2.Selected.Value),
     DropdownCanvas2.Selected.Value in Larmobjekt.Value
     )
     )
    )

     

    2) No, not different. The rows with VAK doesn't show up at all when using the first combined filter since they are "last" in order in the original list. I think the top 80 rows (I have about 113 rows) something are shown when filtering choice values, when filtering names I can find all rows by typing a specific name.

  • Gochix Profile Picture
    1,933 Moderator on 05 May 2024 at 15:05:26
    Re: Filtering gallery doesn't show all rows

    @b1t1 ,

     

    1) Could you give the Choice column options you have?

    Also, you will more likely get the delegation warning that it could not work correctly in large data sets. Unless you collect the data in app collection.
    2) Are these "lower rows" any different than "upper rows"?

    _____________________________________________________________________________________
    Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410 Super User 2025 Season 2

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 2

Loading complete