Patch to Multi Person SP Column

Hi all,

I am building an issue tracker where the issue can be assigned to multiple persons and seem to be going around in circles a bit with this one. I've tried multiple things from forums/YT videos but nothing seems to be working for me.

The assigned people are added to a collection, I am then trying to patch the collection back to the relevant SP field. The SP column is set up as a multi person column. How do I change the below to patch all the people in the collection instead of just a single selected person?

What I have so far:

Patch(

TrackerSPList,

LookUp(TrackerSPList, SerialNo = varRecordTriage.SerialNo),

{

AssignedToPerson: Table(

{

'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",

Department: varSelectedPerson.Department,

Claims: "i:0#.f|membership|" & varSelectedPerson.Mail,

DisplayName: varSelectedPerson.DisplayName,

Email: varSelectedPerson.Mail,

JobTitle: varSelectedPerson.JobTitle,

Picture: varSelectedPerson.Mail

})

}

)

Hi @nemo1 ,

I assume varSelectedPerson is your Collection ??

Patch(
 TrackerSPList,
 LookUp(
 TrackerSPList, 
 SerialNo = varRecordTriage.SerialNo
 ),
 { 
 AssignedToPerson: 
 ForAll(
 varSelectedPerson As aPerson,
 {
 '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
 Department: aPerson.Department,
 Claims: "i:0#.f|membership|" & Lower(aPerson.Mail),
 DisplayName: aPerson.DisplayName,
 Email: aPerson.Mail,
 JobTitle: aPerson.JobTitle,
 Picture: ""
 }
 )
 }
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps