Power Automate based on Approval Matrix

(0) Share

Report

Posted on by Olijk

155

Hello,

I am in the process of trying to build out robust flow with multiple approvals based on dollar amount. Is this possible? The steps would be

requestor would submit a Sharepoint form, if the form is over $1k, it would need one approver, if the form is over $10k, it would need 2 approvals and so forth. Notifications would need to be sent back to the submitter once the flow is completed. Is this possible?

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (0)

Sort by

Pstork1 69,417 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Yes, that's very possible. The biggest question is where do you get the email addresses of the approvers from? Are they hard coded based on the amount? If so its just a series of conditions to select the approval process.

Was this reply helpful? Yes No
Olijk 155 on at

Like (0)

Report
Copy link

Link copied!

Thank you for the message! Yes, the email addresses will be hardcoded based on the amount. Would it be a series of if/then conditions on the approval flow? For example, if 2 approvers are needed for a $10k, then those email addresses would be hard coded in and the loop will be closed, meanin the flow would stop or I could start another flow?

Was this reply helpful? Yes No
Pstork1 69,417 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

How it would be designed depends on how many different levels you need to test for. If its 7 or less than its just 7 conditions nested inside each other. for example

1) Is the total greater than 100k

- Yes, send approval to three approvers

- No, is the total greater than 10 K

- Yes, send to two approvers

- No, is the total greater than.... and so on

Was this reply helpful? Yes No
Olijk 155 on at

Like (0)

Report
Copy link

Link copied!

Hello,
Thank you for the message! It would be 8 conditions, at different dollar value thresholds. Some of the thresholds has multiple approvers. Would I have to create from scratch with the when an item is created or modified trigger?

Was this reply helpful? Yes No
Olijk 155 on at

Like (0)

Report
Copy link

Link copied!

Hello,
I was following up on the request from January 12, in relation to your question...It would be 8 conditions, at different dollar value thresholds. Some of the thresholds has multiple approvers. Would I have to create from scratch with the When an Ttem is created or modified trigger?

Was this reply helpful? Yes No
Pstork1 69,417 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

If all the dollar levels are mutually exclusive you can just do 8 conditions in a row without nesting them. In the yes of each condition set the email address(s) of the approvers. Then send out the approval after all 8 conditions are run.

Was this reply helpful? Yes No
Olijk 155 on at

Like (0)

Report
Copy link

Link copied!

Hello,

Thank you! Is it possible for you to show an automate example of the Automate approval conditions?

Was this reply helpful? Yes No