Answered

How do I patch to a people column in SharePoint list

(0) Share

Report

Posted on by Spawn10

330

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?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (2)

Sort by

Verified answer

Rajkumar_M 3,747 Moderator on at

Like (0)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
Verified answer

cdwhite 1,069 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
mmbr1606 14,629 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

this is how i patch into People Picker without network issue

Was this reply helpful? Yes No