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 Pro Dev & ISV

I have the same question (0)

All responses (5)

Answers (0)

v-bofeng-msft on at

Like (0)

Report
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

Was this reply helpful? Yes No
ivandgreat 43 on at

Like (0)

Report

still unable to work using filter.

Was this reply helpful? Yes No
TuongDoan 573 Moderator on at

Like (0)

Report

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!

Was this reply helpful? Yes No
ivandgreat 43 on at

Like (0)

Report

this doesn't work for me, since it has a delegation error working on large dataset.

Was this reply helpful? Yes No
ridhan 158 on at

Like (0)

Report

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

Thanks

Was this reply helpful? Yes No