Merge two different collections

(0) Share

Report

Posted on by Dhinesh28R

599

Hi,

I have a two different collections with different columns.

This is my collections,

1st collection

Name	Mail
Suresh	Suresh@test.com
Dani	Dani@test.com

2nd collection

Department

Java

Web Development

Now i need to merge this collection like following,

Name	Mail	Department
Suresh	Suresh@test.com	Java
Dani	Dani@test.com	Web Development

This is what i need.

How to merge this two collections?

Thanks,

Dhinesh

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

WarrenBelz 156,386 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Dhinesh28R ,

How do you know which Department from Collection 2 belongs to the user in Collection 1?

Was this reply helpful? Yes No
Dhinesh28R 599 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz ,
That's what am asking this post. There is no relation between this two collection.
Is this possible?

Thanks,
Dhinesh

Was this reply helpful? Yes No
WarrenBelz 156,386 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Dhinesh28R ,

No - how do you expect the system to know where to put the values?

Was this reply helpful? Yes No
Dhinesh28R 599 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz ,
Now i made a change in my 2nd collection like this,
Mail Department
Suresh@test.com Java
Dani@test.com Web Development

Now this is possible to link two collections?

Thanks,
Dhinesh

Was this reply helpful? Yes No
Verified answer

WarrenBelz 156,386 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
@Dhinesh28R ,

Change the field name on Collection 2 to something else (I have used EMailAddress) and the below should work

ClearCollect( Collection3, AddColumns( Collection1, "Department" Lookup( Collecton2, EmailAddress=Mail ).Department ) )

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.

Was this reply helpful? Yes No