Form to Submit Multiple Users in a Person Field in SharePoint

(0) Share

Report

Posted on by Paramesh Ulthi

I am currently using a PowerApp newform connected to a SharePoint list. I have a Person Field "Addl_Team" on SP that allows multiple entries.

I can get my multiselect-enabled combobox in my form to create an entry with multiple people, but if I go back into the app and I decide that I need to add another person to these selections, it overwrites my existing multi-selections with just that one new person I picked.

This is the code I have attached to my Update function of my DataCard:

ForAll(DataCardValue15.SelectedItems,
{
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
            Claims: "i:0#.f|membership|" & DataCardValue15.Selected.Mail,
            Department: "",
            DisplayName: DataCardValue15.Selected.DisplayName,
            Email: DataCardValue15.Selected.Mail,
            JobTitle: "",
            Picture: ""
})

Categories:

Power Apps Pro Dev & ISV

I have the same question (3)

All responses (1)

Answers (1)

Verified answer

Paramesh Ulthi 17 on at

Like (2)

Report
Copy link

Link copied!
Using a Form to Update Multiple Users in a Person Field in SharePoint

When patching to a Person field, you need to send the whole schema. As you seem to be using the Office365Users.SearchUser function in the Items, this schema is different from that of the person field you are reading from / writing to, so the Update would be
ForAll( DataCardValue15.SelectedItems As _Items, { Claims: "i:0#.f|membership|" & Lower(_Items.Mail), Department: "", DisplayName: _Items.DisplayName, Email: _Items.Mail, JobTitle: "", Picture: "" } )

and the DefaultSelectedItems
ForAll( ThisItem.Addl_Team As _Items, { Mail: _Items.Email, DisplayName: _Items.DisplayName } )

Was this reply helpful? Yes No