How to configure Generative Answers in Copilot Studio to use SharePoint
Vložit
- čas přidán 27. 03. 2024
- In this video, I walk you through the steps needed to configure Copilot Studio to use SharePoint as a location for Generative Answers. There are many videos out there and they all leave a few steps out. This is the definitive guide on how to do this.
Here are the links to the docs on the Microsoft site about it, but you will see that some steps aren't that clear making this one of the most asked questions from my customers and friends.
learn.microsoft.com/en-us/mic...
learn.microsoft.com/en-us/mic...
I hope you find this helpful and don't forget to like an subscribe! - Věda a technologie
thaks Dewain, you total legend !! this just happens to be the exact thing im working on at the moment.
I knew it... that's why I made it :D
Great video! I realize my scope was incorrectly defined! 😂
I know that was my problem when I first was trying...
@@Dewain27 You do'nt know how much time I spent trying to make it work changing a lot of variables, but nobody mentioned the scopes.. You are the first! THANK!! YOU!!
This was great, thank you so much. I wonder if there is a way to configure Co-Pilot, such that it searches below two levels of Sharepoint Online? We have configured our sites in such a way that our document libraries are below the second level. Any thoughts or suggestions would be most welcome!
this really helped with my deployment to teams. there are parts in here that are not covered natively / directly in the authentication configuration when linked directly from copilot studio. the symptom is my bot was not responding on either the demo site or teams - after applying this config it started responding. it seems there is some additional configuration when attempting to use teams only authetnication.
Hi Dewain, many thanks, it is very useful. I did what you indicate in your video step by step, however I can't get any results with the documents stored in my sharepoint. Will there be any limitations when using the trial version? or with the language? because I work in south america and I have configured my copilot in spanish.
Good Job!
Thanks a lot for this video! Followed all the steps and it now ask for authentication on start, but i see anyway the red sentence inside the "Create generative answers" action: "Authentication must be enabled to use this feature". Is that ok?
Is there some priority rule if you have as a source public web sites and internal Sharepoint sites ? Which one is treated as more trustworthy ?
Why did you set it up for Any Organizational Directory, and not just single tenant? I would like to set this up, but I want to be sure it's only accessible by my tenant and no one outside. Also, can it be further locked down to specific users/group in a single tenant?
Thanks Dewain. I am seeing a lot of chatter in the community on Copilot NOT getting the content that is in SharePoint fully. For example, I uploaded a resume that is all text (PDF) and I have yet to get Copilot to generate any content from it. "Tell me the summary of NAME's Resume" etc. I get the Rephrase of death message constantly. But in the same folder I uploaded another random PDF and Copilot is able to generate from it. It feels very hit and miss. What can/should be done to optimize SharePoint so that Copilot is indexing all content in the site. Better yet, what query or option can be run in Graph Explorer to see that it is actually being indexed?
If I have a large Sharepoint site (2-3 GB worth of files), do you recommend creating a custom Search Index using Blob Storage and Vector Search, or is this method okay too?
Do I need an Azure subscription for these authentication settings?
Great video. Thank you.
At the end you mentioned about M365 copilot, if we have that available then it’s better to search the documents through that ? We don’t need to do this in copilot studio? Please shed some light on it. Appreciated.
No, if you own M365 Copilot then you will just get better results when using Copilot Studio as it changes the way that the data is indexed in your SharePoint site for users licensed for M365 Copilot.
Thank you for the great video! To clarify, the semantic indexing will only apply to the users licensed for the M365 Copilot? So if we don’t intend to license the entire org with M365 Copilot license we could still use the Copilot studio bot for HR docs but it will be a hybrid search for users not licensed for the M365 Copilot?
Big fan of your content! Is there a way to get this sharepoint search to work when publishing the copilot in a channel like WhatsApp to external parties that don’t necessary have an entra id account in my tenant? Something like using a service accounts, impersonating?
The issue is that WhatsApp is not authenticated and so, you would have to do it more manually as currently we don't support a service principal name used at AUTH to Gen Answers. In short, the better way is to automate the publishing of the files to Dataverse like in video I shared on how to do this to allow the content to be exposed.
This is a replica of what is in MS Copilot documentation which is not too great. Even after following everything, nothing gets answered from Sharepoint. It comes back with a response: "I’m sorry, I’m not sure how to help with that. Can you try rephrasing?"
I did everything correctly like setting up Authentication, adding right permissions, scopes etc but nothing is working.
This is great! was able to make it work last time but I have to define the SharePoint site in generative answers Node level and not on the Copilot level, because somehow its treating my sharepoint site URL as Public site and there is no option for me to change 'Public Website' to 'Sharepoint and Onedrive' data source. I can define it on Node level because there is another field specific for Sharepoint
Yes, that must be because you are using a public url for your sharepoint instance. You should report that as a bug though as we should be able to figure that out from DNS.
Are there best practices on the best way to store text information in use with Copilot. For example, let's say that I have 300 questions that customers have asked, and I have 300 responses we have given. I would like for the Copilot to answer new questions using the past answers and questions as a guide. Is it best to have a single document with every question and then answer, or have an excel document with questions in one column and answers in another, or have 300 individual documents with the question and answer within the document alone.
You could look at using CQA for this... I have an old video on how to use it... maybe that works for you.
I have a question. Is there any way to bypass the login step? Like is there any way we don't have to click on login , copy the code and send it in order to have access. Can we do authentication automatically?
If you publish your copilot studio app to Teams as Teams application there is not requirement for code provide anymore.
I followed all the steps but when it arrived at the part grant permission, I can't click on that like it won't allow me. Why is that?