Capture table text data into one multiline textbox column in Sharepoint Online

Question

I have a table with a number of rows and columns that I want to insert into a multiline text column in SharePoint. Instead of creating seperate columns, can you suggest a way to capture all table data into one multiline text column?

Answer 1

Hi @Thilina Tantirigama ,

Here are the steps：
1.Create a column->Select 'Use enhanced rich text'->save

2.Double-click the item->edit->copy the table and paste it here->save

3.The result is shown below.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Thanks @Xuyan Ding - MSFT for your response.
What I'm after is a way to capture values from a table in a user form (whether I use SharePoint, MS Forms or PowerApps) into one multi-line text column. There are also other fields in the form that correspond to other columns in the same list.
OR is there a way to have the fields prepopulated (as a default value) in the multiline column (using JSON or formula?) so when the user fills in the form, that column will have the fields which they need to fill?

Answer 3

I have a set of table columns (therefore a x number of values) in a table in a user form that I want to add to a single multi-line text column. Understand JSON can only do column formatting.

Answer 4

Hi @Thilina Tantirigama ,

Let me briefly describe my understanding, you have some columns in the list, and when some values are filled, they will be combined and displayed in a multi-line text column? This should be achieved by using PowerApps.
If I'm wrong, feel free to point it out and provide a schematic diagram of your needs.

Below is a rough demo of mine:
Using the Concatenate function in PowerApps to achieve connection display in a multi-line text column. Show as static default.

Dynamic connections can create rules to implement changes and updates of values. You can seek support from the PowerApps community for specific settings on this.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 5

Hi @Xuyan Ding - MSFT
Thanks for your response. That's helpful however (as I previously mentioned) I need to combine values from a table (see attached) within a user form, and insert these table values into one multi-line column in the SP list, not combine values from multiple fields. This may not be possible, I'm just checking if it can be done, or what would be the best practice for this sort of requirement?