I have a problem with gathering comments into my SharePoint list.
So I have field "comments" into my SharePoint list which stores "Responses Comments" from approve action. When the second level of approve start and also has some comments it just replace the first ones. I tried to fix it with "concat()" function but it seems to not work properly. I have created variable string "comment" which value is my "comment string". Then after "Update item" action I try to use concat function to the field I want to store my strings:
Problem solved. I had some mistakes with my variables and setting them. Append seems just works fine. Now I will transfer my solution to the dynamic verision. Static (1 approver per level) works fine.
Thanks for help!
Is your comments field multiple lines of text? If so, initialize a string variable and populate it with your first-level approval comments. Then when you recieve the comments from the second-level approval, use the Append to string variable action to add these comments to the first-level comments. Use the variable to update your list.
Hi @Biskopt ,
What is type of comments column? If it is text type, I'm afraid text type column doesn't support '\n'.
Please try use decodeUriComponent('%0A').
concat(variables('comment'),decodeUriComponent('%0A'), items('For_each_2')?['comments'])
If above method doesn't work, please show some screenshots about your flow and testing outputs.
Best regards,
Rimmon