web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Join Table

Power Apps

Answered

Join Table

(0) Share

Report

Report

Posted on by HM-18111627-0

18

Hi all,

I have 2 sharepoint list as shown in below table1 and table2.

Is it possible to do a join that result in table3?

Thanks for the help in advance.

Regards

Hidayat

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Yatz ,

I assume there are two tables:

ClearCollect( Table1, {ID:1,Resource:"Driver 1",Remarks:"John"}, {ID:2,Resource:"Driver 2",Remarks:"John1"}, {ID:3,Resource:"Driver 3",Remarks:"John2"}, {ID:4,Resource:"Driver 4",Remarks:"John3"}, {ID:5,Resource:"Driver 5",Remarks:"John4"} ); ClearCollect( Table2, {Resource:"Driver 1",'Booking Date':"1"}, {Resource:"Driver 1",'Booking Date':"2"}, {Resource:"Driver 5",'Booking Date':"3"} );

Please try:

ShowColumns(With( {TableA:ForAll( Table2, Patch(ThisRecord,LookUp(Table1,Resource=Table2[@Resource])) )},Ungroup(Table({Value:TableA},{Value:Filter(Table1,!(Resource in TableA.Resource))}),"Value")),"Resource","Booking Date")

Best Regards,

Bof
HM-18111627-0 18 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so much @BOF !!

Join the conversation