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!

Labels

Labels:

Comments

Post a Comment

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)         ...
12 comments
Read more

How Internet Bots Works?

What is bot? An internet robot or simply a bot is a software application that runs automated scripts on the web. How it works? Typically bots perform tasks that are simple and structurally repetitive at a much higher rate than what is possible for human being. So one single bot can handle queries(in whatever format like voice, chat OR Email) of hundreds of customers at the same time. Companies don't want their bots to sound too mechanical or business-like so we need to do a lot of cultural adaption in bots. Machine Learning and Artificial Intellingence (AI) form the underlying base of bots. For businesses to start their bots programme, they should collect a lot of customer related data. This fragmented data is used to populate the knowledge bank servers. Bots which understand behavior pattern will be able to pick "odd" transaction requests like humans do. Most of the Social Media platforms are using bots for most common activities. Below is the pictorial exp...
Post a Comment
Read more