Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

MS FLOW to pick approver email id from a list

We have implemented an approval Flow in MS Sharepoint. In 'Approval Request action' email id's of approver are configured. However the approvers get changed very frequently so i always need to update email id in Flow. What i want is to create another list where i can configure approver email id's and those email's can be used in MS Flow. so i dont update FLOW every time but only update in list will be enough. Is there any way to achieve it?


Thanks in advance




You can add the following actions in the approval flow:

  • Add an initiate variable action
  • Add a get list items (SharePoint) action to get all the approvers in the list with approvers
  • Add an apply to each
  • In that apply to each for the list items add the approver email to the variable you created before
  • Add the variable as the approver

Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!

Thanks for it. However is there anyway to avoid 'Apply to Each' loop? The issue i have 8 differnt approvers for whom approval request is sent. If we apply to each then it waits untill every approver takes some action. Then only it goes for next step. In our situation, it is not mandatory that all 8 approvers must take action. Any 2-4 approvers can action. 

Or Let's think other way. In Approver List i have 8 approver names with differnt roles.

I called Get Items action to get Approver list data. Then Initatilize variable configured to define variable name as Approver. So is there any way i can set Approver value for a specific approver name in list? e.g. When i call 'Set variable' value, i can filter a specific approver name from list and set it to Approver variable? So it does not make mandatory to call for 'Apply to Each' loop.

Hi @mbhushan,


What is your scenario exactly? Do you have different approvers for different departments? In that case you could use OData filters to filter the right approver in the get items action. (check out this excellent blog for more info about that)


- Daniel

Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!

Hi Daniel,

You are right. I have 8 departments where this approval request is sent. Tried to provide an view of MS Flow snap. If i add Apply to each in every approval then flow becomes very lengthy. I am looking for a simple solution where i can pickup email id from list where i sent approval request to these 8 approvers. 



Helpful resources

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group


Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (53,771)