Create ListItem with Choice Column

Question

Create ListItem with Choice Column

Shadi Rashed 71

Hello,
I am trying to create a new ListItem. The list has only two columns (Title and ProductCategory1). The column is a choice column that allows multiple selection. The possible values are "Value 1", "Value 2" and "Value 3"

Here is what I tried
POST https://graph.microsoft.com/v1.0/sites/siteid/lists/listid/items/

Body:
{ "fields": { "Title": "Test", "ProductCategory1": ["PWR/Electronics","BIW/Exteriors"] } }

returns a 400 error without further description

{ "fields": { "Title": "Test", "ProductCategory1": {"choices": ["PWR/Electronics","BIW/Exteriors"]} } }

returns a 400 error without further description.
How do I fill this choice field when I create the ListItem? There absolutely no examples anywhere in the documentation for more complex types than string fields.

Thanks for your help!
Shadi

Accepted answer

0 additional answers

Your answer

Answer 1

Rob Windsor 2,001

You need to add a field to tell Microsoft Graph that the value for ProductCategory1 is an array of strings.

{
    "fields": {
        "Title": "Test",
        "******@odata.type": "Collection(Edm.String)",
        "ProductCategory1": [
            "PWR/Electronics",
            "BIW/Exteriors"
        ]
    }
}

Shadi Rashed 71 Reputation points

2022-04-15T12:30:29.517+00:00

Thank you! I will ask for this to be added to the documentation. I could not find this info anywhere
Rob Windsor 2,001 Reputation points

2022-04-15T12:33:21.32+00:00

Glad I could help. If you can, please mark the answer as accepted. Doing so will help others with the same question find the answer they need.
Bas Eenhoorn 1 Reputation point

2022-04-15T15:18:45.827+00:00

I dont know if i must make a post for it, maybe you can answer this here. I have a field of type Managed Metadata (/TermStore item). It seemed to work with this format: d1d17ca29e4a4ad695f735aac708d519=-1;WP1.1|5be0470e-5d5a-4065-a9ad-2afbe5947193

where the name is the internal hidden column name, and the value is term and term id. It seemed to work, but not anymore. Its probably my own fault, but the name and value is correct and it doesnt update the field of the listitem.

Is there by any chance been an update that makes complex fields work? Because i also thought multi select fields were just a string and ; separated.

Can you help me with a simple yes it should work what you do, or a no?

Either way thanks for your time
Rob Windsor 2,001 Reputation points

2022-04-15T15:45:43.677+00:00

I don't have any experience working with managed metadata (taxonomy) fields using Microsoft Graph. This blog post discusses the topic, hopefully you'll fin it to be useful: Use Microsoft Graph to create SharePoint items
Bas Eenhoorn 1 Reputation point

2022-04-15T15:54:20.203+00:00

Thanks for responding. I knew i was off topic so I appreciate the explanation and the link a lot!

Hoyer, Franz 1

how would this look like in .net core ?

I tried this

            var fieldValueSet = new FieldValueSet  
            {  
                AdditionalData = new Dictionary<string, object>()  
                {  
                    {"Title", "Test Test" },  
                    {"******@odata.type", "Collection(Edm.String)" },  
                    {"BORis_ID", "[\"TAB1\"]" }  
                }  
            };  
  
                var updateFileTagsRequest =  
                    graphClient  
                    .Sites[siteId]  
                    .Lists[listId]  
                    .Items[listItemId]  
                    .Fields  
                    .Request();  
  
  
                updateFileTagsRequest.UpdateAsync(fieldValueSet);

but that does not work.

eduardocmb@hotmail.com 1 Reputation point

2022-09-20T13:50:20.127+00:00

Were you able to get it to work in .net core?

Hoyer, Franz 1

yes this works for me

        private void UpdateListItemTags(string siteId, string listId, string listItemId, string[] borisIds)  
        {  
            var listItem = ReadListItem(siteId, listId, listItemId);  
  
            string[] borisIdArray = JsonConvert.DeserializeObject<string[]>(listItem.Fields.AdditionalData["BORis_ID"].ToString());  
            var mergedBorisIds = borisIdArray.Union(borisIds);  
  
            var fieldValueSet = new FieldValueSet  
            {  
                AdditionalData = new Dictionary<string, object>()  
                {  
                    {"******@odata.type", "Collection(Edm.String)" },  
                    {"BORis_ID", mergedBorisIds }  
                }  
            };  
  
            try  
            {  
  
                var updateFileTagsRequest =  
                    graphClient  
                    .Sites[siteId]  
                    .Lists[listId]  
                    .Items[listItemId]  
                    .Fields  
                    .Request();  
  
                updateFileTagsRequest.UpdateAsync(fieldValueSet).Wait();  
  
            } catch (Exception ex)  
            {  
                throw new BorISException(ex.Message);  
            }  
        }

eduardocmb@hotmail.com 1

Yes... I was able to figure it out too. You just need to pass the values as an array. Thanks!

Here is the previous example with that minor adjustment:

var fieldValueSet = new FieldValueSet  
     {  
    	 AdditionalData = new Dictionary<string, object>()  
    	 {  
    		 {"Title", "Test Test" },  
    		 {"******@odata.type", "Collection(Edm.String)" },  
    		 {"BORis_ID", new [] {"TAB1"} }  
    	 }  
     };  
      
     var updateFileTagsRequest =  
    	 graphClient  
    	 .Sites[siteId]  
    	 .Lists[listId]  
    	 .Items[listItemId]  
    	 .Fields  
    	 .Request();  
      
      
     updateFileTagsRequest.UpdateAsync(fieldValueSet);

Jean-Sébastien Dufour 20 Reputation points

2024-11-29T02:41:29.79+00:00

I try this, unfortunotly its not working, is this outdated?

Share via

Create ListItem with Choice Column

0 additional answers

Your answer