I want to be able to export all entries (content) of a MS Lists multi-line appended column.

Caroll Mitchell 0 Reputation points
2024-03-17T22:18:07.44+00:00

In our SharePoint List workflow we need to be able to easily report the "what happened" type history of records/rows. The field/column that contains this history is a multi-line, append to existing text type.

Scenario: report (in Excel format) to a client the action (what was done, when) history of multiple rows/records.

I understand this is currently not possible.

  • Is there a plan to implement a solution?
  • Is there a workaround?

Thanks for any tips/advice you can give.

Caroll

SharePoint Workflow
SharePoint Workflow
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Workflow: An orchestrated and repeatable pattern of business activity, enabling data transformation, service provision, and information retrieval.
506 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Ling Zhou_MSFT 13,030 Reputation points Microsoft Vendor
    2024-03-18T07:17:50.97+00:00

    Hi @Caroll Mitchell,

    Based on your problem description, I tried to implement your problem using flows or calculated formula columns, but neither of them solved your problem.

    It doesn't make sense for MS List columns to record historical version values to multiple lines of text. Because we can check the historical version to know how the content has changed and how it was changed.

    Please accept my sincerely apologize for any in convenience this may cause. Thank you for your kind understanding.


    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.