Upload Multiple Choice Fields item in SharePoint with Microsoft Graph

Question

Upload Multiple Choice Fields item in SharePoint with Microsoft Graph

Tourmente T 40

Hi, Trying to add a new entry to a SharePoint list through a Python script using Microsoft Graph returns an error in the case of Multiple Choice Fields : "General exception while processing". The correct formulation of the post request for this type of item is not specified on this documentation : https://learn.microsoft.com/en-us/graph/api/listitem-create?view=graph-rest-1.0&tabs=python. Thank you for your help.

Accepted answer

1 additional answer

Your answer

Answer 1

Sourabh Gupta 800 Microsoft External Staff

Hi Tourmente T, Thanks for reaching out.

I guess you can do this with beta version (Give it a try with V1.0). Your fields should look like this.

{
  "fields": {
    "******@odata.type": "Collection(Edm.String)",
    "choice_checkboxes":["cb1","cb2"]
  }
}

or another example like this

"******@odata.type": "Collection(Edm.Int32)",
"ProductsLookupId":[6,7,8]

or

{
  "fields": {
    "******@odata.type": "Collection(Edm.Int32)",
    "Weight": 32,
  }
}

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

TourmenteT 30 Reputation points

2024-02-06T15:10:30.41+00:00

I answered outside of the Comment section
Tourmente T 40 Reputation points

2024-02-27T07:33:20.7+00:00

I must add that this only works if the "Show choices using:" parameter of the column is set to : "Checkboxes (allow multiple selections)". Otherwise the error will persist.

Answer 2

TourmenteT 30

Hi, Thanks for your answer. I tried the following formulation which have returned the same error.

request_body = ListItem(
	        fields = FieldValueSet(
		        additional_data = {
                    "Field1": {
                        "Field1@Odatatype": "Collection(Edm.Int32)",
                        "Field1":["test","test","test"]
					}
				}

request_body = ListItem(
	        fields = FieldValueSet(
		        additional_data = {
                    "Field1": ["test", "test", "test"]
				}

As well as these value formulation : ["test, test, test"] "test, test, test" This is the error:

msgraph.generated.models.o_data_errors.o_data_error.ODataError:
        APIError
        Code: 400
        message: None
        error: MainError(additional_data={}, code='invalidRequest', details=None, inner_error=InnerError(additional_data={'date': DateTime(2024, 2, 6, 13, 56, 43, tzinfo=Timezone('UTC'))}, client_request_id='0af25118-2d29-4072-933c-bb1c125acd1b', date=None, odata_type=None, request_id='0cb2c84e-9ab4-4037-8bd0-8e2b41109450'), message='Invalid request', target=None)

Sourabh Gupta 800 Reputation points Microsoft External Staff

2024-02-06T15:10:33.7+00:00

Can you change Edm.Int32 To Edm.String , because in your case you are passing string values ["test", "test", "test"]

TourmenteT 30

It works, thank you !

request_body = ListItem(
            fields = FieldValueSet(
                additional_data = {
                    "******@odata.type": "Collection(Edm.String)",
                    "Field1": ["test", "test", "test"]
					}

Sourabh Gupta 800 Reputation points Microsoft External Staff

2024-02-06T15:56:52.3566667+00:00

Hi @TourmenteT Could you please accept my answer, so that It can help other people facing the same issue in first place. You action in this regard will be highly appreciated.
TourmenteT 30 Reputation points

2024-02-07T12:34:20.6166667+00:00

I'm sorry I don't have a "Accept This Answer" button, I can only like it
Sourabh Gupta 800 Reputation points Microsoft External Staff

2024-02-10T09:06:35.9233333+00:00

You will get the option to mark this answer as helpful in my very first answer on this question
Tourmente T 40 Reputation points

2024-02-26T12:56:18.9+00:00

Thank you. I do have another question related to this issue. Do know the formulation for other type of content fields ? E.g : Location, Date, Images or Hypertext links ? Thanks
Sourabh Gupta 800 Reputation points Microsoft External Staff

2024-02-26T16:06:24.4733333+00:00

Hi Tourmente T, Could you please post a new question for this one and post the link of the question here. Thanks
Tourmente T 40 Reputation points

2024-02-27T07:43:19.8033333+00:00

https://learn.microsoft.com/en-us/answers/questions/1599677/upload-special-fields-item-in-sharepoint-with-micr Thank you

Share via

Upload Multiple Choice Fields item in SharePoint with Microsoft Graph

1 additional answer

Your answer