Skip to main content

Notifications

Community site session details

Community site session details

Session Id : 2fJevQGlVkE8S5OWBB5IoR
Power Automate - Building Flows
Answered

Record Multiple Approval Responses

Like (0) ShareShare
ReportReport
Posted on 21 Feb 2024 13:46:40 by 11

I am new to flows, so am getting a bit turned around!

 

I have an approval flow that is manually triggered on a project summary document. This goes out to a large list of team leads, who indicate if their team needs to be involved in the project. So far, this works fine.

 

However, I would like to record the responses somewhere where colleagues with no Automate knowledge can easily see them (as this approval process will be used by a number of people).

 

20 people may approve this, and 10 may not.

 

We need to see, with ease, who has responded and what their response was. That way we know who needs to be kept informed by their own choice, not just who we think should be in the loop! We can also chase non-responders.

 

Is this something that can be done, and what do you think is the best and most efficient way to handle it?

 

Thank you!

  • KEH Profile Picture
    11 on 27 Feb 2024 at 12:22:12
    Re: Record Multiple Approval Responses
    Brill, thanks a ton!
  • Verified answer
    Pstork1 Profile Picture
    66,162 Most Valuable Professional on 22 Feb 2024 at 18:06:43
    Re: Record Multiple Approval Responses

    Sorry, my previous response was actually meant for another post, but got posted in the wrong place.  To record responses mentioned earlier do the following

    In SharePoint create a multiline text field. It can store up to about 64000 characters.

    1) Create a string variable

    2) Use an Apply to each loop to process the responses when they are returned by the approval

    3) in the Loop append the information you want from the current response to the string variable you created. Make sure to add a carriage return at the end of the dynamic content. It will look like you are appending a line of content and a blank line, but that's just the carriage return.

    4) After exiting the loop update the SharePoint Multiline text field with the variable.

  • KEH Profile Picture
    11 on 22 Feb 2024 at 17:12:41
    Re: Record Multiple Approval Responses

    Great, thanks for the response! It's definitely writing properly now. If I wanted to summarise all the responses, such as name and response, what would be the best way to do this?

     

    E.g.

    Joe Bloggs - Yes

    Jo Bloggson - No

    Joey Blogfort - Yes

     

    It's worth noting that the list of respondents is large!

     

    Thanks a ton for your help so far. 🙂

  • Pstork1 Profile Picture
    66,162 Most Valuable Professional on 21 Feb 2024 at 19:42:45
    Re: Record Multiple Approval Responses

    Are you approving a file or a list item? Your first screenshot was for a list item, but your description says its a document. If its a file the flow would look more like this

    image.png

    The yes side of the condition would then look like this

    image.png

    1) Get the file metadata to retrieve the current ETag

    2) Use that ETag to set the content approval status

    3) Then update other file properties normally.

    You would have something similar on the No side to set the approval rejection.

  • KEH Profile Picture
    11 on 21 Feb 2024 at 15:33:32
    Re: Record Multiple Approval Responses

    Would I follow something like this:

    https://powerusers.microsoft.com/t5/Building-Flows/How-to-see-the-document-approval-progress-in-SharePoint-library/td-p/682048?

     

    I've followed this, but the status hasn't updated.

    Any ideas where I've gone wrong?

     

    KEH_2-1708529599075.png

     

    KEH_0-1708529522021.png

     

    KEH_1-1708529576134.png

     

    Thank you!

  • Pstork1 Profile Picture
    66,162 Most Valuable Professional on 21 Feb 2024 at 13:49:56
    Re: Record Multiple Approval Responses

    I normally do that by adding a multiline field to the document library where the document is stored. Then when you do the approval you collect the responses and who they are from by appending them to a string variable. That can then be used at the end of the approval to update the field in the document library for the document. So anyone viewing the document in SharePoint can see all the approvals and comments.

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Building Flows

#1
stampcoin Profile Picture

stampcoin 87

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 70 Super User 2025 Season 1

#3
David_MA Profile Picture

David_MA 48 Super User 2025 Season 1

Overall leaderboard