Power Apps - Building Power Apps

How to search multiple item (Char10)

Like (1) Share

Report

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

321

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 (6)

Answers (0)

moerah 321 on 16 Mar 2025 at 13:15:40

Like (1)

Report

How to search multiple item (Char10)

@KennyJ thank you for the reply,

that was my first approach but failed miserably, I got stuck and couldn’t retrieve the values from apply to each tried everything kept saying failed array, object etc... is their a blog or topic i can look for?
KennyJ 162 on 16 Mar 2025 at 02:00:33

Like (1)

Report

How to search multiple item (Char10)

I think you would actually be better to pass the search values to Power Automate which could then get the results from each SP list, join the data together and then pass you back the consolidated data you required to then store in you collection.
moerah 321 on 15 Mar 2025 at 20:24:08

Like (1)

Report
How to search multiple item (Char10)

@Jacqui Muller Hi

This is working for me see below, I know their must be a better way to do this

OverView:

Process

Step 1:

User inputs search criteria in textinput

on select search button:

ClearCollect(MyValues2, Split(TextInput2.Text, Char(10))); UpdateContext({TimerStartCol:true}); UpdateContext({selfdisable:DisplayMode.Disabled})

-------------------------------------------------------------------------------------------------

step 2: (Hidden)

stores in collection with row number (index)

Gallery Item:

With( { RowCollection: MyValues2 // Ensure data is properly assigned }, ForAll( Sequence(CountRows(RowCollection)), Patch( Last(FirstN(RowCollection, Value)), { rowIDNumber: Value } ) ) )

----------------------------------------------------------------------------------------------------

Step 3: (Hidden)

Look up gallery row number for each individual text label

Text Label1:

LookUp(MultiNHnumber.AllItems, rowIDNumber = 1).Value

Text Label 2:

LookUp(MultiNHnumber.AllItems, rowIDNumber = 2).Value

etc etc.....

side note(i want to avoid this or else have to create many labels)

--------------------------------------------------------------------------------------------------

Step 4 (Hidden)

Filter datasource based off step 3

SP list 1

gallery Item:

Filter( NETHAllocation, StartsWith(NHSnumber, Coalesce(NHnum1.Text)) || StartsWith(NHSnumber, Coalesce(NHnum2.Text)) || StartsWith(NHSnumber, Coalesce(NHnum3.Text)) )

SP List 2

gallery item

Filter( SWTHAllocation, StartsWith(NHSnumber, Coalesce(NHnum1.Text)) || StartsWith(NHSnumber, Coalesce(NHnum2.Text)) || StartsWith(NHSnumber, Coalesce(NHnum3.Text)) )

etc etc.......

------------------------------------------------------------------------------------------------

Side Step: (Hidden)

Timer End:

ClearCollect(colNEgallery, Gallery9.AllItems); ClearCollect(colSWgallery, Gallery9_1.AllItems); ClearCollect(colAllGallery, colNEgallery, colSWgallery);

-------------------------------------------------------------------------------------------------

Result

gallery Item:

colAllGallery

Thank you 😊
Suggested answer

Jacqui Muller 57 on 15 Mar 2025 at 15:58:14

Like (1)

Report

How to search multiple item (Char10)

Ohhhhhhh I see what you mean @moerah! The best option then might be to follow the join logic. So join the two collections using a group by.

// Filter

ClearCollect(
colFilteredResults,
Filter(
colAllGallLoc,
Title in ColMultiItems.Value // Assuming "Title" is the column you're searching in
)
);

// Group by

ClearCollect(
colGroupedResults,
GroupBy(
colFilteredResults,
"Source", // Change this if you want to group by another column
"GroupedItems"
)
);
moerah 321 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 57 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?