Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

All Approver Response in a single Table

(0) ShareShare
ReportReport
Posted on by 2
Hi Power Automate community,

I want to know something Related to Power Automate flow,

I have steps to get approval You Can see in this Picture after L1 Approval I Update Share Point then Goes to L2 Approval so on so and End at L4 Approval if all approver Approved then I want to Append All the approver Response (approver Name, Date of Approved, Response, and Comment) Into A table and Send to Procurement Team to Purchase with Approver Details.
  • Expiscornovus Profile Picture
    31,891 Most Valuable Professional on at
    All Approver Response in a single Table
    All approval details are stored in Dataverse as well (in a table actually 😁). So, probably the easiest approach would be to use a List rows action and filter on the approval id columns. 
     
    Below is an example
     
    Use the below for the filter rows field
     
    (msdyn_flow_approvalid eq '@{outputs('Start_and_wait_for_an_approval_-_L1')?['body/name']}') or (msdyn_flow_approvalid eq '@{outputs('Start_and_wait_for_an_approval_-_L2')?['body/name']}')
     
    In the select columns you can specify the fields you want to retrieve
     
    After that you can use a Create HTML table action to put the outputs in a table.
     

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

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 > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 566 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 516 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 492