Announcements
I am stuck with a very basic problem. I have two collections
Collection1
Name
------
name1
Collection2
Email
email1
email2
I want to merge these two into one collection as following:
Collection3
Name Email
-------------------
name 1 email1
name2 email2
Any ideas? Thanks in advance.
@asifkhawaja Try this,
ClearCollect(colName, {Name:"Tom"}, {Name:"Mark"}, {Name:"John"}); ClearCollect(colEmail, {Email:"emailTom"}, {Email:"emailMark"}, {Email:"emailJohn"}); ClearCollect(colCombinedNameEmail, ForAll(Sequence(CountRows(colName)), ({Name:First(LastN(colName,ThisRecord.Value)).Name, Email:First(LastN(colEmail,ThisRecord.Value)).Email})))
Of course, of course! Thank you so much. You made my day!
@asifkhawaja Glad to help!
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Valantis 392
WarrenBelz 364 Most Valuable Professional
Kalathiya 271 Super User 2026 Season 1
