You’re offline. This is a read only version of the page.
Announcements
22
I have a daily report sent to my email as an attachment in .xslx format. I am looking for a way to update the data in my SharePoint list based on the new report. It is a requirement to overwrite the data in the SharePoint List using the new incoming data in the report.
1) use an email trigger on your mailbox set to run based on the Subject line
2) Retrieve the Excel Attachment and if a Table doesn't exist create one
3) Save the file with the Table to ONeDrive
4) delay a minute (to let the file get saved
5) Open the file and read the table
6) Loop through each row. Use some key in the row to find the matching row in SharePoint
7) use the ID from the row you found in #6 to Update the SharePoint record
Share
Report
All responses (
Answers (
