Forum Discussion

sohnash's avatar
sohnash
Brass Contributor
Aug 03, 2026

Looking for ideas: Reducing "Allow" prompts when using SharePoint Knowledge

Hello community members! I'm hoping to get some advice from people who may have come across a similar challenge with their Copilot Studio "SharePoint knowledge retrieval" agents 🤞

Current setup

  • Agent set up in Copilot Studio and published to channels - M365 Copilot and Teams
  • Agent is connected to 4 SharePoint folders (I'm using Method#1 - see below screenshot for reference). This is essential because the documents inside the folders contain both text and image-based content. This is the only method that brings results
  • Users have permissions to access the content in these folders

 

Problem

We are currently preparing to roll out this agent but we've hit a user experience issue that is becoming a blocker for moving forward.

When a user interacts with the agent for the first time, they are asked to click "Allow" ... 4 times .. one for each of the folder that the agent is connected to

 

 

 

 

 

This experience feels heavy for users (based on our pilot feedback) and people give up after the first or second time because they think it is not working. In spite of comms and a video about having to repeat this action until done. We want the first time experience to be as smooth as possible to drive adoption. Also, we are going to expand the solution to include more folders soon - so there is also a concern that number of consent prompts could grow further.

 

What I've tried

  • Used Method#2 to connect to SharePoint folders. While this didn't pop up the "Allow" prompts, as indicated earlier, this approach doesn't work because it doesn't return any results from documents as they contain both text and image content.
  • Tried Method#1 to connect to the library (and use instructions to indicate necessary folders) - this didn't work because the method doesn't allow to connect to libraries.
  • Note - I cannot restructure the library and put all the documents into one folder because that's the way the documents have been maintained for a long time & direct links to the folders are being used across the organization via. emails, decks etc.

 

Looking for advice

  • Has anyone found a way to reduce or eliminate these consent prompts?
  • Are there any other recommendations on using SharePoint as a knowledge source that respects user permissions without these consent prompts?
  • Does anyone know why Method#1 and Method#2 have different user experiences where the first one prompts for consent and the second doesn't?

Method 1 of connecting to SharePoint - currently in use

Method 2 of connecting to SharePoint - doesn't work with documents that contain text and graphics

 

No RepliesBe the first to reply