# Read Microsoft SharePoint/Teams Excel files

**URL:** https://discourse.nodered.org/t/read-microsoft-sharepoint-teams-excel-files/76854
**Category:** General
**Created:** [23 March 2023 08:11 UTC](https://discourse.nodered.org/t/read-microsoft-sharepoint-teams-excel-files/76854 "2023-03-23T08:11:07Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![andre\_x](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@andre\_x](https://discourse.nodered.org/u/andre_x)
#### Post date: [23 March 2023 08:11 UTC](https://discourse.nodered.org/t/read-microsoft-sharepoint-teams-excel-files/76854/1 "2023-03-23T08:11:07Z")

</div>

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!

---

<div class="post-metadata">

### Author: ![TotallyInformation](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/totallyinformation/32/31_2.png) [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)
#### Post date: [23 March 2023 09:12 UTC](https://discourse.nodered.org/t/read-microsoft-sharepoint-teams-excel-files/76854/2 "2023-03-23T09:12:22Z")

</div>

The flows site lists 3 sharepoint related nodes:

[https://flows.nodered.org/search?term=sharepoint](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.

> **[GitHub - pnp/pnpjs: Fluent JavaScript API for SharePoint and Microsoft Graph...](https://github.com/pnp/pnpjs)**
>
> Fluent JavaScript API for SharePoint and Microsoft Graph REST APIs - GitHub - pnp/pnpjs: Fluent JavaScript API for SharePoint and Microsoft Graph REST APIs

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)
#### Post date: [22 May 2023 09:12 UTC](https://discourse.nodered.org/t/read-microsoft-sharepoint-teams-excel-files/76854/3 "2023-05-22T09:12:52Z")

</div>

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