Unanswered

Join multiple collections with different field names (specify what field in each collection would need to be appended)

(0) Share

Report

Posted on by iKettle

Hi Guys, I have 4 different collections I would like to append into one. The 4 collections are from a different sharepoint lists and they have different field name (although the content can be similar, meaning data type). What formula would I use to be able to append the fields so that I can specify which fields (columns) should fall under a single renamed column in the output collection?

So as an example, collection1 has field called Status and UpdateComments, collection 2 has StatusStage and Comments, collection 3 has ReviewStatus and UpdateRemarks and collection 4 has Stage and StatusUpdate. What would be the formula I would use to create the output collection and append these field so that I have in the output collection Status and Comments only?

I will extend this to other fields within the 4 collections, but I wanted to get an idea of what the formula would be to create this output collection?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@iKettle

You would need a common field in each collection. Then start with the collection containing the most fields and use AddColumns() to add the other columns using a LookUp().

Was this reply helpful? Yes No
iKettle 95 on at

Like (0)

Report
Copy link

Link copied!

What I am trying to do is just to add rpows of data and specify where these need to be within which column from the 4 different collection. Like append records, as the type of data is similar for each field. I dont need to lookup anything, I just want to add collection but specify which field from the different collections should be in order.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@iKettle

If the field names and the structure of the collections are exactly the same, you can simply

Collect(CollectionNew, Collection1, Collection2, Collection3, Collection4)

If the names or structure are different, you can use the RenameColumns() and ShowColumns() or DropColumns() functions to reshape the collections until they match name and structure before combining them. You can then Sort() the new collection,

Was this reply helpful? Yes No