SharePoint Person Column with Form Edit and Search365

[kp77777]

Hi All,

I've been trying to implement the person column for a while now with SharePoint but have not successfully had this work with forms. I would really like to have a drop down or combo box that would search for the user through the search365 capability and then update in the backend. If anyone has any suggestions or videos as to how to get this to work I would really appreciate it.

[NandiniBhagya20]

Hi @kp77777 ,
You can add a combobox (named "ComboBox4") and set items property of it to - 

Office365Users.SearchUserV2({searchTerm:ComboBox4.SearchText,top:1}).value

Before this add Office365Users connector

Then you can go to fields option on Porperties tab on Right side panel. There you can select "Person" layout:

[kp77777]

So, this solution works great for choosing one person, but what if you want to choose multiple people?

[NandiniBhagya20]

Turn on "Allow multiple selection" option in property pane.

[kp77777]

 Sorry, that's still not working and has always been on. When I re-tried your original solution again it stopped working as well. I did create this work around though..

Items of combobox= Office365Users.SearchUser({searchTerm:workstreamlead_2.SearchText})

Update of Card = ForAll(workstreamleads.SelectedItems,
{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims: Mail,
DisplayName: DisplayName,
Email: Mail})

Although, it can be a bit finnicky at times but your solution sadly isn't working, would be open to a better solution if anyone has one as I occasionally get some sort of server error.

Thank you for your attempt though 🙂

[NandiniBhagya20]

HI @kp77777 ,

Try using below formula in Update property of datacard - 

 ForAll(workstreamleads.SelectedItems, {
Claims: "i:0#.f|membership|" & Lower(ThisRecord.Mail),
Email: ThisRecord.Mail,
DisplayName: ThisRecord.DisplayName,
Picture: "",
Department: "",
JobTitle: ""
})

[kp77777]

Hello,

 I have already tried this method as well and it spit out quite a few more errors than the other method. Thank you though.