Skip to content

Recently Modified SharePoint Files (search: 'Documents')

The question it answers: Which SharePoint and OneDrive files were modified most recently?

Where in the appSharePoint Online › Sites › Recently Modified Files
WorkloadSharePoint Online
KindTable
DataRead from Microsoft 365 when someone first opens it, then kept for the report cache lifetime (Settings > Data & cache, 1 hour unless changed).
LicenceNo extra licence needed.
Report id (API and MCP)sharepoint.files.recently-modified
ColumnKeyType
NameNameLink
File URLFileUrlText
Last modifiedLastModifiedDateTime

Licence: No extra licence needed.

Application permissions on the IntensiveReports app registration (all permissions):

PermissionAPIWhat it allowsNote
Files.Read.AllMicrosoft GraphRead files in all site collections
Sites.Read.AllMicrosoft GraphRead items in all site collections
Data sources it reads
  • POST /v1.0/search/query (entityTypes driveItem, queryString 'Documents IsDocument:1', sorted by lastModifiedDateTime, paged with from/size)
  • GET /v1.0/sites/root?$select=siteCollection
GET /ir-api/v1/reports/sharepoint.files.recently-modified?size=100

An AI assistant reads it with the MCP tool get_report and the id sharepoint.files.recently-modified. The client needs the Read grant for SharePoint Online. See Using the API.