Unanswered

Unable to read Excel files in sharepoint from Chatbot

(2) Share

Report

Posted on by GV-28060942-0

HI Team,

We have created a Custom chatbot using COPILOT Studio and it is working fine. The bot is pointing to the Sharepoint folder and public website to get the answers which are posted to BOT. For this we are using the option Generative answers.

But, it seems the bot is not accessing the excel files from sharepoint folder to get the answers. Where as it is reading the excel files to get the answers which are attached directly to the BOT using knowledge option.

Is copilot studio bot is not supporting the Excel files which are stored in sharepoint or do we have any specific steps to follow?

Appreciate your help on this.

Thanks in advance

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Expiscornovus 33,851 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
As far as I am aware Excel files are not one of the supported content types in Generative answers feature.

For reference see the link below:

https://learn.microsoft.com/en-us/microsoft-copilot-studio/nlu-boost-node#supported-content

Supported content

Generative answers obtain content stored in these formats:

SharePoint pages (modern pages)

Word documents (docx)

PowerPoint documents (pptx)

PDF documents (pdf)

Was this reply helpful? Yes No
SV-01071220-0 6 on at

Like (1)

Report
Copy link

Link copied!

Thanks for your response.

In this case how to proceed further to access excel files which are stored in SharePoint from Copilot studio.

Was this reply helpful? Yes No
Expiscornovus 33,851 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

You can use for example a Power Automate cloud flow and the list rows present in table action to interact with Excel data.

https://learn.microsoft.com/en-us/microsoft-copilot-studio/advanced-flow-create

Or directly call a flow action instead:

https://learn.microsoft.com/en-us/microsoft-copilot-studio/advanced-use-flow

Was this reply helpful? Yes No
DM-06011630-0 2 on at

Like (1)

Report
Copy link

Link copied!

Any plans to support excel files?

Was this reply helpful? Yes No