CSOM code to convert my drop-down field's choices into terms

Question

I have a field of type Choice with these options:-

Open
In-progress
Approved
Rejected
Cancelled
On-Hold
..
..
..
Closed

and i want to convert this site column into a managed metadata column. so i created a new site column of type managed metadata and i link it to a new term set which contain the above choices as terms. but i am not sure how i can write a CSOM code to do the conversion from the choices to terms, mainly the following:-

1- Get the term's GUID based on the term name (choice name).

2- Assign the GUID to the managed metadata field.

any advice on this please?

thanks

Answer 1

Hi @john john ,

Here is a csom code to set managed metadata field Term value based on Choice field value:

   using (var clientContext = new ClientContext("https://zheguo.sharepoint.com/"))  
            {  
                clientContext.Credentials = new Microsoft.SharePoint.Client.SharePointOnlineCredentials(userName, securePassword);  
                Web web = clientContext.Web;  
                clientContext.Load(web);  
                clientContext.ExecuteQuery();  
                List list = clientContext.Web.Lists.GetByTitle("MyList");  
                ListItemCollection items = list.GetItems(CamlQuery.CreateAllItemsQuery());  
                clientContext.Load(items);  
                clientContext.ExecuteQuery();  
                foreach (ListItem item in items)  
                {  
                    TaxonomySession taxonomySession = TaxonomySession.GetTaxonomySession(clientContext);  
                    TermStore termStore = taxonomySession.GetDefaultSiteCollectionTermStore();  
                    clientContext.Load(taxonomySession);  
                    clientContext.Load(termStore);  
                    clientContext.ExecuteQuery();  
                    TermGroup termGroup = termStore.Groups.GetByName("Site Collection - zheguo.sharepoint.com");  
                    clientContext.Load(termGroup);  
                    TermSet termSet = termGroup.TermSets.GetByName("TestTermSet");  
                    clientContext.Load(termSet);  
                    Term term = termSet.Terms.GetByName(item["TestChoice"].ToString());  
                    clientContext.Load(term);  
                    clientContext.ExecuteQuery();  
                    item["TestMeta"] = term.Id.ToString();  
                    item.Update();  
  
                }  
                clientContext.ExecuteQuery();  
  
            }  

This is my TermSet settings in Site Collection Term Store:

Change TermGroup and TermSet Group name with yours.

And here is the field value settings (TestChoice and TestMeta field)

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.