Read Microsoft SharePoint/Teams Excel files

Hi all!
Is there a way to read a SharePoint/Teams Excel file, check the last edited time and send it (or better, it's content) via email?
Thanks!

The flows site lists 3 sharepoint related nodes:

https://flows.nodered.org/search?term=sharepoint

Not tried any of them.

Teams files are a folder on a SharePoint site related to the Teams channel.

A SharePoint/Teams file library is just a SharePoint list so if you can find a Node.js package that supports reading SP lists, you should be able to evaluate the last update time from the list. Otherwise, you have to open the excel workbook to read its last update metadata.


Just note that to programatically interact with Office 365, you normally have to register your "app" in Azure.

Also, the pnpjs library is the official library for interacting with SharePoint.

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.