I am trying to integrate the sharepoint as a data source with the Azure Copilot and create a generative response based on the documents in the sharepoint.

I am trying to integrate the sharepoint as a data source with the Azure Copilot and create a generative response based on the documents in the sharepoint.

To achieve above I tried the below steps.

1. Created a sharepoint website which is public.
2. Created a copilot with Generative AI enabled.
3. Added a sharepoint site as a data source to the Copilot.
4. Registered the application to azure EntraID where I recieved Client ID, Client Secret, Added API Permissions, Scope ( https://video2.skills-academy.com/en-us/microsoft-copilot-studio/configuration-authentication-azure-ad )
5. The Permissions were - Files.Read.ALL, Sites.Read.All, User.Read, profile, openid, offline_id
6. Authentication set to the Manual and provided the azure registered application details (Client ID, Client Secret, Scope - profile openid) AAD

The errors i am facing:

1. I am not able to publish the bot got the following error "Access denied for user to perform requested operation."

2. Not able to Login it says

If I upload the document directly or a web page as a data source in the Copilot, the bot creates the generative answers based on respective input. but not working for sharepoint integration.