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

[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

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

[tom_riha · Accepted solution]

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.

1. Initialize a string variable at the beginning of the flow.
2. Inside the 'Apply to each 3' add 'Append to string variable' action, and store the approver name there
3. 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.

[jamesfisher]

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

[neerajd]

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.