Patch 365 user name to sharepoint list

[Anonymous]

Hello, What I am trying to do is send over patch an office 365 user to a sharepoint list.

I have a searchbox, then a gallery in wich the user is displayed. How can I acomplished into sending just the one that I need and not other user with similar names? 

If I type the full name, it only displays one item. So How can I send that "Name". The column in the sharepoint list is a Person column.

Any help or suggestion would be great, thanks

[RezaDorrani]

@Anonymous 

PERSON typoe column needs to be patched as a record in following format

{
        DisplayName: user().FullName,
        Claims: "i:0#.f|membership|" & user().Email
    }

so all you need to do above is get the display name and the email from the control where your user is being selected

Regards,

Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Pstork1 · Accepted solution]

When patching a Person column in SharePoint I've always gotten a schema error if I don't include all the fields, even if they are blank.  Here's what works for me on a person column called Employee

           Employee: {
                  Claims: Concatenate(
                    "i:0#.f|membership|",
                    User().Email
                ),
                Department: "",
                DisplayName: User().FullName,
                Email: User().Email,
                JobTitle: "",
                Picture: ""
            }

If you cut out any of the blank values you get a schema mismatch error.

[v-siky-msft]

Hi @Anonymous ,

Do you want to patch a office365 user selected from combo box to Person column of SP list?

In order to get that, you have to patch a record which contains "Claims","Department","DisplayName","Email","JobTitle","Picture" columns. Although not all values are required, you need to list them all.

you can refer to the following formuals:

Patch(SPlist, BaseRecord, {Claims:"i:0#.f|membership|" & ComboBox1.Selected.UserPrincipalName,Department:"",DisplayName:ComboBox1.Selected.DisplayName,Email:ComboBox1.Selected.UserPrincipalName,JobTitle:"",Picture:""})

Best regards,

Sik

[Anonymous]

This one works very well, Thank you so much

[Laura3]

Thanks for this. This will patch the current user, but what about patching someone else, either from a combobox or a variable? Any suggestions on how to do that? 

Many thanks

[Pstork1]

To patch a different user just replace the user().Email in the code with a string value that is the user's email that you want to patch.

[JBennett12]

This is over three years later but you helped me a ton. I've been stuck trying to figure this out for over a week! Thank you!!!

[blee777]

I currently am using a text label box to display the users name and email using Office365Users.MyProfileV2({$select""}).mail   Can I patch that information back to a Person column in SP list?  I am having a hard time figuring out the syntax.  I tried the above code 

Patch(SPlist, BaseRecord, {Claims:"i:0#.f|membership|" & ComboBox1.Selected.UserPrincipalName,Department:"",DisplayName:ComboBox1.Selected.DisplayName,Email:ComboBox1.Selected.UserPrincipalName,JobTitle:"",Picture:""})

and using the  Office365Users.MyProfileV2({$select""}).mail in place of the combobox1.selected.user but that patch will not work.  Can you please recommend correct syntax or if I need to use a combo box?

[Rizvan]

Huge Thanks, Reza! 
I couldn't get my form patch current user into the person column and I put your script above into the Update Card which worked well.