Power Platform Community Forum Thread Details

Dynamic Approvers with multiple variables

I know it is possible to use a variable for a dynamic approver list from a sharepoint list. I would like to know is it possible to use multiple variables to get dynamic approvers from a sharepoint list.

the approval I am building is for a purchase request. so I need to select the appropriate approvers biased on the amount of the approval and the department. and if possible i would like to get this off of one SharePoint list.

It can probably be done, but I have not done this with Power Automate. If you want, I can describe how I do this with a Nintex workflow. We call the approval list in my company the Delegation of Authority (DOA). It is structured as follows:

Functional Area	Controller	Controller Threshold	Approve 1	Approver 1 Threshold	Approver 2	Approver 2 Threshold	Approver 3	Approver 3 Threshold	Approver 4	Approver 4 Threshold
IT	Name	1,000	Name	35,000	Name	50,000	Name	100,000	Name	200,000

To do this in Nintex requires the use of a state machine. I have not found something comparable in Power Automate, although I have see articles such as How to: State machines in Microsoft Flow | Power Automate Blog describing how to achieve this. It didn't work for me.

The functional area is a drop-down in the form and contains unique values. When the workflow runs it pulls the corresponding data for the selected functional area to perform the logic.

For example, if the request is under $1,000, no additional approvals are required except for the manager of the employee. For $1,000 to $34,999.99 it requires approval from the controller as well, and so on.

Quick Links

Leaderboard > Power Automate