Unable to insert data into Sharepoint list that is a People/group type column using graph explorer API

Question

I am using SharePoint list to store few data records and one of the column type is People/Group , usually when we type a value it searches for the value in AD and once selected it sets that value to that column.

But if i want to achieve the same thing using Graph explorer API and try to insert the same data example a user's full name or employee short id or so and send the values , the API calls shows as successful and when i check the response or the list in SharePoint there is no entry for it and it just shows as blank value.

I have tried looking up the user id value and even used it to send in the API but still the same, so i am looking for any guidance / help on how i can achieve it using the API call without using any language SDK's.

Answer 1

Hi @Sumanth Krishna, Kondapalli

You can update single value 'personOrGroup' fields, by combining the field name with Lookup-Id and passing the Lookup-Id as the value.

• Execute the below request. It will give you some SharePoint lists. Find the list with name “Users”
  GET https://graph.microsoft.com/v1.0/sites/{site-id}/lists
• Query the list items of that list. The request will look like
  GET https://graph.microsoft.com/v1.0/sites/<siteid>/lists/<listid>/items?$expand=fields

This will give you the lookup id. Now you can use this Lookup-Id to set the value. Please refer to the below sample screenshot.

Note:

• Field name is provided in the following format: {field-name}LookupId
• Field value corresponds to lookup id and provided as a string

Hope this helps.

If the answer is helpful, please click "Accept Answer" and kindly upvote. If you have further questions about this answer, please click "Comment".