Unanswered

How to Patch and use Update IF functions for people picker columns

(0) Share

Report

Posted on by Rebeccak

113

I have a parent gallery and child form. Connections are made in sharepoint using a ProjectID lookup from child to parent. To add a new child item I have a child form with 3 fields Title, Assigned To, and Project ID. The item will save properly associating the new child item with its parent, only if i remove the Assigned To code. But if I leave the assigned to code it will not save at all. The assigned to field is a people picker column.

Patch(
 'Project Action Items',
 Defaults('Project Action Items'),
 {
 Title: DataCardValue23.Text, 
 ProjectID: {
 '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
 Id: 'Project Gallery'.Selected.ID,
 Value: 'Project Gallery'.Selected.Title
 },
 Assigned_x0020_To:{
 '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
 Claims:Concatenate("i:0#.f|membership|",DataCardValue36.Selected.Email),
 Department:"",
 DisplayName:DataCardValue36.Selected.DisplayName,
 Email:DataCardValue36.Selected.Email,
 JobTitle:"",
 Picture:""
 },
 }
)

There are no errors being shown, it just doesnt work.

I am also having issues saving people picker column and attachments columns using the updateif function of the parent edit form. Any suggestions?

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

v-micsh-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Rebeccak,

I just tested with the Person or group field (Single Value field) update with patch, it works at my side:

Patch(Patchtesting,First(Patchtesting),{Person:{'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", Claims:"i:0#.f|membership|" & Lower(User().Email), Department:"", DisplayName:User().FullName, Email:User().Email, JobTitle:".", Picture:"."}})

For Multiple value enabled field, the schema should be changed as below:

Patch(Patchtesting,F
irst(Patchtesting),
{Person:
Table(
{'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", Claims:"i:0#.f|membership|" & Lower(User().Email), Department:"", DisplayName:User().FullName, Email:User().Email, JobTitle:".", Picture:"."})
}
)

Regards,

Michael
Rebeccak 113 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for your response. Where do i put the datacard value, so it knows which datacard to use for the selection?
Vaishali16 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Any inputs on how to populate multiple people picker values?