web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Cross join or Cartesia...

Power Apps

Unanswered

Cross join or Cartesian Join of collections

(0) Share

Report

Report

Posted on by Community Power Pla...

Hi,

Is it possible to do cross join or Cartesian join of two collections with no relation in Powerapps ?

Eg: Table 1 :

date

2020-04-01

2020-04-02

2020-04-03

Table 2 :

name

AA

BB

Expected result:

table 3:

date name

2020-04-01 AA

2020-04-01 BB

2020-04-02 AA

2020-04-02 BB

2020-04-03 AA

2020-04-03 BB

I tried addcolumns, but it didn't work.

Any help would be great.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

Hi @Anonymous

Unless there is either a 1:N or N:N relationship between the tables, I doubt that it is possible in PowerApps to create a join.

Was this reply helpful? Yes No
Verified answer

PowerAddict 7,316 Most Valuable Professional on at

Like (7)

Report
I created 2 collections:

ClearCollect(C1, {date1: "2020-04-01"}, {date1: "2020-04-02"}, {date1: "2020-04-03"}); ClearCollect(C2, {name2: "AA"}, {name2: "BB"});

Then I created a collection C3 with the following expression:

ForAll(C1, ForAll(C2, Collect(C3, {date3: date1, name3:name2})))

This is how my collection looks like:

Let me know if this is what you were looking for.

---
If you like this reply, please give kudos (Thumbs Up). And if this solves your problem, please mark this reply as a solution by selecting Accept as Solution. This makes it easier for others to find answers to similar questions.

Thanks!

Hardit Bhatia

Blog | Twitter | LinkedIn | Facebook | YouTube | Email

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (2)

Report

Good Job @PowerAddict for thinking outside the box.

Was this reply helpful? Yes No
PowerAddict 7,316 Most Valuable Professional on at

Like (0)

Report

Thank you @Drrickryp! Means a lot coming from you!

Thanks,
Hardit Bhatia

Was this reply helpful? Yes No

Join the conversation