Building and customizing solutions using Microsoft 365 Copilot APIs and tools
If the SharePoint knowledge source is configured and shows as ready, the most common reasons some files are not returned are these:
- Verify the files are actually usable by the knowledge source
- On the Knowledge page, confirm the missing files or folder are reported as Ready.
- If a file appears in the source but still never answers, possible causes include:
- unsupported characters in the SharePoint file name
- sensitivity settings such as Confidential or Highly Confidential
- password protection
- unsupported file type
- the file or folder not being shared with the account being used
- Check user permissions on the exact files
- Copilot Studio respects Microsoft 365 security trimming.
- The signed-in user must have at least read access to the specific SharePoint site and files.
- Open each missing file directly in SharePoint with the same user account used to test the agent.
- If possible, test the same query in Microsoft 365 Copilot Chat. If it also cannot retrieve the content, that points to a permission or search indexing barrier.
- Check whether the files are protected
- Files protected by an encrypting sensitivity label, Double Key Encryption (DKE), or a password can appear as Ready but still return no response.
- Open each missing file in SharePoint or the desktop app and check whether it shows encryption, DKE, or password protection.
- If organization policy allows it, remove that protection or publish an unprotected copy in a SharePoint location the agent can access.
- Check the SharePoint source path
- If the SharePoint site or folder was renamed after the knowledge source was added, the source link can break.
- In that case, update the knowledge source with a newly generated SharePoint link.
- If manual authentication is being used, verify the app registration and agent scopes
- The Microsoft Entra ID app registration must include
Sites.Read.AllandFiles.Read.All. - The agent authentication settings must also include
Sites.Read.AllandFiles.Read.Allalongsideprofileandopenid. - If consent for those scopes is missing, the agent can return no results without showing an error.
- If Restricted SharePoint Search is enabled in the tenant, SharePoint knowledge sources are blocked until the relevant sites are allowed.
- The Microsoft Entra ID app registration must include
- Check whether the missing item is a subfolder scenario
- Copilot Studio can index only up to the maximum number of files, folders, and subfolders for a SharePoint or OneDrive folder. Remaining items are not processed, and it does not indicate which ones were skipped.
A practical test path for this case:
- Open the 2 missing
.txtfiles directly in SharePoint with the same account. - Confirm those files are not encrypted, password-protected, or labeled with encrypting sensitivity protection.
- On the Knowledge page, verify whether those files are actually usable and not just present in the source.
- If manual auth is configured, verify
Sites.Read.AllandFiles.Read.Allexist in both the app registration and the agent authentication settings, and that consent was granted. - If the folder or site was renamed, replace the SharePoint source link.
If the agent can answer from one file but not the other two, that usually points to file-level permissions, protection, unsupported file conditions, or authentication scope issues rather than the SharePoint link itself.