web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How to send an email w...
Power Automate
Unanswered

How to send an email with all the comment from an approval?

(0) ShareShare
ReportReport
Posted on by

Hello,

 

I want to know if it is possible send an email with all the comments from an approval of 4 people.

 

 

Categories:
I have the same question (0)
  • efialttes Profile Picture
    14,756 on at

    Hi!

    Did you already check this old post?

    https://powerusers.microsoft.com/t5/Building-Flows/How-to-capture-multiple-approver-s-comments/m-p/105557

    The connector has changed slightly since then, but let's hope it can point to in the right direction

    Please let us know your progress

    Thanx!

  • Community Power Platform Member Profile Picture
    on at

    Yes but it does not work.

  • efialttes Profile Picture
    14,756 on at

    Hi again!

    Can you share a screenshot from you current flow design?

    The more context info we got, the faster you will get a useful suggestion

    Thanx!

  • Community Power Platform Member Profile Picture
    on at

    Of course, by the way i need the coments for both users in the approval:

     

    Jovalles_0-1594400898827.png

     

  • flavia.takushi Profile Picture
    on at
    Hi Jovalles, The link that Efialttes shared is great. Just complementing, you have to add 'Apply to each' for 'Responses' parameter. Then you can add an action to insert into a SharePoint list for example, just to store responses. After this you can use Sharepoint 'Get item' action and add the Comment parameter into the email body. There are many ways to do this and this is only an example. Hope this helps!
  • efialttes Profile Picture
    14,756 on at

    @Anonymous 

    I did a simple test flow, and it's working fine. Please note:

    -each approver's email addresses must be defined in your Tenant Azure AD.

    -by using this approach, when dealing with multiple approvers you need to wait for everybody to answer. THere is another approach to read responses before everybody answered

    -comments are optional. THis means when iterating through the 'Responses' array, one or more responses may not include this attribute

    Here you are my test flow, I just added one responder, but the concept is exectly the same as if you add more than one

    Flow_MulttipleResponsesApproval.png

     

    Now, 'Apply to each' expanded:

    Flow_MulttipleResponsesApproval_2.png

     

    In my test flow I took some design decisions on my own:

     

    -I store responses in an array variable modeling them as objects, so I store comemnts, responder, answer and date time. THen I transform this array into an HTML table.You can add this table to your emai notification body, just remember to add a 'Send an email' action block. But, if you prefer you can add only responses to your array variable, or model your array elements as strings instead of objects, and then use join() WDL expression to combine all elements from your string into a single text.

     

    -I do not to read responses if the result is 'REjected', but you can read responses and send a notification no matter the result is.

    THe possibilities are almost endless

     

    Finally, I also verified it's working fine both if responder add Comments but also if he/she decides not to add them. As I mentioned before, I am using a single approver, but it works the same for N approvers

    ¡Ánimo!

  • Community Power Platform Member Profile Picture
    on at

    I had to create separate approvals because I have to save each comment in a different field in the same sharepoint record

  • efialttes Profile Picture
    14,756 on at

    Hi again!

    With the approach I shared, you can upload each comment in a different SP column. Please note I am storing then as independent elements of an array variable

    The point is... do you need to store the comments once everybody approve? Or, you need to upload comments to Sharepoint as answers are received, even though not everybody approved yet

     

    Hope this helps

  • efialttes Profile Picture
    14,756 on at

    @Anonymous 

    Did you finally overcome your challenge?

    Thanx!

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard