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 - Building Flows / How To Capture Multipl...
Power Automate - Building Flows
Unanswered

How To Capture Multiple Approvals And Separate Them Into Specific SharePoint Columns

(0) ShareShare
ReportReport
Posted on by CP153319

I am currently creating an Approval Flow which has 13 different approvers (all must approve).

 

Each of these approvers has a specific job title (Manager A, Manager B, Manager C and so on...). 

 

I have one column set-up in SharePoint to capture the response of each approver named with their job title (13 columns total named "Manager A Response", "Manager B Response", "Manager C Response" and so on...)

 

What I need to do is capture all the approval responses (Approve/Reject) and comments and then write them back to the SharePoint list into their proper column. In other words, the approval of "Manager A" has to go into the "Manager A" column in SharePoint. 

 

I know that I could take 4 hours and just grind-out 13 separate approval branches but I'm wondering if there is an easy way to do this. What I'd like to do is put all 13 approver Email into one approval and then sort them into their proper SharePoint column after they complete their approvals. 

 

Any ideas?

 

Thank you. 

  • farihidayat18 Profile Picture
    farihidayat18 2 on at
    Re: How To Capture Multiple Approvals And Separate Them Into Specific SharePoint Columns

    hello, could we continue this inquiry? @CP153319  could you share the another "4 hours" way to do that? cause i new on this field and has same case ( although not until 13 approver)

  • CP153319 Profile Picture
    CP153319 on at
    Re: How To Capture Multiple Approvals And Separate Them Into Specific SharePoint Columns

    We do not use the CDS at my company - License are too expensive (so "they" say). 

     

    Any other ideas are appreciated. 

  • Ed Gonzales Profile Picture
    Ed Gonzales 4,531 Most Valuable Professional on at
    Re: How To Capture Multiple Approvals And Separate Them Into Specific SharePoint Columns

    @CP153319 

    Hey there.  There are probably a ton of ways to approach this, but the first one that comes to my mind is a separate flow that has a CDS trigger.

    All of your approvals are stored in the Common Data Service and tracked with a few entities:  Approvals, Approval Requests, and Approval Responses.

    If your intent is to capture all of the responses, then I would build a flow with a CDS Trigger "When a record is created" and look at the Approval Responses entity.  That will have the beginnings of the information you need (everything stored will be unique ID's rather than display names, but you can use other actions to pretty that up before writing to your SP List).

     

    Is the intent of the SP list to report on approvals?  Qty, duration, etc?  If so, you might be able to just report directly off of those CDS entities.  Depends on the intent of the flow, right?

     

    Either way, keep us posted.

    -Ed

     

     

    If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

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

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans