SharePoint Data Access - Seeking Guidance and Possible Call for Help

(0) Share

Report

Posted on by Angela23

114

Hi everyone,

I'm experiencing issues with accessing SharePoint data through our system. While it works some days, on others, the same queries yield no useful results. This inconsistency is challenging, and I'm wondering if it's a common problem or something specific to my setup. I've followed standard access procedures but still face limitations on what can be answered effectively.

Register an application on the Azure portal (https://portal.azure.com/).
- Copy the Application (client) ID and store it in notepad.
Set up Authentication:
- In the Azure portal, under the registered application, navigate to "Authentication" and add a platform, selecting "Web".
- Provide the URL for redirecting. This involves going back to Copilot Studio, navigating to Settings -> Security -> Authorization, selecting Manual for Custom website, and copying the Redirect URL.
- Use this URL in Azure under Redirect URLs and select the required options. You may need to add additional URLs as necessary.
Generate a Client Secret:
- In the Azure portal, under your application, go to "Certificates & secrets" and create a new client secret.
- Copy the value of the client secret and store it in notepad.
- Fill in the client ID and client secret back in Copilot Studio.
Configure API Permissions in the Azure Portal:
- Grant admin consent.
- Add permissions for Microsoft Graph, specifically Delegated permissions. Choose "openai profile," "Sites.Read.All," and "Files.Read.All".
Update Copilot Studio with Scopes:
- Back in Copilot Studio, add the permissions to the scope, including one for the site and one for files.

Could anyone who has navigated similar issues share their insights or offer guidance? Additionally, I would greatly appreciate the opportunity for a short call to discuss potential solutions. Please let me know if anyone is available for this.

Thanks in advance for your help!

Categories:

General topics

I have the same question (0)

All responses (13)

Answers (0)

adilei on at

Like (0)

Report

Queries do return results? You're not getting "I'm not sure how to help with that"?

Was this reply helpful? Yes No
Kabilesh 177 on at

Like (0)

Report

Hi everyone,

I'm experiencing a similar issue. From my perspective, when we initially initialize Copilot with the data source, it returns the desired results. However, after publishing and attempting to change the data source, any subsequent query requests consistently fail.

Could someone who has dealt with similar issues share insights or offer guidance?

Thank you in advance for your assistance!

Was this reply helpful? Yes No
adilei on at

Like (0)

Report

You will have to be more specific. 1. What is the data source? 2. If it's SharePoint, how are you setting up authentication 3. is it working from the test canvas?

Was this reply helpful? Yes No
Kabilesh 177 on at

Like (0)

Report

Hi @adilei ,

I'm using SharePoint as the data source, following the same approach as Angela. Here are the steps

1. Register an application on the Azure portal (https://portal.azure.com/).
2. Copy the Application (client) ID and store it in Notepad.
3. Set up Authentication:
- In the Azure portal, under the registered application, navigate to "Authentication" and add a platform, selecting "Web".
- Provide the URL for redirecting. This involves going back to Copilot Studio, navigating to Settings -> Security -> Authorization, selecting Manual for Custom website, and copying the Redirect URL.
- Use this URL in Azure under Redirect URLs and select the required options. You may need to add additional URLs as necessary.
4. Generate a Client Secret:
- In the Azure portal, under your application, go to "Certificates & secrets" and create a new client secret.
- Copy the value of the client secret and store it in Notepad.
5. Fill in the client ID and client secret back in Copilot Studio.
6. Configure API Permissions in the Azure Portal:
- Grant admin consent.
- Add permissions for Microsoft Graph, specifically Delegated permissions. Choose "openai profile," "Sites.Read.All," and "Files.Read.All".
7. Update Copilot Studio with Scopes:
- Back in Copilot Studio, add the permissions to the scope, including one for the site and one for files.

It was working fine in the test canvas as well as in the demo site.

Afert that, I uploaded new documents to the site and tried it around, but it didn't revert back with the response. It gives me the fallback all the times.

Was this reply helpful? Yes No
adilei on at

Like (0)

Report

Thanks. So just to be clear - you are still getting responses for your old documents?

It's only questions that expect content from the newly updated documents that do not get a response?

Was this reply helpful? Yes No
Kabilesh 177 on at

Like (0)

Report

Hi @adilei ,

Thanks for your reply. After uploading new documents, I'm not getting responses for either old or new documents.

Was this reply helpful? Yes No
adilei on at

Like (0)

Report

Hmmm..this seems puzzling. You change nothing, not the URL that the Gen Answers node is pointing to, nor the query itself, and you stop getting responses simply after uploading new files?

Was this reply helpful? Yes No
Kabilesh 177 on at

Like (0)

Report

Seems strange, right? I didn't change anything ,not the URL in the Gen Answers node or the query itself. But after uploading new files, responses stopped.

Was this reply helpful? Yes No
Angela23 114 on at

Like (0)

Report

My solution has started to answer again since the new release came to Euarope yesterday and I enabled the dynamic channing and it helped. It is still not answering all I ask but getting much better than before

Was this reply helpful? Yes No
Angela23 114 on at

Like (0)

Report

And today its back to not working mode again 😞

Was this reply helpful? Yes No