How do I patch to a people column in SharePoint list

Like (0) Share

Report

Posted on 1 Dec 2023 09:29:08 by Spawn10

279

I have a gallery that is displaying some data that I want to patch to another SharePoint list. Currently I am trying to do this, but I can't get the people column data part to work. It is a single people column.

Patch('my list',LookUp('my list',ID=xxx),{txtcol: ThisItem.txtColName, myPeopleCol: ThisItem.galPeopleCol})

How do I grab the people column value that is displayed in the gallery, and patch that to a people column in a SharePoint list?

All responses (3)

Answers (2)

mmbr1606 13,290 Super User 2025 Season 2 on 01 Dec 2023 at 09:56:48

Like (0)

Report

Re: How do I patch to a people column in SharePoint list

this is how i patch into People Picker without network issue
Verified answer

cdwhite 1,067 Most Valuable Professional on 01 Dec 2023 at 09:35:08

Like (0)

Report
Re: How do I patch to a people column in SharePoint list

Hi @Spawn10 ,

You'll likely need something like this:

Patch( 'my list', LookUp('my list',ID=xxx), { txtcol: ThisItem.txtColName, myPeopleCol: { DisplayName: "", Claims: "user@emailaddress.com", Department: "", Email: "", JobTitle: "", Picture: "" } })

You can hardcode the email address in the Claims part, like above, or reference a relevant gallery field. For example, ThisItem.galPeopleCol.Email, or ThisItem.Email etc.

The method above is the least bloated in terms of code, you don't need any other properties populated in the object. I've tested the above code on my end and works perfectly, and is going to be included in a blog post on the topic that I'm releasing soon 😀
------------------------------------------------------------------------------------------------------------------------------
If I've answered your question, please mark your post as Solved. You can accept more than one post as a solution.

If my response was a good one, please give it a Thumbs Up!

Visit my blog: https://platformsofpower.net
Verified answer

Rajkumar_M 3,716 Super User 2025 Season 2 on 01 Dec 2023 at 09:34:18

Like (0)

Report
Re: How do I patch to a people column in SharePoint list

Hi @Spawn10

Patch(
'my list',
LookUp('my list', ID=xxx),
{
txtcol: ThisItem.txtColName,
myPeopleCol: {
'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims: "i:0#.f|membership|xxx.yyy@companyname.com",
Department: " ",
DisplayName: " ",
Email: " ",
JobTitle: " ",
Picture: ""
}
}
)

Refer this link : How To Patch A SharePoint Person Column In Power Apps (c-sharpcorner.com)

PATCH A SharePoint Person Column In Power Apps - Matthew Devaney

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.