Patch People or Group column, weird errors

(0) Share

Report

Posted on by Matt07

Hi Everyone,

This question has been asked numerous times, but I get a weird error and none of what I'm trying works.

First, this simple Patch function works great:

Patch(Requests, Defaults(Requests),
 {
 Title: "Increment (TBD)",
 Comments: "A",
 Updates: "B",
 Barcode: "",
 'Manufacturer Name': ""
 }
)

You can see there is no errors:

2023-01-26 11_27_33-Power Apps and 25 more pages - [InPrivate] - Microsoft Edge.png

When I click on my Submit button, it sends the requests to SharePoint (SP) and I can see the new record created.

In my SP List, I have another column called "Requestor" of type "Person or Group", and it only allows the selection of a single user, and only people (no group).

Issues come when I add that column in the Patch function:

Patch(Requests, Defaults(Requests),
 {
 Title: "Increment (TBD)",
 Comments: "A",
 Updates: "B",
 Barcode: "",
 'Manufacturer Name': "",
 Requestor: 
 {
 '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
 Claims: "i:0#.f|membership|test@test.com",
 Department: "",
 DisplayName: "",
 Email: "",
 JobTitle: "",
 Picture: ""
 }
 }
)

I copy/pasted the syntax from other posts or blogs such as PATCH A SharePoint Person Column In Power Apps - Matthew Devaney.

Now I get errors:

2023-01-26 11_22_00-Power Apps and 25 more pages - [InPrivate] - Microsoft Edge.png

I tried to only keep the @OData and the claims properties, I tried reordering the properties... Still getting the same errors.

I also tried another syntax using the Office 365 User connector:

Requestor: First(Office365Users.SearchUser({searchTerm: "test@test.com"}))

but when I do that, I get other errors:

2023-01-26 11_25_29-Power Apps and 25 more pages - [InPrivate] - Microsoft Edge.png

Power Apps authoring version: 3.23012.17

I am not sure what's wrong with this but I can't find a solution. Does anyone know how to solve this?

Thanks,

Matt

Categories:

Building Power Apps

All responses (2)

Answers (0)

Sort by

Anonymous_Hippo 1,247 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hello @Matt07 ,

I have received similar error in the past and it turns out it is becuase my "claims" was a bit different. To expand futher , the formula below has the following

Claims: "i:0#.f|membership|test@test.com"

but when i checked my profile's "claims" i noticed the following

Claims: "i:0#.f|membership|test@test.net"

I recommend checking this first on a text box and seeing what value is returned

Office365Users.MyProfileV2().userPrincipalName

If you are seeing .net then make the change and that should also help

Additionally i use the following as my formula, perhpas this might work for you as well (Please note that i am using a value from a combobox to update a people picker field)

{ Claims: "i:0#.f|membership|" &Lower(EnterYourComboboxName.Selected.UserPrincipalName), DisplayName: EnterYourComboboxName.Selected.DisplayName, Email: Lower(EnterYourComboboxName.Selected.Mail), Department: "", JobTitle: "", Picture: "" }

Hopefully this helps

Cheers !
Matt07 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @Anonymous_Hippo, unfortunately the error still persists. I read a lot of posts using this syntax but for some reason it is still not working for me.