web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Copilot Studio / Copilot Studio Knowled...
Copilot Studio
Suggested Answer

Copilot Studio Knowledge Base + SharePoint – Access, Sync & ALM Questions

(0) ShareShare
ReportReport
Posted on by 1
Hi Community,
 
I’m building a Copilot Studio bot that answers questions from PDF documents used as a Knowledge Base, and I’m looking for guidance on the right architecture and best practices.
 
Context:
 
  • My knowledge content consists of PDFs stored in a SharePoint/LMS site

  • These PDFs are updated weekly

  • The bot is used by end users who should not be asked to authenticate against SharePoint or OneDrive

  • I’ve already created Dev and Prod environments

  •  
Problems I’m facing:
 

  1.  
    User credential prompt

    When I connect the Knowledge Base directly to SharePoint or OneDrive, the bot prompts users with “Connect to SharePoint / Allow access”.

    I want the bot to answer using background/service access, without exposing SharePoint permissions to users.
 

  1.  
    Maintaining weekly‑updated PDFs

    Uploading PDFs directly into Copilot Studio Knowledge works, but syncing weekly updates manually is not sustainable.

    I’m looking for a cleaner way to keep content updated.

  2.  
    Scoping knowledge content

    The SharePoint/LMS site contains many documents outside my domain.

    Ideally, I want to isolate only relevant PDFs (for example, sync selected docs into a restricted SharePoint library or OneDrive folder) and connect the Knowledge Base only to that location.

  3.  
    Dev/Prod & pipelines (secondary concern)

    I’m unable to create pipelines or deploy between Dev and Prod due to Knowledge Base restrictions.

    This isn’t a blocker right now, as we plan to move the Knowledge Base to a SharePoint‑based approach long term, but I’d like to understand if this limitation is expected.

  4.  
    Bot icon size

    The bot icon appears very compressed due to size limits in Copilot Studio — checking if there’s any supported workaround.

  5.  

     
 
Main question:

What is the recommended way to use frequently updated SharePoint PDFs as a Copilot Studio Knowledge Base without prompting users for SharePoint access, while keeping content scoped and manageable, and ideally ALM‑friendly?
 
Thanks in advance!
I have the same question (0)
  • Suggested answer
    AP-26031104-0 Profile Picture
    Microsoft Employee on at

     The issue you’re facing is expected when Copilot Studio is connected directly to SharePoint/LMS using user-delegated access. That’s what causes the “Connect to SharePoint / Allow access” prompt and makes ALM + syncing harder.

     

    Recommended approach that works reliably:

     

    1. Don’t connect Copilot directly to the full LMS

    • Create a separate SharePoint library/site like Copilot-Knowledge
    • Only store approved PDFs there (curated scope)

    2. Use service-based access (not user auth)

    • Use a service account or connection references (Dataverse)
    • This removes SharePoint login prompts for end users.

    3. Automate weekly updates

    Use Power Automate to:

    • Pull selected PDFs from LMS
    • Sync them into the Copilot-Knowledge librar  

     


       

    4. Connect Copilot only to the curated library


    • Keeps answers relevant and avoids noise from unrelated LMS content

    5. For ALM

    • Use environment variables + connection references
    • Or separate Dev/Prod SharePoint libraries

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Copilot Studio

#1
Valantis Profile Picture

Valantis 261

#2
Romain The Low-Code Bearded Bear Profile Picture

Romain The Low-Code... 214 Super User 2026 Season 1

#3
Vish WR Profile Picture

Vish WR 196

Last 30 days Overall leaderboard