HTTP Request to SharePoint - how to post to people picker field

(0) Share

Report

Posted on by LO-18122224-0

Hi guys,

I've created a flow to batch create SharePoint list items as per this guide.

For the HTTP request body, I'm having issues setting a people picker field using an email address. I don't have access to the person's site ID, only name or email. Is this even possible as I've tried so many permutations.

The field is called Approver. I've set it to null for now so the rest works but some of the things I've tried:

- "Approver":"[{"Claims":"i:0#.f|membership|leonie.oconnor@cairnsairport.com.au"}]"

- "formValues":[
{
"FieldName": "Approver",
"FieldValue":"<email>"
}
]

- "Approver":"<email>"

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

e.evseychik 42 on at

Like (0)

Report

HTTP Request to SharePoint - how to post to people picker field

@janeway5

Hello! I could not open the link to the guide you referred to but would suggest the following. If you have person's name or e-mail, you can use a 'Resolve person' action from the SharePoint connector and pass a 'Claims' property to fill the required column in the list.

Was this reply helpful? Yes No
LO-18122224-0 29 on at

Like (0)

Report

HTTP Request to SharePoint - how to post to people picker field

Cheers @e.evseychik,

I didn't know there was a 'resolve person' action, pretty cool. I was hoping to avoid apply to each loops however, hence why I'm using the batch method in the link I fixed above (Power Automate Flow to batch create SharePoint List Items).

I've hunted online but can't find much at all on how to set the people field using email. Odd. Perhaps it's not possible.

Was this reply helpful? Yes No
Verified answer

e.evseychik 42 on at

Like (0)

Report
HTTP Request to SharePoint - how to post to people picker field

@janeway5

Please check topics by the links below:

https://learn.microsoft.com/en-us/answers/questions/522361/update-people-picker-values-in-sharepoint-on-premi

https://sharepoint.sureshc.com/2016/05/how-to-update-person-field-with-multiple-values-using-rest-api.html

The main thing is that you need to append 'Id' to the column name, that is use an 'ApproverId' property, and pass it either user ID or an object with user IDs if it is a multi-value column. If you have only user name and e-mail, you will need to retrieve those IDs first and embed the values in the input of the 'GenerateSPData' step. Then you can use it as any other property you listed in the 'Map' field.

To retrieve the user IDs, I would look at this endpoint though you can search for more concrete how-to articles. Unfortunately, I do not understand much to suggest you a ready solution right away but I hope that I helped at least with the direction of further steps.

https://learn.microsoft.com/en-us/previous-versions/office/developer/sharepoint-rest-reference/dn531432(v=office.15)?redirectedfrom=MSDN#user-resource

Was this reply helpful? Yes No