cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Julien2
Super User
Super User

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
jonathanmweaver
Advocate I
Advocate I

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

MultiLine Append.png

View solution in original post

4 REPLIES 4
jonathanmweaver
Advocate I
Advocate I

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

MultiLine Append.png

v-litu-msft
Community Support
Community Support

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

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

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
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,122)