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.
Keep up to date with current events and community announcements in the Power Automate community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!