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

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
Super User III
Super User III

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

 

Microsoft
Microsoft

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
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Microsoft Ignite

Microsoft Power Platform: 2021 Release Wave 1 Plan

Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (35,580)