Unanswered

Copilot Studio Generative AI retrieve documents from sharePoint.

(0) Share

Report

Posted on by treav

Hi
I am able to connect copilot to my SharePoint, but it is only retrieving links of documents that too only doc and pptx not xlsx or workbooks or any other format.

How do I resolve this.

- How do I get file instead of file links.( Power Automate Flow is my last option for retrieving as it's too slow)

- How do I include and have more relevant document (pdf,doc,xlsx,pptx)

All responses (7)

Answers (0)

RR-22020015-0 2 on at

Like (0)

Report

Copilot Studio Generative AI retrieve documents from sharePoint.

Excel files are not supported in Generative Answers: https://learn.microsoft.com/en-us/microsoft-copilot-studio/nlu-boost-node#supported-content

Could this be why?
adilei on at

Like (0)

Report

Re: Copilot Studio Generative AI retrieve documents from sharePoint.

I don't know of any other way to achieve that other than scraping links and triggering a Power Automate flow. On another not, I'm still not convinced I understand the value of this user experience.
treav 10 on at

Like (0)

Report

Re: Copilot Studio Generative AI retrieve documents from sharePoint.

Okay

Step 1: Flow <1>
So here I have GenAI + Data from SharePoint

Step2:
I ask for a document x.
Response <sharepointURL>/x.doc
Now That goes into chat window
<2>
Now I can send this response to whom I want by
<3>
But I want to add this as an attachment
Not link

I want to send an email with attached document No link in the message like <2>

Alternatives I know of:

Can use a flow/power Automate to add flow to get link and then doc but:
- Too much time required in flow
- parsing text + links in <2> to only links is hard
adilei on at

Like (0)

Report

Re: Copilot Studio Generative AI retrieve documents from sharePoint.

I'm not following, sorry. Can you describe the desired user experience, step by step?
treav 10 on at

Like (0)

Report

Re: Copilot Studio Generative AI retrieve documents from sharePoint.

for the latter I can send email directly
but for the former I need to download the file from attachment and the end user may have to be given access to the file if given link which I don't want to.
I also need to create a flow as per my knowledge to send file from links which would be very slow
adilei on at

Like (0)

Report

Re: Copilot Studio Generative AI retrieve documents from sharePoint.

What is the difference between providing a link and providing an attachment? How would the UX differ?
treav 10 on at

Like (0)

Report

Re: Copilot Studio Generative AI retrieve documents from sharePoint.

Actually what I want to know is

I have a sharepoint with 10 files a,b, ...., j
If I say copilot to get a from sharepoint it returns <sharepointurl>/a.extension
what I want is in the chat itself the original file instead of <sharepointurl>/a.extension like an attachment in email we can download. So that it removes going to sharepoint