Unanswered

Connecting a SharePoint Site to Copilot Studio Bot with Query Strings and Depth

Like (0) Share

Report

Posted on 6 Feb 2024 12:19:28 by CleanFox

Is there a workaround to connect a SharePoint site to my Copilot Studio Bot, even if the site contains query strings and is more than two levels deep, which goes against the rule of not including query strings, more than two levels of depth, or the character “.” in the URL?
I am concerned that connecting to the initial SharePoint site will result with a knowledge base that is too large for the bot, decreasing the accuracy of its responses, which is why I would like to connect only to a specific “sub-area” within SharePoint.

All responses (14)

Answers (0)

dttigger88 63 on 23 Jun 2024 at 22:58:20

Like (0)

Report

Connecting a SharePoint Site to Copilot Studio Bot with Query Strings and Depth

Hi adilei

Can you provide more details in regard to your answer to point the Gen Answers node at a specific document library PLS?
Where would your example go in the Gen answers?

Cheers

Dave
CU11060635-0 2 on 11 Jun 2024 at 06:39:04

Like (0)

Report

Connecting a SharePoint Site to Copilot Studio Bot with Query Strings and Depth

Can you please provide a clear description of how can we add URL's which is more than two level deep or in particular make it point to document library?
mr_dbc 14 on 28 Mar 2024 at 10:27:25

Like (0)

Report

Re: Connecting a SharePoint Site to Copilot Studio Bot with Query Strings and Depth

@CleanFox I had the same query?
CleanFox 20 on 13 Feb 2024 at 07:09:05

Like (1)

Report

Re: Connecting a SharePoint Site to Copilot Studio Bot with Query Strings and Depth

Do we know if/when Microsoft plans to implement a solution that would eliminate the need for a workaround?
adilei on 12 Feb 2024 at 13:21:21

Like (2)

Report

Re: Connecting a SharePoint Site to Copilot Studio Bot with Query Strings and Depth

That might be true, but it's also true of almost any RAG pattern - not just the workaround I suggested. If you build your own query to Graph API, you could try to add filters based on your use case to reduce the population of relevant results.
CleanFox 20 on 12 Feb 2024 at 13:12:11

Like (0)

Report

Re: Connecting a SharePoint Site to Copilot Studio Bot with Query Strings and Depth

yes, and if i have a large library, the chance that some of the N top results are not the exact that i want. which is why i want to utilize a smaller library (which also consists of multiple documents and folders, though not as many as the main library). But according to the video, the example only utilized a webpage consisting of a single article, which is why i think that solution might not be viable for my case.
Though I might be wrong, or misunderstanding some key aspect.
adilei on 12 Feb 2024 at 12:53:20

Like (0)

Report

Re: Connecting a SharePoint Site to Copilot Studio Bot with Query Strings and Depth

Not sure I follow - when you implement a RAG pattern only the N top results are being fed to the LLM for summarization. This is also how Gen Answers work OOTB.
CleanFox 20 on 12 Feb 2024 at 12:18:18

Like (0)

Report

Re: Connecting a SharePoint Site to Copilot Studio Bot with Query Strings and Depth

This does seem like a good workaround when referencing a web page which is an article, but I'm hesitant that this would work on a much larger library of files and folders.
Even if this would work, I'm guessing it would need to search through all for each response which would take a long time, and it would not be "trained" on the documents, rather searching and extracting for each user question.
In my case, I don't think this solution would be viable.
adilei on 12 Feb 2024 at 11:47:47

Like (0)

Report

Re: Connecting a SharePoint Site to Copilot Studio Bot with Query Strings and Depth

There is not workaround that I know of as much as a custom pattern: build a Power Automate flow that would query Graph API and feed the results to "custom data" in the Gen Answers node.

This video is a good place to start.
robquickenden 4 on 12 Feb 2024 at 09:23:26

Like (1)

Report

Re: Connecting a SharePoint Site to Copilot Studio Bot with Query Strings and Depth

I have the same issue - we have a deep SharePoint structure with actually many of our libraries created in teams. I cant use Copilot for M365 or Copilot Studio to reference these libraries as it only supports two levels deep. Anyone found a workaround please.