You’re offline. This is a read only version of the page.
Hello All,
My goal is to create a flow for when someone responds to my ticket confirmation email it updates a "comment" column I've created in my list with their response. The flow works except when a new response comes through it will simply overwrite what was in the column previously. I would like it to add onto what was written previously. Hoping it will look something like this:
Sample text here.
Response to sample text here.
Its a very nice option inside SharePoint, but its very difficult to work with it anywhere else. I didn't realize how it worked either until someone on the forums asked why they couldn't retrieve the full list. I built a solution to do it in Power Automate, but it requires using HTTP REST calls to retrieve all the versions and then filtering out the empty ones and concatenating the rest. Its not pretty.
Oh shoot. Thanks for the heads up, I’ve never needed to use it that way, I just saw the option one day while working on something else and thought “oh that’s a cool other way to do that.”
@takolota Just be aware that one problem with that solution is that Power Apps and Power Automate will only retrieve the last text entered into that column. To get all the entries you need to do a fairly complex process of retrieving all the previous versions. SharePoint does it in the list automatically, but its not easy to duplicate that elsewhere.
The Get Items will retrieve the existing items. That will give you access to the current comments. Just Concatenate that with the new comment retrieved from the Email and use the result to update the item.
#1
WarrenBelz
146,522
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,890
Most Valuable Professional
Share
Report
All responses (
Answers (
