Others

How to Retrieve Only Seven Days of SharePoint Analytics via Power Automate

Partner Editor Sep 28, 2026 869 views

Question details

The user wants to configure a Power Automate flow to return exactly seven days of SharePoint analytics, but is currently receiving 90 days of data.

How to Retrieve Only Seven Days of SharePoint Analytics via Power Automate

Product: Power Automate / SharePoint
Device & OS: not provided
Scenario: Building a custom Power Automate flow that utilizes HTTP requests to fetch SharePoint usage analytics.
Observed behavior: The HTTP request ignores the seven-day parameter or defaults to a 90-day reporting period.

Before you start

Before reaching out to support forums, make sure you have copied your exact request URI, headers, parameters, and a sample of the raw response data (with sensitive information removed).

Solution 1Recommended

Post Your Question in the Microsoft Power Automate Community

Because this issue involves custom flow logic and specific HTTP requests, the official Power Automate Community is the most effective place to get troubleshooting help from experts.

The Microsoft Power Automate community specializes in diagnosing custom HTTP request issues, including parameter configuration and API limitations.

Gather request details

Copy your exact HTTP request URI, the method (GET/POST), and the body or parameters you are using to request the seven-day period.

Navigate to the Community

Open your web browser and go to the official Microsoft Power Automate Community forum (powerusers.microsoft.com).

Submit your query

Create a new post detailing your flow, paste the configuration details, and explain that the endpoint is returning 90 days of data instead of seven.

Post Your Question in the Microsoft Power Automate Community

Include Screenshots: Adding screenshots of your flow's 'HTTP request' action often results in much faster and more accurate assistance from community members.

Solution 2

Ask in Microsoft Q&A Using Developer Tags

If your HTTP request involves the Microsoft Graph API or direct SharePoint development endpoints, Microsoft Q&A is the appropriate channel.

Free Microsoft Office alternative

Looking for a Lightweight and Free Office Alternative?

While resolving complex SharePoint APIs and Power Automate workflows requires specialized developer support, WPS Office offers a highly efficient, free alternative for handling your everyday document, spreadsheet, and presentation tasks.

1. Download the installer: Visit the official WPS Office website and click the free download button.
2. Install the suite: Run the downloaded installer file and follow the simple on-screen instructions.
3. Open and edit: Launch WPS Office and immediately start opening or editing your existing Microsoft Office files.

Fully compatible with Microsoft Word, Excel, and PowerPoint formats (.docx, .xlsx, .pptx).Analyze your exported SharePoint data effortlessly with WPS Spreadsheet.Lightweight installation with extremely fast launch times.Familiar user interface requires no learning curve.

Frequently Asked Questions

Why does my SharePoint analytics HTTP request default to 90 days?

Many SharePoint and Microsoft Graph usage analytics endpoints default to a 90-day rolling window if the date parameters are either formatted incorrectly, unsupported by that specific endpoint, or omitted entirely.

What parameters do I need to filter Microsoft Graph reports by date?

Depending on the exact endpoint, you typically use the 'period' parameter (e.g., period='D7' for seven days) or use the '$filter' query to specify exact 'startDateTime' and 'endDateTime' boundaries.

Can I export SharePoint analytics directly without Power Automate?

Yes. Site owners can navigate to Site Usage in the SharePoint settings and manually download the 7-day, 30-day, or 90-day analytics data as an Excel file for immediate analysis.

Office Quick Solutions