Forum Discussion
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_ElliottBronze 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)- pigsinblanketsCopper 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 🙂