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?
@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!
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?
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.
@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!
WarrenBelz
791
Most Valuable Professional
MS.Ragavendar
410
Super User 2025 Season 2
mmbr1606
275
Super User 2025 Season 2