Answered

Patching from Office 365 Group Connector to a person field in Sharepoint

(0) Share

Report

Posted on by TomCollins

Hi experts

There are countless posts on how to patch a person into a person field on a sharepoint list. In my app I want to patch users but also groups into a person field. With the users everything works as desired. But with groups I have problems. For this I also find practically no forum posts.

I create a collection of all selected items of a gallery and want to patch them to the sharepoint list.

The necessary attributes are available in the collection:

Here is my code:

ClearCollect(PatchGroups,GroupsAddedGallery1.AllItems);
Patch(PeoplePicker, {ID: Gallery2.Selected.ID}, {MyGroups: ForAll(PatchGroups As aGroup, {'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpanderUser",Claims: "c:0o.c|federateddirectoryclaimprovider|" & aGroup.id, Department: "", DisplayName: aGroup.displayName, Email: "", JobTitle: "", Picture: SampleImage } ) } )

But when patching I get a network error, which indicates that a necessary value is missing. I also don't know if I need the #Microsoft.Azure.Connectors.SharePoint.SPListExpanderUser for groups as well.

Does anyone have a tip for me on this ?

Best regards Tom

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @TomCollins ,

Is there a required field in the table you want to update? Maybe you can check what the missing necessary value is.

For your question, it is not necessary to use #Microsoft.Azure.Connectors.SharePoint.SPListExpanderUser in any case .

If you just want to update the existing values in the table, you can try the following code:
ClearCollect(PatchGroups, GroupsAddedGallery1.AllItems); Patch(PeoplePicker,Defaults(PeoplePicker), {ID: Gallery2.Selected.ID},{MyGroups:ForAll(PatchGroups As aGroup,{Claims: "c:0o.c|federateddirectoryclaimprovider|" & aGroup.Id, DisplayName: aGroup.diaplayname, Email:"", JobTitle: "", Picture: "", Department:""} )})

Best regards,
Rimmon Li
Verified answer

TomCollins 75 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Rimmon
Thanks for your answer. Just now I found the solution.
For Claims is just have to use the displayname:

Patch(PeoplePicker;
{ID: Gallery2.Selected.ID};{MyGroups:ForAll(PatchGroups As aGroup;{Claims: aGroup.displayName; DisplayName: aGroup.displayName; Email:""; JobTitle: ""; Picture: ""; Department:""}
)})