Skip to main content

Clear | Remove | Delete Managed metadata (Taxanomy) column value in SharePoint List/ library

You may find many references to write into taxonomy columns (aka. managed metadata columns) but the clearing those is pretty much tricky.

Following code sample guide you through how you can clear the taxonomy column value in you custom client side application (JSOM) based on SharePoint.

[code type="javascript"]
//USAGE:
//clearWithValue =true => for clear saved taxanomy column values
//clearWithValue =false => wite into taxanomy column

function saveValuesToManagedMetadataColumns(listName, fieldId, taxanomyLabel, siteUrl, clearWithValue) {

//You many need seperate function to resolve GUID for the lable.
//Its based on your requirement and for now its hardcoded
var taxonmyGuid = "9f75f519-51f8-4723-9182-7e8225a54031";
//Loading context and list
var context = new SP.ClientContext(siteUrl);
var list = context.get_web().get_lists().getByTitle(listName);
//Getting item to update
var camlQuery = new SP.CamlQuery();
camlQuery.set_viewXml("<View>" +
"<Query>" +
"<Where><Eq>" +
"<FieldRef Name=\'ID\'/>" +
"<Value Type=\'Number\'>" + fieldId + "</Value>" +
"</Eq></Where>" +
"</Query>" +
"</View>");
var items = list.getItems(camlQuery);
//Load selected items to context
context.load(items);
//Loading MMS field
var field = list.get_fields().getByInternalNameOrTitle("taxanomyColumnName");
var txField = context.castTo(field, SP.Taxonomy.TaxonomyField);
//Load field to context
context.load(txField);

context.executeQueryAsync(function () {
//getting term set ID
var functionTermSetId = txField.get_termSetId().toString();
//Term value build for update..this is not useful is your purpose only for clearing
//But for illustration..got below also to show off
var termValue = new SP.Taxonomy.TaxonomyFieldValue();
termValue.set_label(taxanomyLabel);
termValue.set_termGuid(taxonmyGuid);
termValue.set_wssId(-1);
//Iterate through collection and update
var e = items.getEnumerator();
while (e.moveNext()) {
var item = e.get_current();

//Save to taxanomy column
if (clearWithValue == false)
txField.setFieldValueByValue(item, termValue);

//Clering taxanomy column
if (clearWithValue == true)
txField.validateSetValue(item, null);

//Set noraml fields..If you have them too
item.set_item('Title', metadataCollection.Title);

item.update();
}
context.executeQueryAsync(function (sender, args) {
console.log('Successfully updated item with ', args, serviceId, false);
}, function (args) {
console.log('Error on updating item with taxanomy value', args, serviceId, false);
});

}, function (args) {
console.log('Internal server Error on updating item with taxanomy metadata', args, serviceId, false);
});

}
[/code]
References
http://sharepoint.stackexchange.com/questions/47719/how-can-i-set-empty-value-to-taxonomyfield-of-microsoft-sharepoint-client-taxono

Comments

Popular posts from this blog

Turn off/ Hide Details panel/ Information Panel on modern SharePoint lists

Not always we require to show changes done by other which is a mandatory feature in SharePoint online.  What is details pane (aka. Information Pane)? Detail pane/ Information shows information regarding the document if you selected a one or its showing recent changes within a list or library. Follow link to Microsoft documentation about details pane. Bad news: Until Microsoft listen to User Voice , there is no straightforward way to enable disable this even you don't want. Good news: We could write a SharePoint framework extension to hack styles until Microsoft give us a permanent solution. How? I found this sample project (Inject CSS into modern SharePoint pages with React) which could reuse to our purpose. Thanks to Hugo for saving my time.  Steps to awesomeness:  Clone the project Resolve dependencies >  npm i Bundle >  gulp bundle --ship Package >  gulp package-solution --ship Upload package into SharePoint App catalog  

File attach (POST) to SharePoint 2013 List (custom) using Angular JS via REST API

Following describes how to upload attachment to SharePoint 2013 custom list using Angular JS. Note: You can be consumed the JSOM libraries to achieve this, but there is limitation of 1.5 Mb. Better approach would be consuming exposed REST API (SharePoint OOTB) which allowed up to 2 Gb of file to attached using client side scripts i.e. Angular JS. . Here I have used the “Angular File Upload” which capable of doing more tasks other than basic HTML input file control. By consuming this we can attach multiple files either to the list and etc. You can be found the information on how to include this module to your Angular view in following link. Use package manager command to install the scripts. For bower  -->        bower install angular-file-upload For nugget -->       npm install angular-file-upload It requires file buffer array to POST (save) our attachment via REST API, browsers FileReader API is required to use. Its available with almost all common browsers. You need to ensure t

📢 Update -Microsoft Teams IP Phones and Intune Enrollment

For customers who require desk phones and conference room phones to make and receive audio calls or join meetings, Microsoft Teams provides a growing portfolio of devices that can be purchased from our Teams Marketplace . For Teams phones including the Yealink T56A/T58A/CP960 and the Crestron Flex series IP phones that run on Android 5.x or later, there may be specific configurations that need to be enabled in the customer's tenant for the phones to successfully enroll into Intune.      Allowing successful Intune enrollment for Android versions 5.x and up     If all the following conditions below are true , you will need to enable a specific configuration setting in the Intune admin console to allow for a successful enrollment:   You are deploying a Teams IP phone with Android OS version 5.x or later.   You have connected your Intune tenant with managed Google Play in order to manage Android Enterprise devices.   You have configured your enrollment restrictions such that A