Unanswered

Request approval (everyone must approve) to list all approvers in SharePoint List column cell and not just show the last approver

(0) Share

Report

Posted on by jamesfisher

Firstly, sorry for the long subject name!

I'm using the 'Request approval (everyone must approve) for a selected file' template to review documents and what I am trying to do is capture the approvers names in the SharePoint List cell but it currently just gives the last approvers name and not all approvers. I'm struggling to work out how best to do this

This is the standard template up to the condition

2021-05-18 11_47_19-Edit your flow _ Power Automate.png

And here is the apply to each. The column name is 'Document Reviewed By', which will currently display the last person to approve. This is where I want to show all those that have approved the document. So if the document was sent to 5 approvers, then all 5 names appear in the 'Document Reviewed By' cell

Appreciate any help as a newbie to this community

James

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

tom_riha 10,185 Most Valuable Professional on at

Like (1)

Report
Hello @jamesfisher ,

it updates always the last approver because the 'Update item' action is inside 'Apply to each'. 'Apply to each' means that it'll loop through all the approvers and repeat the 'Update item' for each of them, every time updating the currently processed approver (by the end it has the value of the last one = the last repeat of the loop).

I assume the 'Document Reviewed By' column is a text column (not a people picker)

To get all the approvers you'll need to store them in a variable.

Initialize a string variable at the beginning of the flow.

Inside the 'Apply to each 3' add 'Append to string variable' action, and store the approver name there

Move the 'Update item' action out of the 'Apply to each 2' and 'Apply to each', and use the variable to update the 'Document Reviewed By column.

Was this reply helpful? Yes No
jamesfisher 34 on at

Like (0)

Report

Thanks so much @tom_riha - this did the trick! 😁

Was this reply helpful? Yes No
neerajd 9 on at

Like (0)

Report

Hello,

I have used the Request approval (everyone must approve) workflow from power automate to initiate few approvals. I now want to go and look at list of approvers and edit the list. How can this be achieved? I tried to tap the 3-dot menu next to my file in the SharePoint library and go to More -> Workflow option but it does not show any running workflows.

Regards
Neeraj.

Was this reply helpful? Yes No