web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Join two lists in a co...

Power Apps

Answered

Join two lists in a collection

(0) Share

Report

Report

Posted on by Sam70

271

Hi,

Below are two SharePoint list structures.

ID	Name
A1	ABC
A2	ABCD

and

Name	Account	Amount

I need a query to join these two lists in a collection so that the output is like

Name	Account	Amount	ID
ABC			A1
ABCD			A2

Regards

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

jpespena 335 on at

Like (1)

Report
Copy link

Link copied!
Hi,

Use this code:

ForAll( SharepointList1 As List1, Collect( colCombinedList, { Name: List1.Name, Account: LookUp(SharepointList2, Name = List1.Name).Account, Amount: LookUp(SharepointList2, Name = List1.Name).Amount, ID: List1.ID } ) )

Was this reply helpful? Yes No

Join the conversation