Concat from one SP list to another

[kingy61422]

I'm trying to concat specific inputs to a SharePoint list.

This is what I have now:

Patch( ExpenseMaster, LookUp (ExpenseMaster, ID=Form1.LastSubmit.ID), { 'Air Wing': Concat( ExpenseDetails ,FlyUnit, "," ) } ) 

This is to get the desired record to patch to the master and be associated with the same ID 

When I do this I get the whole record in my SP list. Is there a way to have specific parts of the record concat?

[v-jefferni · Accepted solution]

Hi @kingy61422 ,

Could you please share more details about your scenario? Could you share the data structures of the two lists, as well as some sample data to help us understand the scenario? What do you mean by get the whole record? Concat function will concatenate all the column values with the separator. So what specific purpose would you like to achieve?

Based on your formula, I think there is a FlyUnit column in the ExpenseDetails list, what you want is to get corresponding FlyUnit value and populate it in the 'Air Wing' column of ExpenseMaster list. But what is the relationship between ExpenseMaster and ExpenseDetails lists? 

Maybe you can try below formula first, if there is a MasterID LookUp column (look up the ID column of the Master list) in the ExpenseDetails list:

Patch(
    ExpenseMaster, 
    LookUp(
        ExpenseMaster, 
        ID=Form1.LastSubmit.ID
    ), 
     //MasterID column is a LookUp column
    {'Air Wing': Concat(Filter(ExpenseDetails, MasterID.Value = Form1.LastSubmit.ID),FlyUnit, "," )}
     //MasterID column is a Text column
    {'Air Wing': Concat(Filter(ExpenseDetails, MasterID = Form1.LastSubmit.ID),FlyUnit, "," )}
) 

Best regards,