I want to know if it is possible send an email with all the comments from an approval of 4 people.
Did you already check this old post?
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
Can you share a screenshot from you current flow design?
The more context info we got, the faster you will get a useful suggestion
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
Now, 'Apply to each' expanded:
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
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
Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Attend in person or online, there are incredible conferences and events happening all throughout the month of September.