Budget Approval with Threshold Routing

Approval routing rules live in people's heads and get skipped under pressure. Encoding the threshold in the flow makes the policy the default path rather than a reminder.

A form or SharePoint item starts the flow. A Condition on the amount selects the approver — team lead below €500, management at or above — Start and wait for an approval collects the decision, and the outcome is written back to SharePoint and emailed to the requester.

1. 1

   Trigger: SharePoint 'When an item is created' on the BudgetRequests list (or a Forms submission that creates it).

2. 2

   Initialize a string variable 'Approver' at top level.

3. 3

   Add a Condition on the Amount column: if less than 500, set Approver to the team lead mailbox; otherwise set it to the management mailbox.

4. 4

   Start and wait for an approval addressed to the Approver variable, including amount, purpose and requester.

5. 5

   Update the SharePoint item with Outcome, ApproverName, ApprovalDate and any comments.

6. 6

   Email the requester with the decision, and post high-value approvals to the finance Teams channel.

7. 7

   Add a scheduled reminder companion flow for approvals pending more than 48 hours.

Paste this into Power Automate Copilot to scaffold the flow.

Create an automated flow triggered when an item is created in the SharePoint BudgetRequests list. Initialize an Approver variable, add a condition on the Amount field routing requests under 500 euro to the team lead and 500 or above to management, start and wait for an approval addressed to that approver, then update the SharePoint item with the outcome and email the requester the decision.

Captures are added as each step is published.

• Conditions and branching
• Approvals in Power Automate
• SharePoint Update item