Need help on syntax...
I have 2 Collections - CollectNewProjectAcct and CollectNewProjectSources as shown below. I would like to merge CollectNewProjectSources into CollectNewProjectAcct so that I can then Patch the Collection (CollectNewProjectAcct) into a SharePoint list named ProjectSourceMatch shown below, as well. I have included an image of what I would like for the merged CollectNewProjectAcct to display. The collections are updated by ClearCollect each time a new account is Submitted / OnSuccess.
CollectNewProjectAcct
CollectNewProjectSources
Above are the 2 collections being merged.
Below is how I would like for the merged collection, CollectNewProjectAcct to be, if possible.
Merged CollectNewProjectAcct (desired)
The merged CollectNewProjectAcct will be used to Patch into the Sharepoint list named ProjectSourceMatch - shown below (was fabricated from attempts to create it):
The end-in-mind is to create in the SharePoint list a record for every Project and Source combination. That will have a ProjectSourceMatchID that combines the ProjectMatchID&SourceMatchID.
Any help will be much appreciated.
Thanks, Marc...