Skip to main content

Notifications

Power Automate - General Discussion
Answered

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

(0) ShareShare
ReportReport
Posted on by 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?
  • Biskopt Profile Picture
    Biskopt 102 on at
    Re: I need to store string value in sharepoint list and update it after every approval

    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!

  • Verified answer
    David- Profile Picture
    David- 1,254 on at
    Re: I need to store string value in sharepoint list and update it after every approval

    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.

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

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,343

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard