cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jamesfisher
Frequent Visitor

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

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

2021_05_18_11_47_58_Edit_your_flow_Power_Automate.png

 

Appreciate any help as a newbie to this community

 

James

1 ACCEPTED SOLUTION

Accepted Solutions
tom_riha
Super User
Super User

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.


[ If I have answered your question, please Accept the post as a solution. ]
[ If you like my response, please give it a Thumbs Up. ]

[ I also blog about Power Automate solutions even for non-IT people. ]

View solution in original post

3 REPLIES 3
tom_riha
Super User
Super User

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.


[ If I have answered your question, please Accept the post as a solution. ]
[ If you like my response, please give it a Thumbs Up. ]

[ I also blog about Power Automate solutions even for non-IT people. ]

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

neerajd
New Member

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.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (5,496)