Complete Student Enrollment & Documentation Flow for Educational Institutes
Microsoft Form submission triggers the flow, collecting 49 field values instantly (~2 sec).
Composition of Student Full Name, ID Generation (USID), and Date Formatting.
Creates SharePoint Master Folder + 5 Subfolders (Enrolment, Job Packet, One Plan, Risk Assessment, SEND).
Parallel Child Flows populate 62-field "One Plan" & 107-field "Risk Assessment" templates via AI.
Deep dive into the flow logic and data structure
| Step ID | Action | Description |
|---|---|---|
| 1 | Form Trigger | Microsoft Form triggers flow on new referral submission. |
| 2 | Get Response | Retrieves all 49 form field values. |
| 3-5 | Compose Logic | Generates "StudentFullName", "TodayDate", and Unique "USID" (EDU-2026-XXXX). |
Ensures consistent file organization and compliance for every student.
| Phase | Action | Details |
|---|---|---|
| AI Gen | HTTP Child Flows | Triggers custom AI logic to fill 62 fields (One Plan) and 107 fields (Risk Assessment). |
| Wait | Delay Control | Implements smart 90s delay to ensure AI processing completion. |
| Notify | Email (V2) | Sends HTML email to SENCO with generated attachments (.docx). |
| Log | SharePoint List | Creates audit trail item for complete traceability. |