How can I automate a copilot workflow that summarizes a meeting transcript and saves the result as a structured Word/PDF in SharePoint?
Hi everyone,
I’m trying to build what I originally thought would be a pretty standard business automation scenario with Copilot Studio + Power Automate + SharePoint:
- A transcript from a meeting is uploaded to a SharePoint document library.
- A Power Automate flow is triggered.
- The file content is passed to a Copilot Studio agent.
- The agent creates a structured summary based on the instructions.
- The structured and formatted summary should be saved automatically as a PDF back into SharePoint.
The summarization part itself is not the main issue. The real problem starts when trying to persist the structured/formatted response of the agent into a Word/PDF document.
At the moment, I see these issues:
- If I use a Word template with content controls, the agent response is inserted only as plain text.
- The structure and formatting of the agent response is lost or heavily degraded.
- Headings, paragraphs, bullet points, spacing and overall readability are not preserved properly.
- Using multiple predefined template fields would require forcing the agent into a rigid JSON structure, which feels completely over-engineered for simply saving a summarized response.
- Using HTML as an intermediate format feels like a workaround, not a clean native business solution.
- The Word Online connector seems quite limited when it comes to rich text / formatted content insertion.
I’m especially interested in:
- recommended architecture
- how to preserve formatting from an agent response into a PDF
- whether there is a native Microsoft-first way to do this without third-party connectors
I’m honestly surprised how difficult this seems for such a basic use case:
generate a structured AI response and save it as a readable document in SharePoint.
Any proven patterns, examples, or lessons learned would be highly appreciated.
Thanks!