Showing posts with label Teams automation. Show all posts
Showing posts with label Teams automation. Show all posts

Wednesday, December 10, 2025

How to Supercharge Your AI Personal Assistant in Copilot Studio: Daily Briefings, Smart Priorities, and Automated Follow-Ups

How to Supercharge Your AI Personal Assistant in Copilot Studio: Daily Briefings, Smart Priorities, and Automated Follow-Ups

In the previous post, we created a powerful weekly review agent in Microsoft Copilot Studio that automatically scanned your email, calendar, and Teams messages and produced a clean summary of high-priority items. That agent acted like a personal chief of staff who shows up every Friday with a full report.

Now it’s time to level up. In this guide, we’ll turn your assistant into a proactive, daily-support AI system — one that tracks new priorities, reminds you of commitments, creates follow-ups, notifies you in Teams and email, and delivers a morning briefing every day.

By the end of this tutorial, you’ll have an AI assistant that behaves much more like a real executive aide: attentive, organized, and always one step ahead of you.


What Your Upgraded Assistant Will Do

Once you complete the steps in this article, your AI assistant will be able to:

  • Send a daily morning briefing with meetings, tasks, unread important messages, and preparation notes.
  • Track high-priority emails automatically by detecting urgent senders, flagged items, and time-sensitive content.
  • Perform automatic follow-up checks on messages you sent that haven’t received responses.
  • Deliver smart notifications via email and Microsoft Teams anytime something important happens.
  • Answer questions anytime through a custom “Ask My Assistant” topic inside Copilot Studio.

Let’s get started.


Step 1: Add a Daily Morning Briefing Flow

Your weekly summary is useful — but a daily briefing turns your assistant into something you actually depend on. It should tell you:

  • Your meetings for the day
  • Who they’re with
  • Preparation notes (pulled from email threads)
  • Your due tasks
  • Unread urgent messages

Create the Scheduled Trigger

  1. Open Copilot Studio.
  2. Select your existing Weekly Review Agent.
  3. Go to Topics > Add > Scheduled Topic.
  4. Set it to run every weekday at your preferred time (e.g., 7:30 AM).

Screenshot description: A Copilot Studio window showing a scheduled trigger set for weekdays at 7:30 AM.

Connect the Outlook Calendar

  1. Add the action Get events from Outlook Calendar (Today).
  2. Store results in a variable called TodayMeetings.

Pull Relevant Emails

  1. Add action: Get unread emails (last 24 hours).
  2. Add filter conditions:
    • If sender is your manager/supervisor
    • If subject contains “urgent”, “deadline”, “asap”, “review”
    • If email is flagged

Compile the Briefing Prompt

Add a Create text with GPT step. Use this prompt:

Create a concise daily briefing. Include:
- Today's top priorities
- Meetings with participants and prep notes
- Important unread or flagged emails
- Tasks due today or overdue
Return the briefing in a clean bullet format.

Send the Briefing by Email & Teams

  1. Add action: Send an email → To yourself → Subject: “Your Morning Briefing”.
  2. Add action: Post message to Teams → Your private chat or a channel.

Step 2: Add Smart Priority Tracking

The best personal assistants don’t wait for you to tell them what's important — they anticipate it. We’ll build logic that automatically flags important messages based on:

  • Sender importance
  • Keywords
  • Flags or categories
  • Deadlines

Create a Classification Prompt

Add a new topic called PriorityClassifier.

Use this prompt:

Determine whether the following email is:
- High Priority
- Medium Priority
- Low Priority

Consider:
- Time sensitivity
- Sender importance
- Explicit deadlines
- Required actions
- Follow-ups mentioned

Return JSON:
{"priority":"High|Medium|Low","reason":"text"}

Then, every time your agent reads emails (daily or weekly), send them through this classifier.

High-priority items will get stored in a persistent variable such as PriorityList.


Step 3: Add Automated Follow-Up Detection

This is where your assistant becomes a game-changer. Follow-ups often slip through the cracks — so the agent will now detect:

  • Emails you sent that haven’t received replies after X days
  • Requests you made in Teams that were ignored
  • Meetings with missing notes or open action items

How to Build the Follow-Up Checker

Create a new scheduled topic:

  • Name: FollowUpCheck
  • Run every day at 2:00 PM

Outlook Follow-Up Logic

  1. Use Get Sent Emails (last 48 hours).
  2. Filter for emails that:
    • Asked a question
    • Requested a task
    • Expected a response
  3. Check whether the email thread has a response.
  4. If no response → Add to FollowUpList.

Teams Follow-Up Logic

  1. Add connector: Get messages from Teams.
  2. Search for:
    • “Can you…”
    • “Please review”
    • “Let me know”
  3. If no reply within 24–48 hours → Add to FollowUpList.

Send Follow-Up Summary

Use GPT to compile the list and send reminders to yourself.

You can even send auto-generated follow-up draft emails.


Step 4: Add an “Ask My Assistant” Topic

This lets you manually ask your assistant for insights anytime, such as:

  • “What follow-ups do I owe?”
  • “What’s coming up tomorrow?”
  • “Summarize my current priorities.”
  • “Do I have anything overdue?”

Create a new topic called AskAssistant.

Use this prompt:

You are my personal assistant. Use the stored variables:
- PriorityList
- FollowUpList
- TodayMeetings
- HighPriorityEmails

Answer the user’s question using real data. 
If data is missing, ask a clarifying question.

This gives you on-demand access through Teams, the web agent, or Copilot Studio’s chat interface.


Step 5: Add Smart Notifications

Now let’s make your assistant proactive. You can choose to notify yourself when:

  • A high-priority email arrives
  • Someone important emails you
  • A deadline is 24 hours away
  • A flagged task hasn’t moved

Create Event-Driven Triggers

These require Outlook event triggers:

  • On new email received
  • On event added to calendar

When a new high-priority email comes in:

  1. Run classification
  2. If “High Priority” → Post a Teams notification and send an email alert

Screenshot description: Copilot Studio flow with an “Email received” trigger and conditional priority filters.


The Final Result

Once complete, your upgraded AI assistant will:

  • Greet you every morning with what matters
  • Watch your inbox and Teams for urgent items
  • Organize your priorities and store them
  • Track outstanding tasks without you doing anything
  • Remind you at the perfect time
  • Be ready to answer questions anytime

This is no longer just a weekly review bot — it’s a real personal productivity AI.


Want to Go Even Further?

Here are some ideas for future enhancements:

  • Voice activation (“Hey Copilot, what’s next?”)
  • Smart tagging and automatic email categorization
  • A dashboard in Power BI showing all priorities
  • Integration with To Do or Planner

If you'd like a guide on any of these, just let me know!

How to Build a Weekly Review Agent in Microsoft Copilot Studio (That Summarizes Emails, Meetings & Teams Messages Automatically)

How to Build a Weekly Review Agent in Microsoft Copilot Studio (That Summarizes Emails, Meetings & Teams Messages Automatically)

Imagine getting a weekly CEO-style summary of your entire digital life—emails, meetings, tasks, Teams messages—without doing anything. No digging through inboxes. No rereading meeting notes. No scrambling to remember who asked you to do what.

With Microsoft Copilot Studio, you can build a fully automated agent that reviews your:

  • Outlook emails
  • Calendar meetings
  • Teams chat messages
  • Follow-ups and commitments
  • Deadlines and tasks

…then generates a high-priority, easy-to-read weekly summary and delivers it to you via:
✔ Email and ✔ A Teams message.

This guide walks you step-by-step through building that agent—from setup to automation to formatting your weekly report.


Why a Weekly Review Agent Is a Game Changer

Every professional is drowning in notifications. Between email threads, meeting invites, chat messages, and project tasks, it’s easy to lose track of what actually matters.

A Copilot agent solves this by:

  • Pulling signal from noise—summarizing only the important items.
  • Identifying action items you promised but forgot.
  • Highlighting deadlines coming up next week.
  • Summarizing themes across all communications.
  • Packaging everything into a concise, readable weekly review.

Better yet—this runs automatically every Friday at the time you choose.


What You Need Before Starting

  • A Microsoft 365 Business or Enterprise account
  • Access to Copilot Studio (formerly Power Virtual Agents)
  • Permission to use Outlook, Teams, and Power Automate connectors
  • Basic familiarity with Microsoft 365

This tutorial is designed for beginners. You don’t need coding or technical skills.


Step 1 — Open Copilot Studio

Go to:

https://copilotstudio.microsoft.com/

On the left-hand panel, click:

+ New Copilot

Name your agent:

Weekly Executive Summary Agent


Step 2 — Create a New Trigger

Triggers are how your agent starts running. We will create a manual version AND an automated weekly version.

Create Manual Trigger

  1. Go to Topics
  2. Click + New Topic
  3. Name it “Run Weekly Review”
  4. Add trigger phrases:
    • run weekly summary
    • weekly review
    • summarize my week

Step 3 — Connect Outlook and Teams

Your agent needs permissions to read your messages, meetings, and chat.

Go to:

Data → Connections → + New Connection

Create these connections:

  • Office 365 Outlook
  • Microsoft Teams
  • Microsoft Graph (optional but powerful)

Step 4 — Pull Emails From Outlook

Inside your “Run Weekly Review” topic, click:

Add → Call Action → Power Automate Flow

Create a new flow named:

Get_Weekly_Emails

In Power Automate:

  1. Add trigger: When this flow is called
  2. Add action: Get emails (V3)
  3. Filter the mailbox:
    Received Time >= addDays(utcNow(), -7)
  4. Set “Top” to 250 (to prevent overload)

This retrieves all emails from the last 7 days.


Step 5 — Pull Calendar Meetings

In the same flow, add:

Get Calendar View (V3)

Set the date range:

Start Time: addDays(utcNow(), -7)
End Time: utcNow()

This returns all meetings held during the week.


Step 6 — Pull Teams Messages

To capture chat activity, add:

List Chat Messages (Graph connector)

Use filters:

Created DateTime >= addDays(utcNow(), -7)

Step 7 — Combine All Inputs

Your flow now bundles:

  • Emails
  • Meetings
  • Teams chat messages

Return the combined text back to your Copilot agent.

Add an action:

Return value(s) to Copilot

Send:

  • Email bodies
  • Email subjects
  • Meeting summaries
  • Meeting transcripts (if recorded)
  • Chat messages

Step 8 — Generate the High-Priority Summary (Inside Copilot)

Back in Copilot Studio, after the Power Automate action, click:

Add → AI Prompt

Use this prompt (highly effective):

You are my weekly executive assistant.

Analyze all messages, emails, and meetings. Create a structured report with these sections:

1. High-Priority Action Items (must-do)
2. Important Follow-Ups
3. Decisions Made This Week
4. Deadlines and Upcoming Dates
5. Key Conversations and Themes
6. People Waiting on Me
7. Risks or Red Flags

Keep it concise but clear. Use bullet points. Use bold for key items.

This generates your weekly report.


Step 9 — Send the Summary via Email

Add another Power Automate Flow:

Send_Weekly_Email

  1. Trigger: When called from Copilot
  2. Action: Send Email (V2)
  3. To: Your email address
  4. Subject: Your Weekly Executive Summary
  5. Body: Insert summary text from Copilot

Step 10 — Send the Summary via Teams

Create a third flow:

Send_Weekly_Teams_Message

  1. Trigger: When called from Copilot
  2. Action: Post a Message in a Chat or Channel
  3. Choose:
    • Your personal chat
    • Or a Teams channel
  4. Paste summary text

Now you receive the report in two places automatically.


Step 11 — Automate Weekly Scheduling

Go back to Power Automate and create a new flow:

Weekly_Auto_Run

  1. Trigger: Recurrence
  2. Set:
    • Frequency: Weekly
    • Day: Friday
    • Time: 8:00 AM (or your preference)
  3. Action: Trigger your Copilot Agent

Done — your agent now runs itself on schedule.


Final Thoughts

You’ve just built an AI-powered assistant that:

  • Reads your emails
  • Reviews your meetings
  • Analyzes your Teams messages
  • Extracts tasks and priorities
  • Sends you a polished weekly summary
  • Delivers it to both Email and Teams

This is the future of personal productivity—and you built it in under an hour.

How to Supercharge Your AI Personal Assistant in Copilot Studio: Daily Briefings, Smart Priorities, and Automated Follow-Ups

How to Supercharge Your AI Personal Assistant in Copilot Studio: Daily Briefings, Smart Priorities, and Automated Follow-Ups In the pre...