I need to store string value in sharepoint list and update it after every approval

(0) Share

Report

Posted on by Biskopt

102

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:

concat(variables('comment'),'\n', items('For_each_2')?['comments']).

How am I suppose to make it work?

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

Sort by

v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
Verified answer

David- 1,254 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Biskopt 102 on at

Like (0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No