Patch Person or Group field no longer working in Sharepoint 2016 On-Premise (NOT online)

[JanLektonen]

In Sharepoint 2016 OnPremise - creating a new record via patch function no longer works.

I have testet the same code on Sharepoint ONLINE and here it works. But the code no longer works in Sharepoint OnPremise.

I have used this approuch:

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

I have used the above code to patch several Person or Group fields in many apps. And they all stopped working with errors in the Patch command.

See example online here:

Article: PowerApps Set SharePoint Person field to Current User

Can anyon else confirm that this is no longer working in Sharepoint 2016 On-Premise (NOT online) ?

[AllenKim]

Hi @JanLektonen, I just wanted to let you know that I am aware of this issue and have identified the root cause. I am currently looking for a solution.

[AllenKim]

Hi @JanLektonen,

I was able to get the patch working by adding the 'ODataType' property with a value of "Blank()". I have updated your rule value (below) to include the new property.

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

[stingray]

Did you ever get this working? I also have issue setting a person field SharePoint 2016 on premise using a data gateway.

The suggested answer doesnt work.

Thanks

[AllenKim]

Hi @stingray,

Are you seeing any error message come up in a red banner at the top of your app? Also, a session ID would help with the investigation. If you could reproduce the issue then grab the session ID, that would be great. Here is some documentation on finding the session ID: https://docs.microsoft.com/powerapps/maker/canvas-apps/get-sessionid

Thanks,

Allen

[SebastianB]

I have te same issue 

this is my call:

Patch(
'Approval Tasks',
SelectedInvoice,
{
To: {
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims: "i:0#.w|sgh\\xxxxx,
DisplayName: "xxxxx",
Email: "xxxx@xxxx.com",
Picture: "",
Department: "",
JobTitle: "",
ODataType:Blank()
}

[AllenKim]

Hi @SebastianB,

Can you provide a session ID of a session where the error occurs? You can find the session ID by using the following guide:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/get-sessionid

Thanks,

Allen

[Bogdan]

Hy,
I tried your  solution (OdataType: Blank()) a couple of times and it didn't work.
It seems that nobody here noticed the actual Problem. Or if so, then it didn't mention it.

The Problem here lies in the Authentication Claim that you try to use for patching an OnPremise Sharepoint 2016 Person field.

You try:

'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", Claims:"i:0#.f|membership|" & Lower(User().Email), 

When for SharePoint On Premise you have to use the Windows User Claim:

'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", 
Claims:"i:0#.w|"& Lower(User().Email), 

Notice the "i:0#.w|" .

I banged my head for a couple of days before I solved it. It worked before, indeed...
No info at all on this matter. ...
Although @SebastianB  had the "i:0#.w|" in his code block 😁. I should have copied all and use it


Hopefully this helps someone in the future.

[Zawic10]

Hello everyone,

i have a problem with the Patch function, it shows me no error but it sends nothing to the sharepoint list,

here are the columns I have: Country, Project_Customer, Project_Category, Project_Type, are comboboxes of choices, project_site is a search column, project manager is a person type column, project description and project name are text lines and project amount is a number (currency type) , and project_status is a dropdown. 

here is the patch function Patch :

('5-BDD_Project'; Defaults ('5-BDD_Project'); {Country: ComboBoxCOUNTRY.Selected; Project_Customer: ComboBoxCustomer.Selected; Project_site: ComboBoxSite.Selected; Project_Category: ComboBoxCATEGORY.Selected; Project_Type: ComboBoxPROJECTTYPE.Selected; Project_Name: Text (TextInputProjectName); Project_Amount: TextInputProjectAmount; Project_status: DropdownSTATUS; Project_manager: ComboBoxmanager; 'Project_Description': Text (TextInputDETAIL)})

Do you have any ideas please?