You’re offline. This is a read only version of the page.
Announcements
4
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.
Share
Report
All responses (
Answers (
