1 – First create a site column for multi-line text field by going to site settings – Web Designer Gallery – Site Columns – Create 2 – Create the site column and add it to a content type or SharePoint list. 3 – Add atleast one list item to the list, its important so it can create the crawled property for the body column. In InfoPath create a Multiple Line of Plain Text field and name it EXACTLY the same as your old Single Line of Text field and publish once more. You are now done and whatever you put in your multiple line of text field will show up in your Calculated Column. Check out this post to see an example of this process in action. Jan 09, 2017 Step 2: Create a new “multiple lines of text” column. Unless you have it already, go ahead and create a new column (List Settings Create a Column) In the example below, I am setting up a column on a Task List web part, so I can track Task comments. Make sure to choose Multiple lines of text for the column type. Aug 31, 2020 Calculated columns are very useful columns in SharePoint. By using a calculated column, you can create a formula that includes data from other columns and performs functions to calculate dates and times, to perform mathematical equations, or to manipulate text.
- This topic has 1 reply, 2 voices, and was last updated 3 years, 2 months ago by .
Sorry for the late reply. I’m not 100% sure I understand what you try to do. How long text are you planning to have in the multiline textfield? – it will be quite difficult for the user to pick the correct one from a dropdown if the text is super long?
Are you using the multiline text only to identify the correct “mother” in list A, or do you want to replicate / show the text in list B?
Maybe you can try this old solution? Read the comments about using it with DFFS.
Alexadner
This is one of the challenges to SharePoint search content on a list from multiline field. Multi line text field cannot be indexed as it’s an Unsupported Column Type.
Indexing the field is separate from search crawling which is needed for search result. Make sure the column has a managed property which allows a column to be searchable, retrievable and quarriable.
I noticed an issue on a list with over 10000 lists items where content for multiline text was not working on list search page and not showing the required outcome whereas it shows the required result on the site search. So I believe that in a SharePoint list, multiple line content search do not working properly if list view threshold is over 5000 items.
Steps to Create Managed Property
First you need to create a site column and then create a Managed Property
1 – First create a site column for multi-line text field by going to site settings –> Web Designer Gallery –> Site Columns –> Create
2 – Create the site column and add it to a content type or SharePoint list.
3 – Add atleast one list item to the list, its important so it can create the crawled property for the body column. Now run full crawl on the list.
4 – Now go back to Site Settings –> Site Collection Administration –> Search Schema and click on New Managed Property.
5 – Now select the add mapping properties
6 – Leave “Text” selected, also check Searchable, Queryable and Retrievable.
7 – You can map multiple properties against this managed property to make sure you are fetching all the relevant columns.
8 – The crawled property is different depending upon what you named it. My column was called Body, so I found it under “ows_body”, “Body”, “ows_Body1” and “ows_Body_1”. I added multiple properties because I used body field in multiple lists.
9 – Now you can start the list index or wait for some time so search crawl can run automatically.
The following two tabs change content below.
Sharepoint Calculated Column Multi Line Text
- Five ways to get OneDrive URL for a User in Microsoft 365 - March 1, 2020
- OneDrive Sync issue: SharePoint Documents Library not syncing - February 12, 2020
- Teamwork in Microsoft 365 - September 18, 2019