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.
