cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Prodigy
Post Prodigy

Appending all approval comments in same column

Hello everyone!

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:

Capture2.PNG

Here is my flow:

Capture3.PNG

Capture4.PNG

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!

Thank you!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Advocate I
Advocate I

Re: Appending all approval comments in same column

Can you set the Comments column to Append Changes to Existing Text?

MultiLine Append.png

View solution in original post

4 REPLIES 4
Highlighted
Advocate I
Advocate I

Re: Appending all approval comments in same column

Can you set the Comments column to Append Changes to Existing Text?

MultiLine Append.png

View solution in original post

Highlighted
Community Support
Community Support

Re: Appending all approval comments in same column

Hi @Julien2,

 

Has your problem been solved by @jonathanmweaver's advice?
If your problem has been solved, You could go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

Best Regards,
Community Support Team _ Lin Tu

Highlighted
Frequent Visitor

Re: Appending all approval comments in same column

I have the exact same issue and checking the "Append Changes to Existing Text" does not work.   

Highlighted
Advocate I
Advocate I

Re: Appending all approval comments in same column

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:

jonathanmweaver_0-1595536083425.png

 

Then when you update the list item Status, include the Approval Comments field = strComments.

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (6,847)