I have a list in SharePoint where my items are stored.In the flow i have multiple approvers, and i want to know for each item the comments added by those approvers.
So i have created a Comments column in my list of type (Multiple Lines of text), and in my flow i have added to this column the Responses Approver Name and Responses Comments to get the user name and the comments added by this user.
The problem is on each approval outcome the item is updated again and being replaced with the latest approval.
What i want to, is to save all the comments with the approver names in the same column without deleting the other approver names and comments similar to this image:
Here is my flow:
So what i should use action or expression to append all the approvals names and comments in the same column ?
Any help will be greatly appreciated!
Solved! Go to Solution.
My next suggestion would be to create a string variable for the comments, then use the action Append to String Variable inside of the Apply to each action. Something like:
Then when you update the list item Status, include the Approval Comments field = strComments.
Three Super User rank tiers have been launched!
Features releasing from October 2020 through March 2021
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!