web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Combining One-to-Many ...

Power Apps

Unanswered

Combining One-to-Many SharePoint Lists into a Collection for Excel Export

(0) Share

Report

Report

Posted on by nrd10

132

Hi,

I'm trying to join two SharePoint lists (one-to-many relationship) into a collection for export to Excel.

From Table "Opportunity"			From Table "Log_Interaction"
ID	Opportunity	Partner	Date Interaction	Interaction
1	x1	yy1	24-May	abab
			23-May	aaa
2	x2	yy2	10-Apr	cc
			09-Apr	bb
			08-Apr	aa
3	x3	yy3	-	-

I can achieve the desired view using nested galleries within Power Apps. However, for exporting, I need to create a collection first.

Has anyone encountered this scenario? Any advice on building a collection to combine these lists for Excel export would be greatly appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

mmbr1606 14,629 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
hey @nrd10

this is just a high level approach:

ClearCollect( CombinedList, AddColumns( 'Opportunity', "Interactions", Filter( 'Log_Interaction', ID_Opportunity = Opportunity.ID ) ) )

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No

Join the conversation