How to generate responses from SharePoint Online sites using Copilot Studio|and setting up Entra ID

In the previous article, we looked at how to generate responses from a web page, so this time we will look at how to generate responses from a SharePoint Online site.

スポンサーリンク

Preliminary Preparation: Creating an SPO Site

Create an SPO site as a preliminary preparation.
Documents are also searched for when generating responses, so three PDF and three Word files were created.

Simply adding an SPO site results in an error

If you simply register the site you created in your preliminary preparation on the website,
※It is recommended to remove “https://” when registering SPO sites
An error occurs in the action to create a generative response.

Authentication settings: Register apps with Entra ID

Go to Azure Portal and open Entra ID.
Open the [Register App] tab and press [New Registration].
Give it a name and click “Register.
Now go back to Copilot Studio, go to [Settings] -> [Security] tab, click [Authentication], and note the [Redirect URL] that appears when you select [Manual].
Go back to [App Registration] in Entra ID again, select [Add Platform] under the [Authentication] tab, and click [Web].
Paste the URL you just wrote down into the redirect URL, check both in the “Implicit Permissions and Hybrid Flow” settings and press “Configure”.
Then go to the [Certificates and Secrets] tab, press [New Client Secret], enter a clear description and press [Add].
Note the [value] that appears,
Go back to the [Overview] tab and note the [Application (Client) ID].
Now return to Copilot Studio again, set the values you wrote down (Client Secret and Application (Client) ID), check the Require Users to Sign In checkbox, enter the following in the Scope, and press Save.

profile openid Sites.Read.All Files.Read.All
Finally, go back to the Entra ID application registration, press “Add Permissions” from the “API Permissions” tab, and select “Microsoft Graph”.
Select [Delegated Permissions] and check [openid] and [profile],
Scroll and check [Files.Read.All] and [Sites.Read.All].

Finally, press “~~ give consent of administrator” and the setup is complete!

Operation check

Ask Copilot for the information on the SPO site and click on the login prompt.
Accepted access permissions,
You will see a number, copy it,
If you paste this number and ask the question again after authentication is complete, it will generate an answer from the file on the SPO site!
* If no answer is produced, reload the screen.
They also create answers from articles.

However, sometimes they talk about information that is not on the SPO site (and the reference site is wrong).

It is a little unstable because it is still in preview and does not seem to support Japanese language well, but it would be very useful if Copilot can easily generate answers from the SPO site.

Related Articles

コメント

Copied title and URL