Unanswered

Filter gallery using Multiline Textinput

(1) Share

Report

Posted on by ivandgreat

I have a gallery, usually im using a textinput to filter my gallery which my filter/search is working fine.

But if i wanted to filter my gallery using a multiline textinput, i'm having a trouble to get the filtering or searching works.

this is my textinput example

C1512
C1108
C0880
C4667

i wanted to filter my gallery based on this values for each lines.

my code that im working now ,

With(
{
pasteData: Filter(
Split(
txtSearchCap_1.Text,
Char(10)
),
!IsBlank(Value)
)
},
ForAll(
pasteData As Y,
Collect(
ColText,
Search(
AddColumns(
Transport,
SITE,
'Site ID'
),
Y.Value,
SITE
)
)
)
)

Anyone could help me out to work on this. TIA.

Categories:

Power Apps component framework

All responses (5)

Answers (0)

ridhan 158 on at

Like (0)

Report

Filter gallery using Multiline Textinput

Can you please share the code if it is working for you as i am also looking the same.

Thanks
ivandgreat 43 on at

Like (0)

Report

Re: Filter gallery using Multiline Textinput

this doesn't work for me, since it has a delegation error working on large dataset.
TuongDoan 550 Super User 2025 Season 1 on at

Like (0)

Report

Re: Filter gallery using Multiline Textinput

Try this:

---------------------------
If the solution I provided assisted you in resolving this issue, kindly select "Accept as solution" This will help others in finding the solution more expediently 😄Also, a Thumbs up would be a great compliment!
ivandgreat 43 on at

Like (0)

Report

Re: Filter gallery using Multiline Textinput

still unable to work using filter.
v-bofeng-msft on at

Like (0)

Report
Re: Filter gallery using Multiline Textinput

Hi @ivandgreat ,

You could use a combination of Filter and in to perform fuzzy queries directly.

Filter(Transport,'Site ID' in txtSearchCap_1.Text)

Best Regards,

Bof