Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
Check out the New Agent Creator Community
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Using Connectors / Approval type: respons...
Power Automate - Using Connectors
Unanswered

Approval type: responses to excel

(0) ShareShare
ReportReport
Posted on by svajunekl 5

Hello,

 

I need help in my flow using Approval connector. I created a flow: New document in SharePoint list --> Start and wait for approval (or create an approval?) --> Add row into a table.

The point is: I need that all the responses will get into my table, but not just when all approvers have approved (the process ended) but one by one not waiting all to approve. The list contains of documents to be sent to like 55 employees to get acquainted, and this information should be stored in excel table.

I now have working flow, but the problem is that I have to wait for all to approve.

Which approval type should I pick? Or maybe do the extension to my flow? Please help me, I'm new with power automate 🙂

 

Here is my flow (I've done test with two users):

svajunekl_0-1681903989914.png

 

  • svajunekl Profile Picture
    svajunekl 5 on at
    Re: Approval type: responses to excel

    Thank you, Scott. I'll think about that. 

    Some of us are using forms, but without automated flows. 

    I just want to automate the process as it is possible. Because there many documents owners who run this process, and many documents.

  • ScottShearer Profile Picture
    ScottShearer 25,228 Most Valuable Professional on at
    Re: Approval type: responses to excel

    @svajunekl 

    I suggest a different approach.  How about this:

    • Use Forms to collect the data from your users
    • Create a SharePoint list or Excel spreadsheet with a row for each user (preferably email address)
      • You can always export the SharePoint list to Excel
      • I don't suggest using Excel for this... 
    • Send an email out to all employees with a link to the Form
    • Create a Flow that updates the list or spreadsheet when a user completes the Form
    • Create a Flow that runs daily
      • Send reminder emails to each user who has not submitted the Form

    Will this work for you?

     

  • svajunekl Profile Picture
    svajunekl 5 on at
    Re: Approval type: responses to excel

    The example:

    I updated the Information Security Policy, and need that all the employees at the company would get notified about it, write a comment "I have read, understood, and will follow". I need this information with metadata (document title, user name, request date, respond date, comment) to be saved in excel file once they did it. 

  • ScottShearer Profile Picture
    ScottShearer 25,228 Most Valuable Professional on at
    Re: Approval type: responses to excel

    @svajunekl 

    Can you explain a little more about the business process behind the Flow?  It is possible that using the approval engine is not appropriate.

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
Check out the New Agent Creator Community

Quick Links

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Last month Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans