Hi everyone,
I'm building a Teams chatbot using Copilot Studio that retrieves information and videos from a SharePoint library based on user prompts.
Here's what I'm aiming to achieve:
User asks a question in the chat.
Bot searches SharePoint documents and identifies relevant information.
Bot respond using Generative AI along with any related videos.
Ideally, the bot pinpoints the specific video section addressing the question.
Current Progress:
I've successfully used generative AI to answer questions based on SharePoint documents.
I can display SharePoint videos in Teams chat using adaptive cards.
Challenge:
I'm struggling to connect these elements. I need help figuring out how to:
Search SharePoint videos for relevant information based on user queries.
Identify the specific section of a video that addresses the user's question (if possible).
Potential Solution: Leveraging Video Transcripts
I noticed that SharePoint videos on Stream often have transcripts available. I'm wondering if it's possible to:
Looking for Advice:
Has anyone worked with SharePoint videos and Copilot Studio in Teams chatbots? Any suggestions or solutions for:
Thank you
I have looked into all the resources you have provided but unfortunately I am unable to find a way in which I could search the transcripts of all the videos on the sharepoint site which I have access to without using the teamsid/transcript id.
I should be able to retrieve the transcripts of based on the search terms and input these transcripts to the genAI and retrieve responses aswell as display the videos which I am referring to.
You may need to explore Graph APIs that offer access to transcripts. Please refer to the links below for further information:
Romain The Low-Code...
132
Michael E. Gernaey
81
Super User 2025 Season 1
Pablo Roldan
61