Automating generation of KB articles in SharePoint based on Teams transcripts (via Copilot / Power Automate?)
Hi folks👋
I’m working on a small project and trying to automate a workflow that’s currently very manual.
During some Teams calls, I enable transcription so I can go back and look at what knowledge has been shared / discussed.
Once the meeting ends, I go into the chat, open the recap, download the transcript (Word), then upload it into Copilot to generate a structured knowledge base article based on a template.
After that, I download the generated document and upload it to SharePoint.
It works, but it’s a lot of manual steps for something that feels like it could be automated..
What I’d like instead is something like this:
meeting ends
transcript is automatically retrieved
processed into a clean, structured KB article (with consistent formatting)
saved directly to SharePoint (Word format)
Basically : turning conversations into documentation automatically, with no / a minimum of manual steps.
I’ve started experimenting with Copilot Studio and Power Automate, but I’m struggling with the automation part and how to connect everything properly.
I assume this would involve Teams transcripts, OneDrive/SharePoint, Power Automate, and some kind of LLM/Copilot - but I change keyboards and passwords for a living, I’m not sure what the cleanest architecture looks like, or even what’s actually feasible...
Has anyone built something similar, or found a good way to automate this?
If you guys have any tips for me or expertise on the topic, I'm really all ears...
Thanks !!