CHI - Life Beyond Technology

I deployed some test apps to check some functionality and suddenly noticed that remove app menu item is missing. Wasting about an hour figure out that we need to click on the return to classic SharePoint to go back to older view and use that menu to remove the app. Missing Remove menu item. Old look and feel with remove menu item Just after doing that faced another issue where I couldn't go back to the new look and feel mode. I had global admin privileges when I was doing this so I initially though i change entire tenant back to classic mode. Killing another few minutes figure out its just a temporary and once you close all the browser windows and login again it will give you the modern look and feel. Hope this will save time on someone else.

In SharePoint 2013 if list has large no of items sometimes its not showing quick edit option for the list. When this happens there is another way we can edit all the rows by using DataSheet View. https://spdatasheet.codeplex.com/

If you are working on SharePoint apps development you will need to know the SharePoint dll version to put webparts in to the page. In webparts we need to provide the SharePoint dll version in the  '  In this sinario you can use following service url and make a quick call and get the version of the SharePoint dll on Office 365 SharePoint Online as well as SharePoint Onprem. /_vti_pvt/buildversion.cnf SharePoint On Premise output vti_encoding:SR|utf8-nl vti_buildversion:SR|15.0.4737.1000 SharePoint Online Office 365 output as of 04/07/2017 vti_encoding:SR|utf8-nl vti_buildversion:SR|16.0.6621.1204 Function for get the version no.     getSharePointVersion: function () {         var ver = null;         $.ajax({             url: "/_vti_pvt/buildversion.cnf",             async: false,         }).done(function (result) {             var lines = result.trim().split('\n');             if (lines.length == 2) {                 var versionProperty = li

This summary is not available. Please click here to view the post.

Here is good article about SharePoint Themes. This explains lot of information about themes and how we can modify them. It also has steps of how we can use SharePoint Color Palette Tool. https://en.share-gate.com/blog/create-sharepoint2013-theme-using-color-palette-tool SharePoint Color Palette Tool Download Link https://www.microsoft.com/en-au/download/details.aspx?id=38182

1. In the select Users or Groups window Select local server name 2. Type IIS AppPool\DefaultAppPool as object name to select 3. Press check Names. Default App pool account will resolve

// Get Project data function GetProjectData(filterValues) {     var d = $.Deferred();     var url = "https://epmo.dtz.com/Defence/_api/ProjectData/Projects?$select=ProjectName,ProjectIDCopy,ProjectDescriptor,DeliveryAgentProjectManager,ProjectDeliveryRegion,ProjectManagerName,TotalMultiYearbudget";     var filter = "";     // Creating the filter     for (var property in filterValues) {         if (filter && filterValues[property]) {             filter += " and ";         }         if (filterValues[property]) {             filter += "substring(" + property + ",0," + (Number(filterValues[property].length) - Number(1)) + ") eq" + "'" + filterValues[property] + "'";  // Building filter eg:substring(ProjectName, 1, 2) eq 'CA'         }     };     // If filter is not null append it to the url     if (filter) {         url = url + "&$filter=" + filter;    

Simple POC did to read Excel file rows and columns. Code extracted from following link. https://www.codeproject.com/Tips/801032/Csharp-How-To-Read-xlsx-Excel-File-With-Lines-of       public static void ReadExcel()         {             var count = 0;             foreach (var worksheet in Workbook.Worksheets("2010AllItems.xlsx"))                 foreach (var row in worksheet.Rows)                 {                     count++;                     foreach (var cell in row.Cells)                     {                         Console.WriteLine(cell.Text);                         // if (cell != null) // Do something with the cells                     }                     if (count > 2)                         break;                 } }

For more information check this link.         http://sharepointkitchen.blogspot.com.au/2014/12/bulk-insertupdatedelete-items-from.html public static void BulkUpdate()         {             var siteUrl = "http://zdc1ws048:4321/test/Sharepoint2010";             var listName = "TestList";             var columnName = "Title";             var searchValue = "TestValue07";             var newValue = "It is Updated";             try             {                 using (SPSite _oSite = new SPSite(siteUrl))                 {                     using (SPWeb _oWeb = _oSite.OpenWeb())                     {                         SPList _oList = _oWeb.Lists.TryGetList(listName);                         if (_oList != null)                         {                             _oWeb.AllowUnsafeUpdates = true;                             Guid listGuid = _oList.ID;                             StringBuild