Microsoft Graph - Sharepoint: Update List Item Properties - JSON Payload

Alexander.Duff — Mon, 12 Jul 2021 14:21:40 GMT

Afternoon,

After a week or so of setting up permissions within Azure - We've finally managed to grant access to BP to Sharepoint. We're now able to view all data within a sharepoint list.

We've come to the point of wishing to set "Posting" or "Updating" a list item with the commentary "Done" or "Manual Intervention Required".

However, as this is our first steps into this sort of process, we're at a loss as to how we present the Value for the Request Payload - other than knowing it's expecting a JSON content.

Any support on how we pass this would be appreciated.

Re: Microsoft Graph - Sharepoint: Update List Item Properties - JSON Payload

ewilson — Tue, 13 Jul 2021 00:52:07 GMT

Hi @Alex Duff,

The Microsoft Graph API Reference pages are a great place to look for details of what the JSON payloads should look like. As an example, the Update ListItem page states that the body of the request should contain a FieldValueSet definition. The FieldValueSet is based on the column definitions of the List/ListItem in question. In their example, they show the following JSON payload:

{
    "Author": "Brad Cleaver",
    "AuthorLookupId": "13",
    "Name": "Kangaroos and Wallabies: A Deep Dive",
    "Color": "Red",
    "Quantity": 350,
}

This would be tied to a List/ListItem with columns Author, AuthorLookupId, Name, Color, and Quantity.

So, in your environment, what's the name of the column that will contain the commentary?

Cheers,
Eric

topic Re: Microsoft Graph - Sharepoint: Update List Item Properties - JSON Payload in Product Forum

Microsoft Graph - Sharepoint: Update List Item Properties - JSON Payload

Re: Microsoft Graph - Sharepoint: Update List Item Properties - JSON Payload