Skip to main content

Notifications

Power Automate - Building Flows
Answered

Update / Append multi-line text SharePoint column based on number of If-Condition results

(0) ShareShare
ReportReport
Posted on by 300
Hi! I have a flow that queries a list on how many users / approvers are away on vacation when an approval is requested.
And if an approver is away, the flow replaces the approver with their designated back-up and writes lines on my 'Approval History' multi-line text column with below text.
 
 
It is working well if only one (1) approver is away. If more than one (1), it only captures the last preset text to record the delegation action. How do I retain previous text and append?
 
Screenshots are much appreciated! Thank you for your time and support!
  • jaanihsm Profile Picture
    jaanihsm 300 on at
    Update / Append multi-line text SharePoint column based on number of If-Condition results
    Hi @SudeepGhatakNZ. Thank you for being so accommodating. I think I got the logic of the loop you showed in the screenshots and I have it working now. I also added a Compose action like your first suggested answer. Thank you again for all your help. I appreciate it very much! You're awesome!
  • SudeepGhatakNZ Profile Picture
    SudeepGhatakNZ 14,231 on at
    Update / Append multi-line text SharePoint column based on number of If-Condition results
    Would you have time for teams call? It might be easier.
    The logic remains the same. Instead of looping through the Approval Comments, you need to loop through the Approver array in your case.
     
  • jaanihsm Profile Picture
    jaanihsm 300 on at
    Update / Append multi-line text SharePoint column based on number of If-Condition results
    Hi @SudeepGhatakNZ! Thank you for the detailed suggestion, I learned a lot from your example! However, sorry I forgot to mention, so my flow does not include the approval side of things. It is only for checking users who are away. Below is the full flow. I hope you can recommend another way. Thank you so much for your knowledge-sharing!
     
     
     
  • Suggested answer
    SudeepGhatakNZ Profile Picture
    SudeepGhatakNZ 14,231 on at
    Update / Append multi-line text SharePoint column based on number of If-Condition results
    SharePoint list
     
     
    Flow
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
  • jaanihsm Profile Picture
    jaanihsm 300 on at
    Update / Append multi-line text SharePoint column based on number of If-Condition results
    Hi @SudeepGhatakNZ. Unfortunately, for this solution, I can only have lists and flows. Any other recommendations you may have? Can Send HTTP request be of use here? Thanks again!
  • Suggested answer
    SudeepGhatakNZ Profile Picture
    SudeepGhatakNZ 14,231 on at
    Update / Append multi-line text SharePoint column based on number of If-Condition results
    Hi @jaanihsm, it looks like it might not be doable with JSON formatting
     
    Could you try Power Apps instead?
     
  • jaanihsm Profile Picture
    jaanihsm 300 on at
    Update / Append multi-line text SharePoint column based on number of If-Condition results
    Hi @SudeepGhatakNZ! It looks like below without JSON formatting...
     
    And then with...
     
     
     
  • SudeepGhatakNZ Profile Picture
    SudeepGhatakNZ 14,231 on at
    Update / Append multi-line text SharePoint column based on number of If-Condition results
    It could be due to JSON formatting.
    How does it look before you apply the JSON formatting?
     
  • jaanihsm Profile Picture
    jaanihsm 300 on at
    Update / Append multi-line text SharePoint column based on number of If-Condition results
    Thanks @SudeepGhatakNZ, was excited to try this but after looking at my approval history column, I see below instead. Is it because I am using some JSON formatting? Really appreciate your time and expertise! Thank you!
     
  • Suggested answer
    SudeepGhatakNZ Profile Picture
    SudeepGhatakNZ 14,231 on at
    Update / Append multi-line text SharePoint column based on number of If-Condition results
    I can build a sample for you if needed.

    Before we proceed, have you considered enabling the Append Changes to Existing Text option in SharePoint?

    SharePoint list apps offer an append feature for columns of the type Multiple lines of text. When you enable this feature, changes are shown as a thread in the field. The earlier text remains uneditable, while new text is added above the previous content. This feature is especially useful for discussions and issue tracking, as it provides a clear history of updates.

    By enabling this feature, you wouldn't need to worry about implementing the append logic manually.

     

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,567

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard