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:
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!
Thank you!
Solved! Go to Solution.
Can you set the Comments column to Append Changes to Existing Text?
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:
Then when you update the list item Status, include the Approval Comments field = strComments.
User | Count |
---|---|
94 | |
39 | |
24 | |
21 | |
16 |
User | Count |
---|---|
128 | |
49 | |
48 | |
31 | |
24 |