PATCH A SharePoint Person Column In Power Apps



Goal

Change the EmployeePerson column (Person Type) from blank to “Matthew Devaney” in a SharePoint list.


Input

Project Tasks (SharePoint List)

IDTaskNameDueDateEmployeePeople
1Write project plan11/7/2020


Patch Function Code
Patch(
    'Project Tasks',
    LookUp('Project Tasks', ID=1),
    {
        EmployeePerson: {
           '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
           Claims: "i:0#.f|membership|mdevaney@companyname.com",
           Department: "",
           DisplayName: "Matthew Devaney",
           Email: "mdevaney@companyname.com",
           JobTitle: "",
           Picture: ""
        }
    }
)


Output

Project Tasks (SharePoint List)

IDTaskNameDueDateEmployeePeople
1Write project plan11/7/2020Matthew Devaney




Scenario #1: ComboBox

Patch a value found in a combo box to a People field.



ComboBox Properties Code
Items:  Choices('PATCH Function Examples'.EmployeePerson)
DisplayFields: ["DisplayName"]
SearchFields: ["DisplayName"]


Patch Function Code
Patch(
    'Project Tasks',
    LookUp('Project Tasks', ID=1),
    {
        EmployeePerson: ComboBox_Person.Selected
    }
)