Power Platform Community Forum Thread Details

I need syntax help for merging 2 Collections.

I have 2 Collections (shown below) - CollectNewProjectAcct and CollectNewProjectSources. Both collections are created when a new Account is Submitted / OnSuccess. I want to merge the CollectNewProjectSource collection into CollectNewProjectAcct collection that will then be used to Patch into a SharePoint list named ProjectSourceMatch (shown below). I have included how I would like the merged CollectNewProjectAcct collection to look.

CollectNewProjectAcct collection

CollectNewProjectSources collection

I need help on the syntax to merge the above two collections to create the Collection below, if possible. (The Collection below was fabricated from various coding attempts)

Merged CollectNewProjectAcct collection

The merged CollectionNewProjectAcct collection will be used to Patch a SharePoint List named ProjectSourceMatch (shown below). The end-in-mind is to create a record in the ProjectSourceMatch list for every combination of ProjectID&SourceID. The ProjectSourceMatch list will have a ProjectSourceMatchID that comes from combining the ProjectID&SourceID.

(Ex: Project ID = 24, Source IDs = 5,10,20,22 -- new record IDs 245,2410,2420,2422)

ProjectSourceMatch - SharePoint List to Patch to.