All Approver Response in a single Table

(0) Share

Report

Posted on by SK-14101306-0

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.

Categories:

Building flows

I have the same question (0)

All responses (1)

Answers (0)

Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report
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.

Was this reply helpful? Yes No