SharePoint Agents are "point at content." Copilot Studio is "design a behavior." When the same conversation happens every quarter (JBP prep, S&OP review, new product launch gate, agency brief intake), it's a Studio candidate. The point of this lab is not for you to build the agent — it's for you to be a strong product owner for the team that will. Most executives skip this step and end up with an agent that doesn't solve a real problem.
Step 1 — pick one process
Best candidates are processes that are: (a) recurring (you do it more than 4× a year), (b) repeatable shape (always asks for similar inputs), (c) knowledge-heavy (the prep work is in many files), (d) painful (the team complains about it). Edgewell examples:
-
JBP Prep Agent — walks a sales lead through pulling the right data, last-year commitments, open chargebacks, and category context before a retailer JBP.
-
S&OP Question Agent — answers the routine questions that come into the S&OP team during the cycle (forecast variance, capacity, demand signals) from a defined data set.
-
Launch Gate Agent — assembles the stage-gate package for a new product launch by asking the brand team a series of questions, pulling artifacts, and flagging gaps.
-
Insights Triage Agent — routes consumer research requests, suggests existing studies, drafts the brief, and books the methodology review.
Step 2 — write the product brief for the agent (don't build yet)
Use Copilot Chat to draft the agent product brief
Help me write a product brief for a custom Copilot Studio agent at Edgewell. The process I want to agentify is: [name the process — e.g., Walmart JBP Prep]. Cover: (1) WHO uses this agent (sales lead, brand team, FP&A) and what role they're in when they use it; (2) WHAT problem the agent solves in one sentence, with the alternative-today (current pain) named; (3) WHAT inputs the agent asks the user for (specific fields, not vague); (4) WHAT data sources it draws from (name actual SharePoint sites, files, internal systems); (5) WHAT artifact it produces (a draft deck, a doc, a checklist?); (6) FAILURE MODES — three ways this agent could be wrong or unhelpful, and how we'd detect; (7) SUCCESS METRIC — what would make us say in 90 days "this was worth it." Keep it to one page. Executive product-owner tone.
Step 3 — sketch the agent's conversation in Studio
Open Copilot Studio. Create a new agent. In the Instructions field, paste the design prompt below. Studio will generate a starter agent you can iterate on. This is enough for a working prototype — your IT partner can wire up data connections after.
Initial agent design — paste into Studio instructions
You are the JBP Prep Agent for Edgewell sales leads. Your job is to walk a sales lead through preparing for a Joint Business Plan meeting with a retailer (Walmart, Target, Costco, Amazon, CVS, Walgreens, Kroger, Club, or international). When a user starts, ask them: (1) which retailer is the JBP for, (2) which brands are in scope (Schick, Banana Boat, Hawaiian Tropic, Playtex, etc.), (3) the JBP date, (4) what they remember being committed to in the last JBP. Then, based on the answers, do the following: (A) pull from the appropriate SharePoint site the most recent JBP deck, last year's commitments, current YTD performance, open chargebacks, and category competitive context; (B) produce a structured prep document with sections — "Where we stand," "What we owe them," "What we want from them," "Tension points," "Open data we still need"; (C) before finishing, ask the user three sharpening questions that the user must answer before the prep doc is finalized; (D) output the final prep doc to a new Page in the user's OneDrive titled "[Retailer] JBP Prep — [Date]." Tone: efficient, retailer-savvy, never breezy. If the user asks something outside JBP prep, redirect them gently. If you can't find a source for a number, say so — never estimate.
Step 4 — pressure-test the design with a peer
In Copilot Chat (or back in your CW1 Page), with a teammate
Critique this Copilot Studio agent design from the perspective of a senior Edgewell sales lead who'd actually use it. Where is the conversation flow weak? Where is the prep doc structure likely to feel useless? What inputs am I asking for that don't matter? What inputs am I NOT asking for that I should? What's the one change that would make the difference between this getting used and this getting ignored after week 2?
Expected outcome
A one-page product brief and a draft Studio agent for one real Edgewell process. You're not "done" — the next step is a 2-week build with IT and a pilot user. But you'd walk out of this room ready to assign that work, with a clear definition of what success looks like.
Tip — start with the artifact, work backwards
The strongest Studio agents are designed from the output. If you can describe the exact artifact ("a 6-section Word doc named X with these fields filled in"), the conversation flow falls out naturally. If you can't describe the artifact, you're not ready to build the agent yet.
Don't agentify a broken process
If your JBP prep is bad today because the underlying data is bad, agentifying it will create a faster, cleaner, more impressive bad JBP prep. Fix the data foundation first, then automate. Otherwise you're scaling a problem.
This is an IT + business co-build
Studio agents that touch real systems (Salesforce, SAP, Edgewell's internal financial systems, syndicated data feeds) need IT to wire the connections. Bring IT in at the brief stage. Building first and asking for connections after is the classic anti-pattern.
Self-check
- I picked one specific process — not "agents in general."
- I wrote a one-page brief with WHO, WHAT, INPUTS, SOURCES, OUTPUT, FAILURE MODES, and a 90-day success metric.
- I have a critique from a peer in the role who'd actually use the agent.
- I know what I'd ask IT to wire up next.
Facilitator note
Cap this lab at 14 minutes. The temptation is to over-design. Tell the room: "By the end of this lab, you have a brief and an opinion — you don't have a finished agent. That's deliberate." Use the remaining time to have two execs read their briefs aloud and the room critique.