End-to-end flow of the Monday morning digest. Everything below runs on a schedule — no human intervention per course per week.
1. Trigger (Mon 7:00 AM PT)
Power Automate recurrence — runs once per week.
2. Fetch tasks from Asana
GET /projects/{id}/tasks?opt_fields=name,assignee,due_on,completed
One call per course (5 courses = 5 calls, well under rate limit).
3. Filter + group
Keep: not completed AND (overdue ≤ 60 days OR due ≤ 7 days).
Group by assignee, sort by due date.
4. Build Adaptive Card
Template with sections: overdue alert → per-person task list → open-in-asana button.
5. POST to Teams webhook
POST https://uagc.webhook.office.com/webhookb2/...
One URL per course channel (set up once by channel owner).
6. Card renders in channel
Everyone in the course channel sees it. No Asana login required.