web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Merge two collections

Power Apps

Unanswered

Merge two collections

(0) Share

Report

Report

Posted on by OK29

388

I Have two Collection, I am trying to merge these two collections as shown below. Please advice.

Col1

CityId Name

1 A

2 B

Col2

Id City

3 C

4 D

Output:

Col3

CityId Name

1 A

2 B

3 C

4 D

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Anonymous_Hippo 1,247 Super User 2024 Season 1 on at

Like (1)

Report
Hello @aaedla ,

This is very easy

ClearCollect(Col3,Col1,RenameColumns(Col2,"Id","CityID","City","Name"))

Cheers !

Was this reply helpful? Yes No
Bilakanti 1,226 on at

Like (0)

Report
@aaedla You can use the below code.
ClearCollect( col1, { CityId: 1, Name: "A" }, { CityId: 2, Name: "B" } ); ClearCollect( col2, { Id: 3, City: "C" }, { Id: 4, City: "D" } ); ForAll( RenameColumns( col2, "Id", "CityId", "City", "Name" ) As c, Patch( col1, Defaults(col1), c ) )

Was this reply helpful? Yes No

Join the conversation