Updating SharePoint Column without Overwriting

Question

Hello,&nbsp;I have a Sharepoint List that contains two columns, column A and column B which can contain multiple person or group (so no string value, more like Teams functionnality) When column B is not empty, I would like to update column A with the value of column B without overwriting what it contains, so only append the value of B in A.Does somebody know how to achieve that ?&nbsp;Thanks in advance

jon_lake · Answer

Hi&nbsp;xabouba&nbsp;, you can concatenate the values in field A, then use a contains expression to evaluate whether the presence of the name, e.g. contains('name in A','name in B'). You can then use an update item action to append any missing names.

Forum Discussion

Updating SharePoint Column without Overwriting

1 Reply

Resources