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

Thilina Tantirigama 86 Reputation points
2022-10-16T21:40:57.997+00:00

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?

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,901 questions
0 comments No comments
{count} votes

5 answers

Sort by: Most helpful
  1. Xuyan Ding - MSFT 7,561 Reputation points
    2022-10-17T09:37:28.957+00:00

    Hi @Thilina Tantirigama ,

    Here are the steps:
    1.Create a column->Select 'Use enhanced rich text'->save
    250940-image.png

    2.Double-click the item->edit->copy the table and paste it here->save
    251010-image.png
    251052-image.png
    250959-image.png

    3.The result is shown below.
    251030-image.png


    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.

    0 comments No comments

  2. Thilina Tantirigama 86 Reputation points
    2022-10-17T21:18:21.877+00:00

    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?


  3. Thilina Tantirigama 86 Reputation points
    2022-10-21T03:59:02.457+00:00

    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.

    0 comments No comments

  4. Xuyan Ding - MSFT 7,561 Reputation points
    2022-10-21T10:58:59.07+00:00

    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.
    252919-image.png 252949-image.png
    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.

    0 comments No comments

  5. Thilina Tantirigama 86 Reputation points
    2022-10-24T21:12:31.7+00:00

    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?
    253664-2022-10-25-10-06-29-window.png