cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Yoshio
Advocate I
Advocate I

Approval workflow capturing comments from approvers email

I have spent many hours searching and reading posts and I'm not able to get what I want working.

 

I need an approval workflow that will capture the approvers' comments they enter in the approval request email they receive and save them with the SP item that was approved/rejected.  I have it now so that I at least can capture the names of the approvers but can't seem to find the right post that will get me what I need.

 

Thank you, anyone that can help me, and all who are reading this possible duplicative post!!

routing flow part 1.pngrouting flow part 2.pngrouting flow part 3.pngrouting flow response on sp.pngsubmitting approval with comments.png

1 ACCEPTED SOLUTION

Accepted Solutions
ScottShearer
Super User
Super User

@Yoshio 

My example below should help you out.

First, I initialize a string variable near the top of my Flow.

After the approval takes place, I loop through each of the comments and append them to a string variable along with the approvers name.  Finally, I reference the string variable when I update the SharePoint list item.

Let me know if this solves your problem.

Comments1.jpgComments2.jpgComments3.jpg

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

View solution in original post

13 REPLIES 13
ScottShearer
Super User
Super User

@Yoshio 

My example below should help you out.

First, I initialize a string variable near the top of my Flow.

After the approval takes place, I loop through each of the comments and append them to a string variable along with the approvers name.  Finally, I reference the string variable when I update the SharePoint list item.

Let me know if this solves your problem.

Comments1.jpgComments2.jpgComments3.jpg

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

View solution in original post

Pstork1
Dual Super User III
Dual Super User III

Instead of doing your Loop based on Approvers, do it based on Responses.  That is the collection that holds the responses coming back from the approval.  Look for the Responses Comments  and Responses Approver Name in the dynamic content inside the Loop.  Those are the fields hou want to record.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

I do not have "Responses" in my dynamic content.  This is the problem I keep running into.  I don't have all the aspects of the solutions that I see online.  So I am at a loss

Thank you.  I don't have the "check for outcome" available so am not sure how to proceed from that step.

Sorry to be rude...thank you for your advice and taking the time to help me.

@Yoshio 

I believe your issue is that you are using Create an Approval rather than Start and Wait for an Approval.  I suggest re-writing your Flow to use Start and Wait for an Approval unless you have a specific reason for using Create an Approval.

If you choose to use Create an Approval, insert a wait for an Approval action immediately after the Create Approval action.  After you do so (assuming that you configure it properly), you should see what you need in Dynamic properties.

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
Pstork1
Dual Super User III
Dual Super User III

Taking another look at your Flow, I think you may be trying to build it off a Template that uses an older Approval action that has been discontinued.  Replace the current Create and Approval action in your Flow with Start and Wait for an Approval (V2) that will have the responses objects in it.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

yes!  Thank you so much!  It's working now! 🙂

Thank you SO MUCH!  I got it to work!  I marked it as the solution too.

 

you are the best!

@ScottShearer  - I am thinking to use your solution in my flow. 

could you also tell me, do we have an command or logic to update only the comments column in a sharepoint list?

 

Best Regards,

Vj

Hi Scott, I have a question. I've set up an "everyone must approve" flow and it's going very well. I'm able to capture all comments once the flow completes, but the problem I'm facing is that comments don't populate until the entire flow has finished. I've tried configuring a run after scenario to include succeeds and times out, but do you happen to know if there's a way to get these comments to appear otherwise? Here's the tail end of my flow for your reference.
Apply to Each.PNGConditional Outcome.PNGUpdate Item.PNG

Pstork1
Dual Super User III
Dual Super User III

When using a single approval action with multiple approvers there is no way to get the comments from each approver until all approvals are complete. 



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

@ShannonRoot 

@Pstork1 is correct. 

You might consider using approvals assigned to just one approver in a loop and setting concurrency control to On in the loop.  Setting concurrency control to on will allow for all of the approvals to take place at once - the default is sequential.  That way you can grab the approval comments as action is taken on each approval.  This will require substantial changes to your Flow.

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (1,274)