cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jovalles
Helper III
Helper III

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

Hello,

 

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

 

 

9 REPLIES 9
efialttes
Super User
Super User

Hi!

Did you already check this old post?

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

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!



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Yes but it does not work.

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!



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



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

 

Jovalles_0-1594400898827.png

 

flaviatakushi
Community Support
Community Support

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!

@Jovalles 

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!



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



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

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



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



@Jovalles 

Did you finally overcome your challenge?

Thanx!



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (1,192)