How to search multiple item (Char10)

Like (0) Share

Report

Posted on 14 Mar 2025 11:39:19 by moerah

317

Hi All,

Im trying to see if its possible to search/filter through 4 SP list with a collection see example below

user entry 5 items in search box

ClearCollect(
    ColMultiItems,
    Split(
        TextInput2.Text,
        Char(10)
    )
);

With this collection i need to filter through 4 SP list

Combined SP list

ClearCollect(
    ColNEgal,NETHAllocation
);
ClearCollect(
    ColNWgal, NWTHAllocation
   
);
ClearCollect(
    ColSEgal, SETHAllocation
);
ClearCollect(
    ColSWgal,
    SWTHAllocation
);
ClearCollect(colAllGallLoc,ColNEgal,ColNWgal,ColSEgal,ColSWgal);

Thank you 🙂

Categories:

General Questions

All responses (2)

Answers (0)

moerah 317 on 14 Mar 2025 at 14:17:44

Like (0)

Report

How to search multiple item (Char10)

@Jacqui Muller Thank you for the reply

Yes, will need to use the large collection as it has all four locality

i just dont know how to filter with multiple item i can do it with one item and use startswith function to search cant do it for multiple hope that makes sense

thank you 😊
Jacqui Muller 46 on 14 Mar 2025 at 13:16:05

Like (0)

Report

How to search multiple item (Char10)

Hi @moerah

I hope you are well.

Do you need to know which list it is from? Is it possible to use the large collection and search from there?