Multi Collections patch in SharePoint list

[Prakash1415]

Hi everyone,

How to patch multiple collection items to SharePoint list

I have 7 collection list

Goal list

Benefit list 

Feature list 

Deliverable list etc.....

This all collection will store, one SharePoint list 

That one is 'Goal activity lists'

I tried lot add column but did not get

Anyone can help me....

How can I do that....

[turnerj3]

Does each collection have information for different columns in the Goal Activity lists? Are you trying to update one row in the Goal Activity list with data from each collection based on the project name that is stored in the Goal Activity list or are you trying to add a row for the data from each collection?

[Prakash1415]

Yes add to columns in single SharePoint list 

That above 7 collection list items

[turnerj3]

Is there always going to be only 1 row in each collection?

Try this example for one of your collections. You will need one for each collection.

ForAll(goallist,Patch(GoalActivity,LookUp(GoalActivity,ProjectName=ProjectNameTextInput.Text),{GoalActivityColumn1:ThisRecord.goallistColumn1,GoalActivityColumn2:ThisRecord.goallistColumn2}))

[Prakash1415]

Thank you I tried but 

It's only showing blank in SharePoint list

Not in patch

You can see my syntax is there anything wrong

I send attachment 

[turnerj3]

@Prakash1415 ,

  I see the problem. For the patch to work with a Lookup there has to already be a record in the list with the project name. It is not currently finding anything when doing the lookup. In your first patch, use Defaults(‘Goal Activity’) instead of the lookup and add the {Project Name:Textbox.text} to the fields inside curly brackets. Using defaults will create the record. The subsequent patches will then add to it.