none
Change of Column type from Single Line text to Multiline Text RRS feed

  • General discussion

  • Hi Team ,

    I am facing an issue in converting the Column with Single Line of Text to Multiline of text in  a SharePoint 2013 OnPrem List .

    What could be the reason . I have done it previous many times , it went successful . But this time it is not doing .

    Here's the error . I will appreciate your answers.

    Thanks ,

    KBdotnet.

    Tuesday, June 2, 2020 1:30 PM

All replies

  • It is not possible to convert a single line text field to a multi-line text field. Instead you should create a new multi-line text field and move the data from the old field to the new field.
    Tuesday, June 2, 2020 1:33 PM
  • No Charles .

    You are not correct . It happened earlier. try it from scratch . It will work.

    Did you see the screenshot I attached.?

    Tuesday, June 2, 2020 1:42 PM
  • what is the error you are getting ? Ty with the below sample script for your requirement:

    Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue
     
    #Get the Web where Lists Live
    $web= Get-SPWeb "http://global.SharePoint.com/sites/TEST"
     
    #Define Array to hold Lists Names to Scan
    $ListNames =  ("Test")
     
    #Column to Change
    $ColumnName ="Test01"
     
     #Iterate through provided Lists 
    foreach($ListName in $ListNames)
    {
        #Get the List
        $list = $web.Lists.TryGetList($ListName) 
        if( $list -ne $null)
         {
            #Check if the list has our target column to change
            if($list.fields.ContainsField($ColumnName))
            {
               #Get the Column to Change
               $column = $List.Fields[$ColumnName]
        
               #Change the Column type to "Multiple Lines of Text"
               $column.Type = [Microsoft.SharePoint.SPFieldType]::Note
               $column.Update()
               Write-Host "Field type updated on: $($List.Title)"
            }
        }
    }
     
    $web.Dispose()

    Below article for your reference:

    https://www.sharepointdiary.com/2013/09/change-column-type-in-list-using-powershell.html

    Thanks & Regards,


    sharath aluri

    Tuesday, June 2, 2020 2:46 PM
  • I am getting below Error 



    • Edited by kbdotnet Tuesday, June 2, 2020 3:12 PM
    Tuesday, June 2, 2020 3:09 PM
  • Seems like you are trying for a default fields, I would say not to change any default fields instead you could hide them and create a new custom one and change the type of those custom fields.

    Thanks & Regards,


    sharath aluri

    Tuesday, June 2, 2020 3:48 PM
  • I am saying , it had happened earlier.

    Please try from scratch ..It has happened earlier .

    Tuesday, June 2, 2020 3:54 PM
  • what do you mean please try from scratch and it has happened earlier ?

    Thanks & Regards,


    sharath aluri

    Tuesday, June 2, 2020 6:51 PM
  • I mean to say - 

    Take a blank site , add a Single Line of text column in a List and then Change its type to Multiline text .

    It will change  . I have changed it earlier .

    Hope you get it now.

    Wednesday, June 3, 2020 1:45 AM
  • Well i tried the same in team site of the same steps you did and it worked on my end too, but what i am saying is the change the type of the column it should be a custom one not the default one meaning if you create and add any new column you can change the type of it but if that is a default column meaning already existed one from the list like Title, created, created by, modified, modified by you can't change these. What is the name of the column you are trying to change ?

    Thanks & Regards,


    sharath aluri

    Wednesday, June 3, 2020 1:02 PM