Unanswered

Knowledge base document (Excel) file can be seen by the agent but not the content

(0) Share

Report

Posted on by LY-11120059-0

I'm using copilot studio. I've setup the knowledge base where I put my sharepoint folder for the agent to perform data analysis. In testing some of the file (the excel file) appear not accessible, but when I asked agent to list down the file it is able to list it down.

Further troubleshooting, it appear that the agent is not able to read the content or making index out of excel. Only can ready PDF. I believe that it is a security block in my organization to it. But how do I proof it? Or is there a scale down Copilot studio version with retriction that I'm not aware?

Categories:

Copilot Studio pre-built agents/templates

I have the same question (1)

All responses (2)

Answers (0)

Nivedipa-MSFT on at

Like (0)

Report

Thanks for bringing this issue to our attention. We will check and update you soon.

Was this reply helpful? Yes No
Nivedipa-MSFT on at

Like (0)

Report
Generative answers that rely on SharePoint can only process a limited range of file types. Specifically, supported formats include:

SharePoint pages (note: .aspx pages are not supported)

Word documents (.docx)

PowerPoint presentations (.pptx)

PDF files (.pdf)

For more details, refer to the documentation: Generative answers with Search and summarize - Microsoft Copilot Studio | Microsoft Learn

If you need to include Excel documents in your generative answer node, you can upload the file directly into your Copilot, which accepts a broader variety of file formats, such as:

Word (.doc, .docx)

Excel (.xls, .xlsx)

PowerPoint (.ppt, .pptx)

PDF (.pdf)

Text files (.txt, .md, .log)

HTML (.html, .htm)

CSV (.csv)

XML (.xml)

OpenDocument formats (.odt, .ods, .odp)

EPUB (.epub)

Rich Text Format (.rtf)

Apple iWork files (.pages, .key, .numbers)

JSON (.json)

YAML (.yml, .yaml)

LaTeX (.tex)

You can find the full list of supported document types in the following resource: https://learn.microsoft.com/en-us/microsoft-copilot-studio/nlu-documents#supported-document-types

Was this reply helpful? Yes No