Filtering gallery doesn't show all rows

(0) Share

Report

Posted on by b1t1

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?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Gochix 1,937 Moderator on at

Like (0)

Report
Copy link

Link copied!

@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!

Was this reply helpful? Yes No
b1t1 28 on at

Like (0)

Report
Copy link

Link copied!
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).

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.

Was this reply helpful? Yes No
b1t1 28 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Gochix 1,937 Moderator on at

Like (0)

Report
Copy link

Link copied!
@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!

Was this reply helpful? Yes No