Power Automate Intermediate Lesson 3: Approvals Routed by Amount

Power Automate Intermediate Lesson 3: Approvals Routed by Amount 1

πŸ“Ž This article includes 2 downloadable practice files ↓

⏱ 1 min read

πŸ“˜ Power Automate Intermediate Course Β· Lesson 3 of 8

Advertisement
  1. Trigger: Microsoft Forms “When a new response is submitted” (or a scheduled List rows of Submitted claims).
  2. Condition: float(triggerBody()?['Amount']) is greater than 100000.
  3. Yes: Start and wait for an approval (Approve/Reject – First to respond), assigned to the finance head; Details = employee, amount, category.
  4. Condition on outputs('Start_and_wait_for_an_approval')?['body/outcome'] = Approve β†’ Update row Status = Approved, Approver = responder email; else Rejected.
  5. No: Update row Status = Auto-approved.
  6. Email the employee the outcome and the approver’s comments.

With the practice data, EC-102 (β‚Ή1,25,000) goes for approval; EC-101 and EC-103 are auto-approved.

πŸ’‘ Approvals appear in Teams (Approvals app), Outlook and the Power Automate mobile app. Approvers can respond from their phone.
⚠️ An approval waits up to 30 days, then the flow times out. Add a reminder (lesson 6) or set a timeout with escalation for long-pending approvals.

Practice

Build the flow and submit the three claims. Build it in your own Microsoft 365 account at make.powerautomate.com, test it with the practice file, and check the run history.

πŸ“Ž Practice files for this article

⬇ Download all 2 files (ZIP Β· 6 KB)

Free to use for learning. Files with macros (.bas) are plain text β€” import them with Alt+F11 β†’ File β†’ Import File, and always test on a copy.

Advertisement
✨ Ask AI about this article

Stuck on a step? Ask a question and the AI answers using this article.

Free Β· AI can be wrong