cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Yoshio
Helper I
Helper 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 III
Super User III

@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

10 REPLIES 10
ScottShearer
Super User III
Super User III

@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

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (17,555)