Forum Discussion

Ukhan's avatar
Ukhan
Copper Contributor
Mar 17, 2023
Solved

How to get analytics of a SharePoint file via email report?

Hi Community, We have a specific requirement where we need to get detailed analytics of a particular excel file hosted on our SharePoint Online site over email every day. We would like to get ...
Document Library
files
powershell
SharePoint Online
Sites
Usage
  • Jennifer_Wilson's avatar
    Jennifer_Wilson
    Mar 17, 2023

    Ukhan I had the same question couple of months ago :smile:
    I went through this article and set this up with Azure App registration it's working perfect since you have access to more resources in Graph.
    Check this:
    https://microsoft365.today/automating-sharepoint-file-analytics-reports-via-email-using-azure-functions-and-microsoft-graph-api/

     

    Review this and let me know if you have any questions. 

Jennifer_Wilson's avatar
Jennifer_Wilson
Brass Contributor
Mar 17, 2023

Ukhan I had the same question couple of months ago :smile:
I went through this article and set this up with Azure App registration it's working perfect since you have access to more resources in Graph.
Check this:
https://microsoft365.today/automating-sharepoint-file-analytics-reports-via-email-using-azure-functions-and-microsoft-graph-api/

 

Review this and let me know if you have any questions. 

Ukhan's avatar
Ukhan
Copper Contributor
Mar 21, 2023
Thanks Jennifer,

I followed all the steps from above article you shared.
I am getting python dependency errors. I created requirements.txt but it doesn't seem to be working. I am runing script in __init__.py
Here is the error screen
https://prnt.sc/4Vwhq9oOFcvT
here is requirements.txt
https://prnt.sc/Q2IW7aU88zF0
Any help would be highly appreciated
Thanks

Resources