Unanswered

Email Attachments - Download and Update File

(0) Share

Report

Posted on by Myatt42

I have a email come in from someone everyday and it has a excel file attached. Would there be a way to automatically download that excel file, or better yet, get the contents of the excel file and update another master sheet in my one drive? THe excel file is the same format everyday.

Thanks,

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Myatt42 how large is the excel file from which you need the contents? You can use List rows action to get data from rows in Excel and use that data to update another file in onedrive using Update Row action

Was this reply helpful? Yes No
Myatt42 35 on at

Like (0)

Report
Copy link

Link copied!

The excel file in the attachment has sometimes 1 row and upwards of 20. So from the email I can get the attachment and use the list rows from attachment?

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Myatt42 yes so first get the attachment from email and save it to onedrive using Create File action, then read the excel using List rows action.

Was this reply helpful? Yes No