Answered

Retrive answer form an approval module

(0) Share

Report

Posted on by PierreCA

364 Moderator

Hello!

How can I retrive the answers of the Approval module and put them in a Sharepoint List as an update.

I start a flow asking if a task is completed or now with the Approval module of Power Automate. That parts do well.
The responder may add a comment to its answer. And many sources explain correctly that part.

The second part is to collect the answers and put them in a Sharepoint List as an update of a row of data. How is it possible to do that?

Thanks!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Pstork1 69,560 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

The individual responses are returned as a collection after the approval is completed. You need to go through the collection and append whatever you want in the SharePoint list to a string variable using a loop. Once the loop exits you can update the SharePoint list using the string variable. If you want to update multiple columns you'll need one variable for each column.

Was this reply helpful? Yes No
PierreCA 364 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Power Automate is new to me.

Specifically, during the flow, which modules should be used to dissect this collection using a loop.

Was this reply helpful? Yes No
Verified answer

Pstork1 69,560 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

1) Initialize one or more string variables at the start of the flow

2) Send the Approval

3) After the approval Append the comments (or whatever else you want) to the string variable. That will place that action in an Apply to each loop that processes the Responses collection.

4) After the loop completes do your Update Item action to save the variable(s) to an item.

Was this reply helpful? Yes No