Forum Discussion

pigsinblankets's avatar
pigsinblankets
Copper Contributor
Oct 17, 2024

Change multiple line of text column to single line of text

Good morning, 

 

I have a multiple line of text column in a Microsoft List. All names are under 255 characters.

 

Just wondering if I can change this to a single line of text column without losing any data? SharePoint doesn't pop up a you may lose data box but I'm still not sure if it will work so haven't saved it. 

 

This is needed for how data is formatted elsewhere. 

 

Thanks! 

  • pigsinblankets you won't lose any data if all the items in the column are 255 characters or less in length. For any that are more than that you will lose the text after the first 255 characters.

     

    Rob
    Los Gallardos
    Microsoft Power Automate Community Super User.
    Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)

  • Rob_Elliott's avatar
    Rob_Elliott
    Bronze Contributor

    pigsinblankets you won't lose any data if all the items in the column are 255 characters or less in length. For any that are more than that you will lose the text after the first 255 characters.

     

    Rob
    Los Gallardos
    Microsoft Power Automate Community Super User.
    Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)

    • pigsinblankets's avatar
      pigsinblankets
      Copper Contributor

      Rob_Elliott Thanks so much Rob, it's a bit of an important data set to say the least so wanted to double check, thanks again 🙂

Resources