Power Platform Community Forum Thread Details

Hello,

I'm trying do create a flow with PowerAutomate to put the analytics of my SharePoint sites in a Excel table.

I want to have a scheduled flow every 7 days. I have succeed to do it with this HTTP request :

/_api/v2.1/sites/***.sharepoint.com,948e3cf5-0de5-4683-88fb-0275932e183b/oneDrive.getAggregatedAnalytics?startDateTime=2023-06-28T10:20:07.849Z&endDateTime=2023-09-25T10:20:07.849Z&$expand=LastSevenDaysTopItemsByViewers($expand=pages($expand=analytics($expand=lastSevenDays)),documents($expand=analytics($expand=lastSevenDays)),news($expand=analytics($expand=lastSevenDays))),accessStatsByHour,platformStatsByDay,accessStatsByDay($expand=lastSevenDays,lastThirtyDays,lastNinetyDays,allTime,itemActivityStats)&select=*

The issue is that it appears always with the last 90days in my Excel.

Have you a solutions to have it only for the last 7days?

Thanks

Categories:

General topics