Answered

Approval Information

(2) Share

Report

Posted on by BF-02121120-0

How can I find out the details of the user who approved or rejected an approval? There doesn't seem to be a column in the "Approval" table which holds this information. I have tried using the "Wait for an approval" activity but since I am not using one flow to create and check the approval I cannot get that activity to work.

Any help appreciated.

Categories:

Building flows

Using flows

General topics

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Suggested answer

11manish 3,333 on at

Like
a
(0)

Report
Copy link

Link copied!
The Dataverse Approval table does not directly store the responder (approver/rejector) details in a simple column.

The actual response data (who approved/rejected) is stored in:

Approval Responses (child records)

Not in the main Approval record

To find who approved or rejected:

Query the “Approval Responses” table in Dataverse and filter by the Approval ID — this is where the responder (approver/rejector) details are stored.

Was this reply helpful? Yes No
BF-02121120-0 50 on at

Like
a
(0)

Report
Copy link

Link copied!

@11manish this helped to isolate the approval but there is no column called "Approver" or "Approved By" or similar. Which field should I use as the value for who approved? There is "Modified", is that suitable?

Was this reply helpful? Yes No
Verified answer

11manish 3,333 on at

Like
a
(1)

Report
Copy link

Link copied!
The correct field to identify who approved/rejected is the Owner (OwnerId) in the Approval Responses table.

Do not use Modified—it’s not reliable for identifying the approver.

Was this reply helpful? Yes No
BF-02121120-0 50 on at

Like
a
(1)

Report
Copy link

Link copied!

Thanks @11manish I used the Owner field to get the id and did a lookup to the Users table to get the email address I required.

Was this reply helpful? Yes No