cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DD7
New Member

Capturing all comments in multi level approval flow using Excel

Hello,

 

I have a flow with two levels of approval. On the first level of approval, it's set to everyone must approve. Once everyone approves, it sends the request to the second level approver. Once the second level approver approves or rejects, it updates comment and approval status columns. There are comment and approval status columns for both levels of approval.

 

I want to capture the comments of all approvers on the first level in the Excel comment column and I want to include these comments in the message that goes to the second level approver. With the everyone must approve option, only the most recent response is captured. From what I've seen online, most do this flow with a sharepoint list, however, I'm recording my responses in an Excel file and I was unsure of what connector would be best. flowhelp1.pngflowhelp2.PNG

1 REPLY 1
manuelstgomes
Community Champion
Community Champion

HI @DD7 

 

Do you need to store the comments permanently or just send them to the next level of approval? If you don't need to keep them, you can create an array variable and append each comment. Then, in the next step, you can use the "join" function to generate a string from those comments and send it in the approval process.

 

Cheers

Manuel

 

------------------------------------------------------------------

If I have answered your question, please mark it as "Accept as Solution." It will help other members finding the solution faster. If you like my response, please give it a Thumbs Up. ?

Otherwise, reply to it, and the community will do its best to help you.

 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

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

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (3,119)