web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Switching from Append ...
Power Automate
Unanswered

Switching from Append Text to Normal Multi Line Text

(0) ShareShare
ReportReport
Posted on by 26

Hi all,

 

I have been using a versioned Sharepoint List that has a comments column with Append Text option turned on. It's causing me more issues than it's worth retrieving text history etc. I'm looking to switch the append text option off, but is there any way with a Flow I can retrieve the comments history and store it in a new normal multi line text column?

 

Thanks!

Categories:
  • ScottShearer Profile Picture
    25,331 Most Valuable Professional on at

    @iali4 

    You would need to use a SharePoint HTTP action to retrieve all past versions of each item.  Create a variable and keep appending the text to the variable.  Then, save the combined value in the text column.  I suggest adding a new multiline text column to save the combined data.

    Here is a link to a blog post that show how to retrieve previous versions of a list item.

     

  • iali4 Profile Picture
    26 on at

    Hi Scott,

     

    Thanks for getting back to me. I've not used the Send HTTP feature before, and a lot of the articles on it go over my head! I've found this article that can retrieve all the versions here using a single REST call https://beaucameron.com/2020/12/22/retrieve-values-of-a-multi-line-text-field-with-append-changes-in-a-single-rest-call/ 

     

    I'm just unsure how I can implement it in my flow which is pictured here:

    screencapture-make-powerautomate-environments-Default-3ac94b33-9135-4821-9502-eafda6592a35-flows-7c3b0a89-84a8-42aa-a5cf-f537c1430d55-2022-08-16-16_21_39.png

    I assume down the YES path of the condition, I'll need to use the Send HTTP action to retrieve the comments, then append the text variable, which will be used to update the new multi line column that has append turned off. Just not actually sure how to implement the action to achieve this?


    Thanks again.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 299

#2
11manish Profile Picture

11manish 274 Super User 2026 Season 2

#3
Henil Profile Picture

Henil 119

Last 30 days Overall leaderboard