Assemble the final renewal pipeline

Theo has all the pieces. Time to assemble Drumlin's renewal pipeline end-to-end and hand it to Naomi for production.

The pipeline: Recurrence trigger (with the weekday trigger condition) → Get items from the SharePoint Contracts list for upcoming renewals → Apply to Each containing Get file metadata using path (from SharePoint), Get manager (V2) (resolve partner email), Condition on contract value, Switch on status, Approval with custom responses on the high-value branch, Send an email with a parallel run-after Failed branch, and Update a row in Excel to write back the audit trail and renewal outcome.

Build, test, and verify. Then turn the flow on.