Skip to main content

Managed Metadata Column Value Add with Angular | JavaScript & JSOM | CSOM

Following would be high-level program flow;MMS Column Update Program Flow

SP Taxonomy need to be imported.

[code language="javascript"]

var scriptbase = _spPageContextInfo.webServerRelativeUrl + "/_layouts/15/";
$.getScript(scriptbase + "SP.Taxonomy.js");
[/code]

Create custom list item with metadata column in SharePoint with JSOM and Angular JS.

[code language="javascript"]
// Adding item to SharePoint custom list with Managed Metadata column (MMS column) with JSOM
(function () {
'use strict';

// define controller
var controllerId = "mmsColumnUploadCtrl";

angular
.module('app')
.controller(controllerId, ['$scope', mmsColumnUploadCtrl]);

// create controller
function mmsColumnUploadCtrl($scope) {
//global var
var vm = this;

//add metadata column to sharepoint
vm.AddMetadataColumn = function () {
var scriptbase = _spPageContextInfo.webServerRelativeUrl + "/_layouts/15/";

// create list item with MMS column
$.getScript(scriptbase + "SP.Taxonomy.js", createListItemWithMMSColumn);

}

//Create list item metadata with MMS column
function createListItemWithMMSColumn() {
//site URi
var siteUrl = 'http://<site url>/sites/MMSPOC';
// List name of updating
var listName = 'TestList';// List name
//Term GUID get from Service
var termId = 'ed414e70-cc02-444b-ba78-8456e6495e45';//term GUID
//For multi labled column may need to provice term lable also, else no
//var termLabel = 'ABCTEST';//Term label

// Client context
var clientContext = new SP.ClientContext(siteUrl);
var oList = clientContext.get_web().get_lists().getByTitle(listName);
var itemCreateInfo = new SP.ListItemCreationInformation();
var oListItem = oList.addItem(itemCreateInfo);
// Define item
oListItem.set_item('Title', 'New Item!'); // non MMS columns
oListItem.set_item('MMSCol', termId); //MMS column
// Update item
oListItem.update();

//client context..Async Req.
clientContext.load(oListItem);
clientContext.executeQueryAsync(
Function.createDelegate(this, onQuerySucceeded),
Function.createDelegate(this, onQueryFailed)
);
}

// On query success
function onQuerySucceeded(oListItem) {
console.info('Item created!');
}
// On query failed
function onQueryFailed(sender, args) {
console.error('Request failed. ' + args.get_message() + '\n' + args.get_stackTrace());
}

};

})();

[/code]

Update document library items' managed metadata column in SharePoint with JSOM and Angular

[code language="javascript"]
// Adding item to SharePoint "Document Library" with Managed Metadata column (MMS column) with JSOM
(function () {
'use strict';

// define controller
var controllerId = "mmsColumnUploadCtrl";

angular
.module('app')
.controller(controllerId, ['$scope', mmsColumnUploadCtrl]);

// create controller
function mmsColumnUploadCtrl($scope) {
//global var
var vm = this;

//add metadata column to sharepoint
vm.AddMetadataColumn = function () {
var scriptbase = _spPageContextInfo.webServerRelativeUrl + "/_layouts/15/";

// Create document item ith MSS column
$.getScript(scriptbase + "SP.Taxonomy.js", updateDocumentItemWithMMSColumn);

}

// Create document metadata of document library item with MMS column
function updateDocumentItemWithMMSColumn() {
//site URi
var siteUrl = 'http://<site>/sites/MMSPOC';

// List name of updating
var listName = 'MMSPOCDocLib';//document library name

// GUID of the term
var termId = 'ed414e70-cc02-444b-ba78-8456e6495e45';//term guid

//For multi-valued terms following will be needed
var termLabel = 'ABCTEST';//term label

//Item Id for update in the document library
//3 is item ID to be updated
//You may dynamically change with the requirement
var itemIdUpdating = 3;

// Client context
var clientContext = new SP.ClientContext(siteUrl);
var oList = clientContext.get_web().get_lists().getByTitle(listName);
var itemCreateInfo = new SP.ListItemCreationInformation();

var oListItem = oList.getItemById(itemIdUpdating);
// Define item
oListItem.set_item('Title', 'Item updated!');
oListItem.set_item('MMSCol', termId);
// Update item
oListItem.update();

//client context..Async Req.
clientContext.load(oListItem);
clientContext.executeQueryAsync(
Function.createDelegate(this, onQuerySucceeded),
Function.createDelegate(this, onQueryFailed)
);
}
// On query success
function onQuerySucceeded(oListItem) {
console.info('Item created!');
}
// On query failed
function onQueryFailed(sender, args) {
console.error('Request failed. ' + args.get_message() + '\n' + args.get_stackTrace());
}
};
[/code]
Await for more interesting coding samples and articles, keep following!! 

Comments

  1. […] https://kushanlahiru.wordpress.com/2016/09/05/managed-metadata-column-value-add-with-angular-javascr… […]

    ReplyDelete

Post a Comment

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 linkto 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 projectResolve dependencies > npm iBundle > gulp bundle --shipPackage > gulp package-solution --shipUpload package into SharePoint App catalog and deploy. You could find package under SharePoint folder.A…

PowerApps Delegation warning

Warning:Delegation warning. This part "Filter" of this formula might not work correctly on large datasets. The data source might not be able to process the formula and might return an incomplete data set. Your application might not return correct results or behave correctly if the data set is incomplete
"Working with large datasets requires using data sources and formulas that can be delegated" - PowerApps 










Solution!!!500 is the default number of records to pull, but you can change this number for an entire app. 

By altering the number of delegation queries (not recommended), you will be able to pull items up to 2000 (as of 2018). 
On the File tab, select App settings.Find Experimental features, change the Data row limit for non-delegable queries setting from 1 to 2000.










Data sources that will help with delegation:Common Data Service

Microsoft Ignite Community (FREE) Events #MSIgnite

If you around Microsoft Ignite 2018, don't miss below community (FREE) events. 

Microsoft Ignite Welcome Reception

When: Monday, 5:30p – 7:30pm

Where: Exhibit Hall

Details: Kick off Ignite the right way with Monday’s welcome reception where you can chat with Microsoft experts, see demos, see old friends and make new ones over food and drinks.

PowerShell Community Social

When: Monday, 7:00p – 7:30p

Where: Community Central (OCCC West Hall)

Details: Come have a drink and meet Jeffrey Snover and PowerShell MVPs like Jaap Brasser, Aleksandar Nikolic, and Aaron Nelson immediately following the welcome reception.

Data & AI Community Social

When: Tuesday, 9:00a – 10:00a

Where: Community Central (OCCC West Hall)

Details: Do you do that Voodoo? Well, you can at the Data & AI Community Social. Eric Boyd and Rohan Kumar, along with MVPs Cathrine Wilhelmsen and Melody Zacharias will be there with Voodoo donuts and nitrogen cold brew coffee.

Microsoft Teams Community Social

When: Tuesday, …