Sharepoint Calculated Column With Multiple Lines Of Text

• Sharepoint Calculated Column Multiple Lines Of Text

So, I thought I might be able to find a way to use a Multiple Lines of Text column, and then use a Calculated column to display it as a neat, short hyperlink. The only problem I needed to solve was the one of Calculated columns not allowing Multiple Lines of Text columns to be used in their formulas.

I had a form in production that a client was using to track requests for items that required justification. During testing, we noticed that once the form was submitted, the rich-text field in InfoPath displayed as a Single Line of Text field in SharePoint but the client was sure that all justifications would be short. Famous last words. Several users wrote novels and when (oops!) we added an approval to the request directly in SharePoint, we lost all but the first 255 characters of the novel!

The solution didn't help us retrieve the lost novels/justifications, but we were able to figure out how to get all the information to map to a rich text field in SharePoint, even if the approach requires several steps. The solution is the following:

After you publish the form to SharePoint the first time, go to the SharePoint list and create a new column with a type of Multiple Lines of Text. If you think people will be writing a lot of text in the field, be sure to select the 'allow unlimited length in document libraries' button.

Then, go in to the InfoPath form and in the publishing wizard where you choose which fields to promote to SharePoint, highlight your source field and hit Modify. Then, map your source field in InfoPath to your newly created multi-line text field in SharePoint and all the characters typed in by the user will transfer to SharePoint and you won't lose them (even if you may want to!).

If users do write lots and lots of text in the form field, your SharePoint views will not be pretty, but all of the information will be visible. Fortunately, we only had a few cases where we'd edited the form data from SharePoint and the user wrote lengthy justifications so the impact was not devastating.

Keyboard for fl studio. It took me several attempts at crafting a Google search to resolve this issue so I hope this helps someone else (or gets someone to identify a better way).

Hi Kevin,

I am writing to follow up this issue. I am not sure which SharePoint list experience you are using for this list (classic or new experience).

Assume that you are using new list experience. In this case, the Multi lines of text column (allowed type of text set to Plain text) only shows certain length of text. To check the whole content for this column, you can click the information icon on the ribbon > select the list item > Click See more on the right pane to check all the contents.

Also, it looks like that the text box settings for this InfoPath form has not enabled text wrap. You can enable this option for a try.

To do this, you can right click on the text box in InfoPath > text box properties > click display tab > select Multi-line > OK > Publish.

If you are using classic experience, can you capture a screenshot of that “not text-wrap” columnfor investigation?

Regards,

Ryan

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

Sharepoint Calculated Column Multiple Lines Of Text

How satisfied are you with this response?

Thanks for your feedback.