Unanswered

Combining 3 collections into one collection

(0) Share

Report

Posted on by Oskarkuus

1,097

I have 3 collections that is created like this:
ClearCollect(col_Name;Split(TextInput5.Text;Char(10)))
ClearCollect(col_ID;Split(TextInput5_1.Text;Char(10)))
ClearCollect(col_UserName;Split(TextInput5_2.Text;Char(10)))

How can i combine these 3 collections into a new collections with 3 columns (Name, ID, UserName)?

I cant see how i can lookup a value from one column and map that...

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

timl 36,393 Super User 2025 Season 2 on at

Like (1)

Report
@Oskarkuus

I'm not sure how your input data looks like but I suspect you're looking for something like this:

ForAll( Sequence(CountRows(col_Name)), { RegionCode:Index(col_Name, Value).Result, RegionCode:Index(col_ID, Value).Result, RegionDesc:Index(col_UserName, Value).Result } )

Was this reply helpful? Yes No
WiZey 3,023 Moderator on at

Like (1)

Report
Hello @Oskarkuus ,

I tried something on my side. I have three collections clt1, clt2 and clt3.

ClearCollect(clt1;["a";"b";"c"]);; ClearCollect(clt2;["d";"e";"f"]);; ClearCollect(clt3;["g";"h";"i"]);;

I can combine them this way:

ClearCollect( clt4; ForAll( Sequence( Max( CountRows(clt1); CountRows(clt2); CountRows(clt3) ) ); { Name: Index( clt1; Value ).Value; ID: Index( clt2; Value ).Value; UserName: Index( clt3; Value ).Value } ) )

Supposing your items are in order in each collection, "Index()" allows you to retrieve each item sharing the same row's ID.

Hope this was helpful to you.

Was this reply helpful? Yes No