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

Approvers From Another Sharepoint List

Hello Everyone,

 

I have a flow with many approvers and the approver changes based on the department and amount of the cost to be approved. For example if I choose IT and put 10k GBP then it goes to certain approvers. If it is with a different department and in different amount then approvers change. For that I created a separate Sharepoint list where I put approvers' titles, their names and emails. For instance Brand Deployment Manager-Name of the Brand Deployment Manager- Email of the Brand Deployment Manager. (see below)

What I want to do is, once I set approval in my flow, in "Assingned to" Section, I want to be able to put Brand Deployment Manager from that other Sharepoint list so it sends to the Brand Deployment Manager's email. So when our brand manager changes in the future, we would just change the name from that other sharepoint list instead of changing one by one the email address from every approval that person is involved. 

 

What I've done is as per below:

 

image2.png

 

image1.png

Image3.PNG

Now I don't know how to proceed at this point. Should I put a formulation here that let's say if value in title column of this other sharepoint list is equal to Brand Manager, it brings the email of this person? Is this possible?

 

Thanks so much in advance. 

 

BR

1 REPLY 1
tom_riha
Super User
Super User

Hello @ipek22 ,

you should use 'Get items' with a Filter Query to always find the right approver. Before each approval task add 'Get items' and find the right approver. Then you can assign the approval task to him, as described in this blog post.



[ 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. ]

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (2,065)