web

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

News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps How to join two collec...

Power Apps - Building Power Apps

Answered

How to join two collections with different rows without common column in Power Apps?

Like (0) Share

Report

Report

Posted on 17 Sep 2021 08:01:13 by Harpreet_Tohra

70

Suppose I have collection1 in power apps

name

age

###	###
***	***

And another collection2

date

time

class

group

a

b

c

d

now I want to create new collection i.e. collection3 like this:

name

age

date

time

class

group

###	###	a	b	c	d
***	***	a	b	c	d

how can I achieve this collection3?

Categories:

Using Apps Using Formulas

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

v-qiaqi@microsoft.com on 20 Sep 2021 at 08:47:16

Like (0)

Report
Re: How to join two collections with different rows without common column in Power Apps?

Hi @Harpreet_Tohra,

Have you solved your problem?

Do you want to merge two collections into a new collection?

I have made a demo for you, please add a button and set the OnSelect as below:

ClearCollect( collection3, Ungroup( Ungroup( Ungroup( Ungroup( AddColumns( collection1, "date", collection2.Date, "time", collection2.Time, "class", collection2.Class, "group", collection2.Group ), "class" ), "date" ), "group" ), "time" ) )
WarrenBelz 148,894 Most Valuable Professional on 17 Sep 2021 at 08:44:18

Like (0)

Report

Re: How to join two collections with different rows without common column in Power Apps?

Hi @Harpreet_Tohra ,

This blog of mine may be of assistance.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.