SharePoint
Index and search Microsoft SharePoint document libraries and site pages in Risotto
Connect your Microsoft SharePoint sites to Risotto to make document libraries and site pages searchable through the AI assistant.
What Gets Indexed
Risotto's SharePoint integration indexes:
- Document Libraries - Files stored in SharePoint drives (PDFs, Word documents, spreadsheets, etc.)
- Site Pages - SharePoint modern pages and wiki pages
Prerequisites
Before configuring SharePoint indexing in Risotto, you must create an Azure AD application with the appropriate permissions.
Step 1: Register an Azure AD Application
Access Azure Portal
Sign in to the Azure Portal and navigate to Microsoft Entra ID > App registrations. (Microsoft renamed Azure Active Directory to Microsoft Entra ID.)
Create New Registration
Click New registration and configure:
- Name: Enter a descriptive name (e.g., "Risotto SharePoint Integration")
- Supported account types: Select "Accounts in this organizational directory only"
- Redirect URI: Leave blank (not required)
Click Register.
Note Application Credentials
After registration, note these values from the Overview page:
Value Location Client ID Application (client) ID Tenant ID Directory (tenant) ID Create Client Secret
Navigate to Certificates & secrets > New client secret:
- Enter a description and select an expiration period
- Click Add
- Copy the secret value immediately - it will not be shown again
Step 2: Grant API Permissions
Add Permissions
Navigate to API permissions > Add a permission > Microsoft Graph > Application permissions.
Select Required Permissions
Add these permissions:
Permission Description Files.Read.AllRead all files in all site collections Sites.Read.AllRead items in all site collections Grant Admin Consent
Click Grant admin consent for [Your Organization].
Configure SharePoint in Risotto
Create a SharePoint Index
Go to Settings > Integrations > SharePoint and click Add site. If you have no index yet, click Add site on the Sites row. The Add a site dialog opens.
Enter Credentials
Fill in the required fields:
Field Description Example Name Descriptive name for this index. Must be unique. "Engineering Documentation" Site URL SharePoint site to index contoso.sharepoint.com/sites/engineeringClient ID Azure AD Application ID 00000000-0000-0000-0000-000000000000Tenant ID Azure AD Directory ID 00000000-0000-0000-0000-000000000000Client secret A vault credential that holds the Azure AD client secret. Choose it, or click Add a vault credential to create one. SharePoint client secretIf you already have a SharePoint index, the dialog fills in the client ID, tenant ID, and client secret from it.
The hint under Client secret names the Microsoft Graph permissions the app needs:
Files.Read.AllandSites.Read.All(Application type).Configure Optional Settings
Optionally specify:
Field Description Default Folder Specific folder to index. Empty reads the whole library and the site's pages. Entire site Department Restrict the index to one department Organization-wide Audience Everyone or Assistant only: who can receive answers Everyone Create Index
Click Add site. The site's card on the Knowledge tab shows the progress, and so does the Indexing Jobs panel on Knowledge > Indexes.
Create index on Knowledge > Indexes still adds a SharePoint index with the same details, plus Profile filters, which only that dialog has.
Site URL Formats
Risotto accepts several formats for the Site URL:
# Full URL (recommended)
contoso.sharepoint.com/sites/engineering
# Teams site
contoso.sharepoint.com/teams/marketing
# Site name only (will auto-resolve)
contoso
Folder Path Examples
To index only a specific folder within your SharePoint site:
# Root-level folder
/Documents
# Nested folder
/Documents/Reports/2024
# Specific project folder
/Projects/Product Launch
Supported File Types
| Category | Extensions |
|---|---|
| Documents | .pdf, .doc, .docx, .txt, .rtf, .odt |
| Spreadsheets | .xls, .xlsx, .csv |
| Web/Markup | .html, .htm, .md, .markdown |
Real-Time Updates
Risotto automatically keeps your index up-to-date using Microsoft Graph webhooks:
- New files/pages are indexed within minutes of creation
- Updated content is re-indexed automatically
- Deleted items are removed from the index
Access Control
Department Restriction
Restrict index access to specific departments:
- When creating or editing the index, select Department
- Choose a specific department or "Organization-wide (no department restriction)"
Profile filters
Use Profile filters to send answers from this index only to users whose profile matches the rules (for example, job title or location). Profile filters improve relevance. They are not an access control. To limit who can get answers from the index, use Audience.
Troubleshooting
Authentication Errors
Authentication failed or Invalid credentials
Solutions: - Verify Client ID, Client Secret, and Tenant ID are correct - Ensure the Client Secret has not expired - Confirm admin consent was granted for the API permissions
Site not found
Solutions: - Check the Site URL format - try using the full URL from your
browser - Verify the Azure AD app has Sites.Read.All permission - Ensure the
site exists and is accessible
Access denied or Insufficient permissions
Solutions: - Verify admin consent was granted for all required permissions
- Check that you granted Application permissions, not Delegated - Ensure
the permissions are
Files.Read.AllandSites.Read.All
Indexing Issues
No files indexed
Solutions: - Verify the folder path is correct (paths are case-insensitive) - Check that the document library contains supported file types
Index shows fewer files than expected
Solutions: - Verify the folder path is not too restrictive - Check the completion notice of the indexing job. Risotto skips a file that stops the indexer three times and lists it there with "Indexing failed 3 times". Split large files into smaller files, then reindex. - A file that is too large to index is skipped, and admins get a Document Too Large To Index warning.
Security Considerations
Credential Storage
- All Azure AD credentials are encrypted at rest
- Client secrets are never exposed in logs or UI after initial entry
- Credentials are isolated per organization
Data Access
- Risotto only reads content - no write access to SharePoint
- Indexed content is stored securely within your Risotto instance
- Access respects your configured department and profile rules
Webhook Security
- Webhook endpoints validate Microsoft Graph notification signatures
- Each subscription uses a unique client state for verification
- Invalid webhooks are rejected and logged
Limits
| Limit | Value |
|---|---|
| Webhook subscription lifetime | 30 days (auto-renewed) |
| Supported SharePoint versions | SharePoint Online only |
Next Steps
After setting up your SharePoint index:
- Test the integration using Knowledge > Playground
- Ask Risotto questions about your indexed documentation in Slack
- Monitor answer quality and adjust filters if needed
- Expand gradually by adding more indexes as needed
For additional help, contact support at support@tryrisotto.com.
Something wrong or missing? Report an issue · View as Markdown