Can Copilot help summarize employee feedback and review data?

The build vs use question is where most teams stall. 

You definitely don't need to buy anything.

And while you can, you don't really need a custom agent for this one. 

Point Copilot at the SharePoint library where the feedback and 1:1 notes already live, give it a tight prompt with your review structure, and you've got 80 percent of what you are looking for. The workflow in this case matters more than the tooling 

If your feedback, 1:1 notes, goals, and review documents are all stored in places that Copilot can access (SharePoint, Teams, OneDrive, etc.), it can definitely help summarize information and surface key themes. We've had decent results using prompts to pull together meeting notes, feedback comments, and goal updates before review conversations.

The challenge is that employee feedback data is often spread across multiple locations and formats. In our case, managers still had to know where everything was and sometimes manually point Copilot to the right files.

What ended up being more useful for us was having the performance management system itself generate the summary. Some of the better HR tools in the Microsoft ecosystem like Teamflect already use AI to summarize feedback, review comments, survey responses, and goal progress in one place, which saves managers from hunting down documents first.

So I'd say Copilot can absolutely help, especially if your data is already well organized in M365. But if performance reviews are a major process for your organization, it's worth looking at whether your review platform has AI summaries built in rather than relying entirely on Copilot prompts.

Hi ClaireB​ !

this is a great use case and one I've worked through with teams, so let me give you the honest picture.

Short answer: yes, Copilot can do this, but for performance and feedback data specifically there's one thing you have to get right first, it's permissions.

Copilot only ever sees what the signed-in person already has access to. It never breaks permissions. That sounds reassuring, and it is, but it cuts both ways. If those 1:1 notes, peer feedback, and goal files are sitting in SharePoint with loose permissions, Copilot can surface sensitive content to people who technically have access but were never meant to read it. With HR data, that's the real risk to manage before you roll anything out. So step one is making sure each manager can only reach their own team's data.

On the "automatic" part of your question: Copilot won't reliably go and gather months of scattered notes on its own unless they're well organised. The way it actually works well is when you point it at the right place. So if a manager keeps a team in a specific SharePoint folder or document, they can prompt Copilot in something like: "Summarise the key themes from the peer feedback and 1:1 notes in [this folder] for [employee], grouped into strengths, areas to develop, and progress against goals." The more structured the source, the better the summary.

On whether you need to build something custom: start simple. Copilot in SharePoint, Teams, and Word handles a lot of this with no build at all. If you want something more repeatable, where managers click a button and get a consistent review summary, that's where Copilot Studio comes in. You can build a lightweight agent grounded only on the right HR site, which also helps you control exactly what it can and can't touch.

Two last things from experience:
First, always keep a human in the loop. Copilot can miss nuance or over-weight a single loud piece of feedback, so treat its summary as a first draft for the manager, never the final word on someone's performance.
Second, before you scale this up, loop in whoever owns data governance and HR compliance, because performance data carries extra sensitivity.

Happy to share a simple prompt set if that would help. Good luck with it😀

Hi

Yes, Copilot in Microsoft 365 can help managers prepare for performance reviews by summarizing feedback, notes, and goals stored in SharePoint or OneDrive, but the effectiveness depends heavily on how well your SharePoint environment is structured and governed.

You need to Tag documents clearly, Clean SharePoint data like Remove duplicates, outdated files, and “junk” folders, ensure permissions are correct, so Copilot doesn’t surface irrelevant or sensitive content.

You can do some workarounds like- 

Start with Copilot in SharePoint and Teams no custom build needed. 

Clean and tag files before rollout.

Use SharePoint Advanced Management to tighten governance.

If managers need more tailored workflows, explore Copilot Studio for lightweight custom agents.

Thanks 

Sunita