Build Real #1 — Copilot Studio + Power Automate + AI Builder: What They Are and How They Connect

The Complete Picture — Before Reading Anything Else

Here is the full system you are building. Every concept in this post maps to one of these boxes.

┌─────────────────────────────────────────────────────────────────────┐
│                    EXAM AUTO-EVALUATOR PIPELINE                     │
└─────────────────────────────────────────────────────────────────────┘

STEP 1          STEP 2              STEP 3
Student         Copilot Studio      Power Automate
types message   agent responds,     Flow starts,
in chat    →    asks for file   →   saves file to
                                    OneDrive

                                         ↓

STEP 6          STEP 5              STEP 4
Student         If approved →       AI Builder reads
notified        email sent      ←   each question,
✅              to student          writes answers,
                                    saves to SharePoint

                    ↓
              STEP 4b
              Approval email
              sent to Raushan
              for review

─────────────────────────────────────────────────────────────────────

DATA THAT MOVES AT EACH STEP:

Step 1→2:  Student types "evaluate exam" in chat
Step 2→3:  Student uploads exam-questions.xlsx
           Copilot Studio saves file to OneDrive automatically
           Then triggers the Power Automate flow (no file passed — path passed)
Step 3→4:  Power Automate reads rows from Excel in OneDrive
           Sends each question to AI Builder
           AI Builder returns answer for each question
Step 4→5:  All Q+A pairs written to new Excel in SharePoint
           SharePoint link generated
           Approval email sent with the link
Step 5→6:  Reviewer clicks Approve in email
           Power Automate detects approval
           Sends confirmation to student
    

Tool 2 — Microsoft Power Automate

What problem existed before it

Connecting services — reading a file, sending an email, saving to SharePoint, waiting for approval — required custom code or expensive integration tools. Power Automate lets anyone build these workflows visually.

What it is — in one sentence

Power Automate is the back office that processes everything after Copilot Studio hands off. It reads the Excel file, calls AI Builder for each question, writes the answers to SharePoint, and sends the approval email.

The specific flow type we use — Agent Flow

Power Automate has three flow types. We use Agent Flow.

An Agent Flow has two special nodes pre-built when you create it: "When an agent calls the flow" at the top and "Respond to the agent" at the bottom. You build your steps between them. Never delete these two nodes.

How the Three Tools Connect — Data Flow Diagram

┌──────────────────────────────────────────────────────────────────┐
│                    DATA FLOW BETWEEN TOOLS                       │
└──────────────────────────────────────────────────────────────────┘

COPILOT STUDIO                    What data moves
──────────────────────────────────────────────────
Student chats → agent receives    text message
Agent asks for file               text response
Student uploads Excel             Excel file (binary)
Copilot Studio saves to OneDrive  file saved to /ExamProcessing/
Copilot Studio calls flow    →→→  passes: OneDrive file path (text)
                                           + timestamp (text)

POWER AUTOMATE (Agent Flow)       What data moves
──────────────────────────────────────────────────
Receives file path from Copilot   text: "/ExamProcessing/exam.xlsx"
Reads Excel rows (List rows)      array: [{Question: "..."}, ...]
Loop: for each row           →→→  sends: one question (text) to AI Builder

AI BUILDER (Run a prompt)         What data moves
──────────────────────────────────────────────────
Receives question text            text: "What is CALCULATE in DAX?"
Returns answer text          ←←←  text: "CALCULATE modifies filter context..."

POWER AUTOMATE (continues)        What data moves
──────────────────────────────────────────────────
Writes Q+A to output Excel        rows added to new Excel file
Saves Excel to SharePoint         file saved, URL retrieved
Sends approval email              email with SharePoint link
Waits for approval response       Approve or Reject (text)
If Approved → emails student      confirmation email sent

COPILOT STUDIO (receives result)  What data moves
──────────────────────────────────────────────────
Flow returns status text     ←←←  text: "Processing complete"
Agent sends message to student    "Your exam is being reviewed"