Answered

Extract data from Approval Process

(0) Share

Report

Posted on by CU29071243-0

I have created an approval flow which sends a document out to multiple reviewers. I have the flow set up so that once all reviewers "Approve" or "See Comments", file properties are updated and an external exel file captures the data.

My issue is that reviews may occur over multiple days and if the first responder has a comment, I won't see it until the last reviewer responds. I understand why this occurring, but am trying to see how to extract the comments as they come in. What is frustrating is that if I look at the Approval in Teams, I can see all comments as they occur even when there are pending responses.

Is there any way to extract these comments as they come in? If not can I pull them from Teams?

Thanks!!

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @JT-1964 ,

Actually, the result of the approval stores in the dataverse table 'Approval Responses'.

You could get the comments from this table.

Best Regards,

Wearsky

Was this reply helpful? Yes No
CU29071243-0 76 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the response. So seeing as I have neither Admin nor Premium access, this won't work.
So I am moving on to another option - splitting out the approval requests. Let's say I am sending a file from my doc library to 10 reviewers to Approve. Is there a way to set up a flow that will take those 10 names and simultaneously launch an approval request 10 times? This way each reviewer can provide an answer and is not getting reminders because others have not yet responded. Alternately, I could manually send the same file ten times but this seems unnecessarily tedious. Suggestions?

Was this reply helpful? Yes No
Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @JT-1964 ,

You can do that. You could use 'Apply to each' action to Execute the loop 10 times.

The flow will send one approval for every single reviewer.

Best Regards,

Wearsky

Was this reply helpful? Yes No