Skip to main content

"cannot update library or list" while publishing InfoPath form

This error comes when the column limit is exceeded in InfoPath form library because of the setting change happens when we take template from QA to PROD environments. Anyone should never use "Quick Publish" button on the ribbon of InfoPath in high risk environments and check every column mapped in Property Promotion window of publish wizard.

The following CSOM code can be used to delete the duplicate columns(which are read-only) created because of the above error,

ClientContext context = new ClientContext(sharePointSiteURL);
Site oSite = context.Site;
context.Load(oSite);
Web web = context.Web;
List doclist = web.Lists.GetByTitle("LibraryName");
context.Load(doclist);
context.ExecuteQuery();
FieldCollection fieldCollection = web.Lists.GetByTitle("LibraryName").Fields;
foreach (Field column in fieldCollection)
{
    if (column.InternalName.Equals("ColumnName"))
    {
        column.ReadOnlyField = false;       
        column.Update();       
        column.DeleteObject();       
        column.Update();       
        context.ExecuteQuery();
    }
}

The following links have more related information,

Hope this helps someone!

Comments

Popular posts from this blog

Permission audit report for site and all sub sites using PowerShell

Use below script to get Permission audit report for site and all sub sites using PowerShell, Add-PSSnapin "Microsoft.SharePoint.PowerShell" $URL="https://intranet.contoso.com/sales/mysite/"      $site = Get-SPSite $URL      #Write the Header to "Tab Separated Text File"         "Site Name`t  URL `t Group Name `t User Account `t User Name `t E-Mail" | out-file "E:\Ulhas\UsersandGroupsRpt.txt"          #Iterate through all Webs       foreach ($web in $site.AllWebs)       {         #Write the Header to "Tab Separated Text File"         "$($web.title) `t $($web.URL) `t  `t  `t `t " | out-file "E:\Ulhas\UsersandGroupsRpt.txt" -append          #Get all Groups and Iterate through            foreach ($group in $Web.groups)         ...

Populate people picker field with logged in user in SharePoint using JS

Please use below code to populate people picker in SharePoint online, <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script> <script type="text/javascript"> ExecuteOrDelayUntilScriptLoaded(function () { setTimeout(function () { SetUserFieldValue('AuthorName'); }, 1000); }, 'clientpeoplepicker.js'); //Set PeoplePicker Value function SetUserFieldValue(fieldName) { try{ var userAccountName = _spPageContextInfo.userLoginName; //PeoplePicker Object var peoplePicker = $("div[title='" + fieldName + "']"); //PeoplePicker ID var peoplePickerTopId = peoplePicker.attr('id'); //People PickerEditor var peoplePickerEditor = $("input[title='" + fieldName + "']"); //Set Value to Editor peoplePickerEditor.val(userAccountName); //Get Client PeoplePicker Dict var peoplePickerObject = SPClientPeoplePicke...