Patch multi people column in SharePoint

(0) Share

Report

Posted on by JimmyW

2,567

I have a combo box that has items from a collection created from a Office 365 group.

I then have the following set on my Patch button.

OnSelect:

Clear(colSelectedDelegates);
ForAll(
 Selected_Delegates.SelectedItems,
Collect(colSelectedDelegates,
 {
 '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
 Claims: "i:0#.|membership|" & Lower(ThisRecord.mail),
 Department: "",
 DisplayName: ThisRecord.displayName,
 Email: ThisRecord.mail,
 JobTitle: "",
 Picture: ""
 }
)
);
 Patch(
 MyDataSource,
 ThisItem,
 {
 DelegatesTest: colSelectedDelegates
 }
 )

This button is on each gallery Item so I refer to ThisItem.

I get an error saying: The request operation is invalid.

I Check my collection and it looks correct.

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

WarrenBelz 156,750 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @JimmyWork ,

I would be inclined to do it this way - note I cannot test this presently

Patch( MyDataSource, {ID: ThisItem.ID}, { DelegatesTest: ForAll( Selected_Delegates.SelectedItems As aPatch, { '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", Claims: "1:0#.|membership|" & Lower(aPatch.mail), Department: "", DisplayName: aPatch.displayName, Email: aPatch.mail, 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
JimmyW 2,567 on at

Like
a
(0)

Report
Copy link

Link copied!
Found a solution.

Patch( MyDataSource, varSelectedTicket, //This is a variable for ThisItem { MultiPersonColumn: ForAll( MyComboBox.SelectedItems , { Claims: Concatenate("i:0#.f|membership|" & mail), Department: "", DisplayName: displayName, Email: mail, JobTitle: "", Picture: "" } ) } )
JimmyW 2,567 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz Thank you Warren will test this tomorrow and update with your solution and accept it 🙂
WarrenBelz 156,750 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@JimmyWork ,

I just tend to be more specific with the record to be patched if the ID is available as the data source needs to simply identify the ID rather than having to find the record matching the Variable.
Verified answer

JimmyW 2,567 on at

Like
a
(0)

Report
Copy link

Link copied!
@WarrenBelz Tested your solution and it does not work, I get an error saying: An error occurred on the server.

But I did update my formula according to your recommendation on specifying ID.

Patch( MyDataSource, {ID: varSelectedTicket.ID}, { DelegatesTest: ForAll( SelectedDelegates.SelectedItems , { Claims: Concatenate("i:0#.f|membership|" & mail), Department: "", DisplayName: displayName, Email: mail, JobTitle: "", Picture: "" } ) } )
WarrenBelz 156,750 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

@JimmyWork ,

Same thing - you just need to refer to the ID of the record (I cannot see your data or app). The response was more about the other structure required (which achieved the purpose you required) and then refer to wherever you can get the ID.