Hi @usaman45
The formula below will combine the 2 collections and show the distinct names/emails from both collections.
ClearCollect(CollectionA,
{Name: "User A", Email: "UserA@test.com"},
{Name: "User B", Email: "UserB@test.com"}
);
ClearCollect(CollectionB,
{Name: "User B", Email: "UserB@test.com"},
{Name: "User C", Email: "UserC@test.com"}
);
ClearCollect(FinalCollection,
DropColumns(
GroupBy(
Ungroup(Table(
{collection: CollectionA},
{collection: CollectionB}
),
"collection"
),"Name","Email","DistinctGroup"),
"DistinctGroup")
);
